Hi there fellow admins, One of our databases had to be restored from a backup tape. Since there weren't any dumps made. All I had was a live backup (I know I know) of /var/lib/postgres/data/base/<number>. The number for the corresponding database I manages to discover after some searching with strings and grep. First of all: isn't there an easy way or a file to look up the number for the corresponding databases??
Second question... what could have gone wrong while restoring just the corresponding directory for the database? In the log files I only found out that the database wasn't shut down properly (when I started postgres again after the restore) which I assume is correct because it was restored from a live system backup. One CLOG file turned up to be missing, however no database-transactions are used in this database application. Recovery was done and successful by postmaster. The database is now up and running. The website running from the content works fine again. All records including BLOBS are there as well. In PSQL no strange warnings or errors... HOWEVER.... when I browse the DB with PHPPGADMIN (version 2.4.1-2) I get all kinds of resultset errors. For example: "Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/share/phppgadmin/db_details.php on line 344" And this is ONLY for tables from the restored DB, the other (non-restored) DB's give no PHPPGADMIN DB-errors. Has anyone a clue what could be wrong. Or are there tools I can run to do more consistency checks / rebuilds / whatever. Postgres version: 7.2.1-2woody4 Thanks in advance!! -- Kind regards, Jo Voordeckers ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html