Search Postgresql Archives

Re: Forgot to dump old data before re-installing machine

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



When I start the postmaster it seems ok. But there is no process
running.

Then it didn't really start successfully.  (Unless you use the -w
option, "pg_ctl start" just launches the postmaster --- it doesn't
wait around to see what happens.)  You need to look into the log
file to see what the problem was.

Ok, it's a bit confusing for a non-admin-user to enter into the pg- config to find out what parameters one has to uncomment in order to get the log working. Succeed after some while, got the postmaster working:

827 p2 S 0:00.22 /usr/local/bin/postmaster -D /usr/local/ pgsql/data TERM=xterm-color SHELL=/bin/bash USER=postgres __CF_USER_TEXT_ENCODING=0x1F6:0:0 P
  829  p2  S      0:00.01 postgres: writer process
  830  p2  S      0:00.00 postgres: stats buffer process
  831  p2  S      0:00.00 postgres: stats collector process


What would you recommend now in order to get the data back? I have postgis data in the databases too, although this is not too important for me...

Thanks you so much for all your help!

Stef

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux