Im playing around with the BR features of PostgreSQL 7.4 for a PostgreSQL-BR course.
Q1: Let's imagine, we have a database cluster containing DB1, DB2 and DB3. System (disk) crashes and we are only able to recover DB2 (was on a local disk not on the external like DB1 and DB3). Bring it up again, everything is fine...
But then I want to clean up a little and drop the missing DB's (e.g. to install them from scratch):
DB2=# \l List of databases Name | Owner | Encoding -----------+----------+----------- DB1 | postgres | SQL_ASCII DB2 | postgres | SQL_ASCII DB3 | postgres | SQL_ASCII template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII (5 rows)
DB2=# drop database DB1; ERROR: database "db1" does not exist
* How can I clean up the database cluster after this scenario?
* Is the database cluster so fare so well ok now for further production or do we have to dump?
Q2: New situation: Why is it not a good idea to backup the database files of a cluster incl. all c_log and x_log (log files last) to get a "physicaly hot backup".
In principle it is the same situation like a server which is crashing (not a once but during some time). After restoring, it should do a redo and rollback automatically like after a crash. This methode (physical hot backup) would increas backup and restore times dramatically.
Thanks for clearing up Oli
-------------------------------------------------------
Oli Sennhauser Database-Engineer (Oracle & PostgreSQL) Rebenweg 6 CH - 8610 Uster / Switzerland
Phone (+41) 1 940 24 82 or Mobile (+41) 79 450 49 14 e-Mail [EMAIL PROTECTED] Website http://mypage.bluewin.ch/shinguz/PostgreSQL/
Secure (signed/encrypted) e-Mail with a Free Personal SwissSign ID: http://www.swisssign.ch
Import the SwissSign Root Certificate: http://swisssign.net/cgi-bin/trust/import
smime.p7s
Description: S/MIME Cryptographic Signature