[ADMIN] No databases visible on pg 8.3 server

2012-11-10 Thread Pat Heuvel
Gday, My customer has a large database running under 8.3. I would love to upgrade, but that's a story for another thread :) User called me and told me the database was out of space. I managed to recover a little space by moving the text logs (pg_log) to another drive. I then had a process r

Re: [ADMIN] No databases visible on pg 8.3 server

2012-11-10 Thread Lukasz Brodziak
Hello, >From what you have written I assume you are able to properly start postgresql service. First thing I would try would be trying to connect to the db with psql and run some queries mostly SELECTS to check if table data is ok. If successful then run a pg_dump on the db and restore it on a fre