On Fri, 2009-07-03 at 15:00 +0100, Vanessa Lopez wrote: > I don't know much about postgre, I have no clue what else I can do. > Please, please any help is very very much appreciated I have lots of > databases and months of work in postgre (also lots of backups for the > data in /data)
When you say "in /data", do you mean the directory that contains the directories "pg_xlog", "base", "global", "pg_clog", etc ? Did you back up and restore the WHOLE data directory at once? Or did you restore only parts of it? When restoring, did you: - Stop PostgreSQL - Check with "ps" to ensure no 'postgres' or 'postmaster' instances were still running - Move the old data directory out of the way - Copy the backup data directory from your backups - start PostgreSQL ? Have you checked the file system and disk to make sure they're OK? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
