Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 Can't get pgsql to start under a2t.
Post new topic Reply to topic
Author Message

Joined: 20 Apr 2006
Posts: 6
Location: Indianapolis, IN

PostPosted: Thu Apr 20, 2006 4:03 pm Reply with quoteBack to top

I have been running a2t 1.4.3 with it's components for several months without problems. Unfortunately, due to storms last week, my system had a power outage and did not shut down appropriately. Now I cannot log into or access my db, because I cannot get postgresql server to start. I have tried starting from the cp, I have tried restarting the system several times. I have done site searches and internet searches and found that the power outage may be the culprit, but all their fixes don't work. I can't find a postmaster.pid file to delete. All permissions on files seem set right. I run command line pg_ctl start -D {datapath} and I get this error:
"Execution of PostgreSQL by a user with administrative permissions is not permitted.
The server must be started under an unpriveliged userID to prevent possible system security compromises."

I'm not sure what to do other than uninstall and reinstall, but I don't want to lose my db info. Can I copy folders and put them back in after a reinstall?

Any help would be appreciated.

View user's profileSend private messageSend e-mail
Vlad Alexa Mancini
lead developer
lead developer

Joined: 07 Jul 2003
Posts: 1539

PostPosted: Fri Apr 21, 2006 8:32 am Reply with quoteBack to top

backing up pgsql\data and restoring should be fine
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic

 Jump to:   

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT