On Thu, Jan 01, 1998 at 12:57:00AM +0800, Ronaldo Chan wrote: > Today we backup our postgres database using tar tar czvf > backup.tar.gz /dbms/data without problem, but when i try to extract > the archive it give's me an error
Have you considered backing it up using pg_dumpall(1) instead? This tool comes wich the PostgreSQL distribution and exports your database and table structures together with your data, allowing you to rebuild your system from scratch on any PostgreSQL server. It is also the recommended method for backing up PostgreSQL databases during certain upgrades. --> Jijo -- Federico Sevilla III : http://jijo.free.net.ph : When we speak of free Network Administrator : The Leather Collection, Inc. : software we refer to GnuPG Key ID : 0x93B746BE : freedom, not price. _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
