Received: from cepheus.azstarnet.com (cepheus.azstarnet.com [169.197.56.195]) by postgresql.org (Postfix) with ESMTP id DEB04476392 for ; Wed, 13 Mar 2002 12:46:55 -0500 (EST) Received: from [169.197.62.6] ([169.197.62.6]) by cepheus.azstarnet.com (8.9.3/8.9.3) with ESMTP id KAA09022; Wed, 13 Mar 2002 10:46:22 -0700 (MST) X-Sent-via: StarNet http://www.azstarnet.com/ X-Sender: jhassen@pop.azstarnet.com Message-Id: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 13 Mar 2002 10:46:21 -0700 To: arun kv , PGSQL From: Jon Hassen Subject: Re: backup postgres database X-Archive-Number: 200203/16 X-Sequence-Number: 985 try using the command: /usr/local/pgsql/bin/pg_dumpall > outputfile ('outputfile' is the name you want for your file) to make a backup of your database. put that copy where your new site will be. then use the new site to restore this file as if it belonged there in the first place by using the command: /usr/local/pgsql/bin/psql -d template1 -f outputfile ('outputfile' is the name you used in step 1) this restores the file you created in the first step to the new installation. that's it. you might have to run initdb, or initlocation on the new installation's data directory. Jon Hassen At 7:42 PM +0530 3/13/02, arun kv wrote: >hello sir, > i have a postgresql database in one system and want to transfer >the same to another system. i am not finding a way to transfer this >database from one system to another.if i transfer the file in >/var/lib/pgsql/libdatabase them it gives error.how shall i transfer >database. > another thing. how to take up backups of the database on the system. >pls help me as i am new to postgresql > thanking you > Arun > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster