Unable to connect database

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

Re: Unable to connect database

Postby PitbullRiga » Mon Sep 02, 2013 10:48 am

PostgreSQL is instaled on C:/xxx but data base on F:/data . When I reinstal pg9.0 i choose same /data destination as before - F:/data. http://postimg.org/image/vhybs4rv3/
PitbullRiga
 
Posts: 12
Joined: Tue Apr 03, 2012 11:47 am

Re: Unable to connect database

Postby kraada » Mon Sep 02, 2013 10:50 am

Right click the data folder, click Properties, and go to the Security tab. Do you see the postgres user in the top of the window?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to connect database

Postby PitbullRiga » Mon Sep 02, 2013 11:16 am

Yes. postgrs has full control.
PitbullRiga
 
Posts: 12
Joined: Tue Apr 03, 2012 11:47 am

Re: Unable to connect database

Postby kraada » Mon Sep 02, 2013 11:44 am

In the pg_log folder do you see a file for the most recent start attempt? If so, what's in the file?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to connect database

Postby PitbullRiga » Mon Sep 02, 2013 12:02 pm

2013-09-02 18:52:10 BST LOG: database system was interrupted; last known up at 2013-08-27 14:10:21 BST
2013-09-02 18:52:10 BST LOG: could not open file "pg_xlog/000000010000001B000000CF" (log file 27, segment 207): No such file or directory
2013-09-02 18:52:10 BST LOG: invalid primary checkpoint record
2013-09-02 18:52:10 BST LOG: could not open file "pg_xlog/000000010000001B000000CC" (log file 27, segment 204): No such file or directory
2013-09-02 18:52:10 BST LOG: invalid secondary checkpoint record
2013-09-02 18:52:10 BST PANIC: could not locate a valid checkpoint record


This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

2013-09-02 18:52:10 BST LOG: startup process (PID 3844) exited with exit code 3
2013-09-02 18:52:10 BST LOG: aborting startup due to startup process failure
2013-09-02 18:52:11 BST FATAL: the database system is starting up
PitbullRiga
 
Posts: 12
Joined: Tue Apr 03, 2012 11:47 am

Re: Unable to connect database

Postby kraada » Mon Sep 02, 2013 7:17 pm

Please check your antivirus to see if it quarantined any files from the pg_xlog folder. Also check to make sure you didn't delete them accidentally - if you did, then restoring them (or removing them from the quarantine) will fix things -- if not, you are going to need to delete the data directory, uninstall PostgreSQL and start from scratch.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 8 guests

cron
highfalutin