Set up problems

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Set up problems

Postby Joss » Tue Dec 02, 2008 5:02 pm

Hi all

Just a query .. a friends is unable to set up his PT3 because of a Postgre problem ..

unable to create postgresql database, reason- unable to login to database, server closed connection unexpectedly

Any ideas as to what it may be ?

Thanks in advance
Joss
 
Posts: 101
Joined: Fri Feb 08, 2008 1:57 pm

Re: Set up problems

Postby WhiteRider » Tue Dec 02, 2008 7:15 pm

This means that postgres isn't running.
Please try starting the postgres service: Start -> Programs -> PostgreSQL -> Start Service.
If that, and a reboot doesn't work, try stopping the service (Start -> Programs -> Postgres -> Stop Service), running a search on your computer for postmaster.pid and then deleting that file, then restarting the service and see if that helps.
Note that you may need to turn on 'View hidden files and folders', and the file seems to be in the folder './Program Files/postgresql/[version]/data'.
See also: viewtopic.php?f=17&t=6332#p38285

If that doesn't help, select the last few files in C:\Program Files\PostgreSQL\8.3\data\pg_log (they're dated so just pick the recent ones), right-click and choose 'Send To Compressed/zipped Folder', then attach the zip file to a ticket on the Support system, and link to this thread in the reference field of the ticket so that we can investigate.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 65 guests

cron
highfalutin