Thanks Craig, I've already done that.
On 11/11/2012 9:15 PM, Craig Ringer wrote:
On 11/11/2012 08:27 AM, Pat Heuvel wrote:
2012-11-05 23:03:07 EST LOG: could not open file
"pg_xlog/00010285002E" (log file 645, segment 46): No such
file or directory
If you haven't already, before
Gday Lukasz,
You're right - the service does run. However, no databases are visible.
I would love to be able to do a pg_dump/restore!
Can you tell me what might make postgresql think there are no databases
when the file pg_database and the file 1262 both show databases?
This is running on a
On 11/11/2012 08:27 AM, Pat Heuvel wrote:
>
> 2012-11-05 23:03:07 EST LOG: could not open file
> "pg_xlog/00010285002E" (log file 645, segment 46): No such
> file or directory
If you haven't already, before you do ANYTHING ELSE, take a file-system
level copy of the PostgreSQL database
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
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