Received: from Morgoth.esiway.net (Morgoth.esiway.net [193.194.16.157]) by postgresql.org (Postfix) with ESMTP id 7D95E4768F7 for ; Wed, 13 Mar 2002 12:31:31 -0500 (EST) Received: from Megathlon.ESI (Ghost.esi.it [193.194.16.225]) by Morgoth.esiway.net (8.9.3/8.9.3) with ESMTP id SAA31660 for ; Wed, 13 Mar 2002 18:31:35 +0100 Received: from NOC2 (NOC2.ESI [10.10.10.39]) by Megathlon.ESI (8.11.5/8.11.5) with SMTP id g2DHVZ919264 for ; Wed, 13 Mar 2002 18:31:35 +0100 Message-ID: <005801c1cab4$ea8e4180$270a0a0a@esi> Reply-To: "Corrado Paparo" From: "Corrado Paparo" To: "PGSQL" References: Subject: Re: backup postgres database Date: Wed, 13 Mar 2002 18:31:31 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/13 X-Sequence-Number: 982 > 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 You can use the pg_dump utility (to extract a PostgreSQL database into a script file or other archive file) and the pg_restore utility (restore a Postgres database from an archive file created by pg_dump) or the psql interactive client. (see the 'Examples' on PostgreSQL 7.1 Documentation, PostgreSQL Client Applications reference) Bye Corrado