ronald, to backup pgsql:
pg_dump dbnamehere > dbnamehere.sql to retrieve/extract: 1. dropdb dbnamehere 2. createdb dbnamehere 3. psql -e dbnamehere < dbnamehere.sql please note that you su'ed to 'postgres' or the pgsql user/administrator before you can initiate the backup and retrieval procedures. Quoting "Glynn S. Condez" <[EMAIL PROTECTED]>: > Hi Ronald, > > I am not a postgres or database admin but I hope I could help you somehow. > Backup'ng of database like postgres uses a special command like pg_dump. > > pg_dump and psql are your friends and will help you a lot. dont forget to use > > manpages you can find the options to dump with all the create statements > you might need. > > I dunno why you use tar to backup the database, maybe you have a special > reason? > > > HTH > glynn > > > ----- Original Message ----- > From: Ronaldo Chan > To: [EMAIL PROTECTED] > Sent: Thursday, January 01, 1998 12:57 AM > Subject: [plug] Tar Problem > > > > Pluggers, > > 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 > > > tar: ../pgdata.7.1.3/base/18721/16579: Member name contains `..' > ../pgdata.7.1.3/base/18721/16600 > tar: ../pgdata.7.1.3/base/18721/16600: Member name contains `..' > ../pgdata.7.1.3/base/18721/16617 > tar: ../pgdata.7.1.3/base/18721/16617: Member name contains `..' > ../pgdata.7.1.3/base/18721/16642 > tar: ../pgdata.7.1.3/base/18721/16642: Member name contains `..' > ../pgdata.7.1.3/base/18721/16653 > tar: ../pgdata.7.1.3/base/18721/16653: Member name contains `..' > ../pgdata.7.1.3/base/18721/16685 > tar: ../pgdata.7.1.3/base/18721/16685: Member name contains `..' > ../pgdata.7.1.3/base/18721/16867 > tar: ../pgdata.7.1.3/base/18721/16867: Member name contains `..' > ../pgdata.7.1.3/base/18721/16934 > tar: ../pgdata.7.1.3/base/18721/16934: Member name contains `..' > ../pgdata.7.1.3/base/18721/16948 > tar: ../pgdata.7.1.3/base/18721/16948: Member name contains `..' > > Any idea would really appreciated > H o w a r d R. B a g c a t WebAdmin, MUWeb - Edition 4 Project <http://www.mu.edu.ph> Systems Programmer, RBT/RBK & MUMC Project Misamis University.Ozamiz City.Philippines tel: 088.521.0367.local.109 | cel: 63.0919.5536179 Imagination is more important than knowledge -Albert Einstein Sulat @MU v.2.2 (Fresh) ....................................................................................... An extended module for MUWeb4 Project of Howard R. Bagcat Powered by GNU General Public License softwares. http://my.mu.edu.ph - a personalized portal is soon to come. _ 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]
