Connect Xtuple to postgres database

 

thor's picture

Hi

Please help.

I have installed the postgres db and iniatlised it for xtuple but cannot connect on to it. I can connect using openrpt.

I am using localhost as the server and prod as the database.

thanks in antcipation.

gmoskowitz's picture
Offline
Joined: 12/10/2008
Re: Connect Xtuple to postgres database

Thor,

Please supply a few more details:
What error message(s) do you get?
What version of the application (for that matter, which application) are you using to connect to the database?
Did you use one of the xTuple installers or did you download the example databases and restore them by hand?
...

Gil

samasura's picture
Offline
Joined: 03/30/2011
Connecting Xtuple to postgres database

How can I create a database on POSTgreSQL for use with xTuple BOOKs(ERP),I have just made an installation on the same machine running the SQL engine.

This is the error Fatal error no pg_hba entry on the host.

I have even created a database but cannot connect with a db super user

What do I need here?

Thanks

AttachmentSize
connect.doc 168 KB
sdifiore's picture
Offline
Joined: 10/21/2009
Sam, Are you using the

Sam,

Are you using the postooks instalator? It should create the database.

Which SO are you using? There are some issues regarding permissions in some Windows versiosn. By the way, which version of Postgres are you using?

Sergio

www.difiore.com.br

KIZILTAN's picture
Offline
Joined: 03/26/2011
New database

I have downloaded and installed two postbooks 3.6.0 editions, one in my office computer and the other in my home computer. There are 3 ready databases installed by the postbooks 3.6.0. I try to learn and get experienced with the software in my home computer. I enter datas to the empty database, such as chart of accounts, costumers, items, etc. What I want to do is to copy this empty database which I entered datas in my home computer and take it to my office computer and use it in the office. I can not copy the database file, because I could not find where this database file is. How would I copy this database file to my office computer.

wtonra's picture
Offline
Joined: 10/28/2007
Database back up/restore

KIZILTAN,
There is comprehensive documentation on managing the database here:

http://www.xtuple.org/docs/admin-and-setup/general-information

wesbaker's picture
Offline
Joined: 04/07/2011
I just downloaded the xTuple

I just downloaded the xTuple ERP postbooks version to evaluate. Unfortunately can't get past the login screen.

I have three options to login with the default being localhost/demo running on the local machine. Username and password are failing validation on both the localhost/demo option and on the "single-user demo with my xTuple web user" option.

Docs show a different login dialog with only two options but said to use the xtuple web username and password (same as I logged in here with). Doesn't work.

Was there a default username/password that I missed in the installation somewhere?

Wes

wesbaker's picture
Offline
Joined: 04/07/2011
Kill post. I found the

Kill post. I found the admin/admin