Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VlLtC-0003Yc-HE for pgsql-admin@arkaria.postgresql.org; Tue, 26 Nov 2013 16:53:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VlLtB-0000Ug-W9 for pgsql-admin@arkaria.postgresql.org; Tue, 26 Nov 2013 16:53:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VlLtA-0000Sy-Iw for pgsql-admin@postgresql.org; Tue, 26 Nov 2013 16:53:28 +0000 Received: from smtp2.zyquest.net ([72.44.255.254]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VlLt6-0003Fq-4w for pgsql-admin@postgresql.org; Tue, 26 Nov 2013 16:53:28 +0000 X-Envelope-From: andrew.krause@breakthroughfuel.com X-Envelope-To: ramanajvv@gmail.com Received: From Zy72-44-242-134.zyquest.net (72.44.242.134) by smtp2.zyquest.net (MAILFOUNDRY) id XeVdKFa6EeO6dQAl; Tue, 26 Nov 2013 16:46:59 -0000 (GMT) Received: from BTFPHXPMAIL01.breakthroughfuel.com ([10.20.0.87]) by BTFPHXPMAIL01 ([10.20.0.87]) with mapi id 14.03.0158.001; Tue, 26 Nov 2013 10:53:21 -0600 From: Andrew Krause To: joka veera Venkataramana CC: "" Subject: Re: Backup of database Thread-Topic: [ADMIN] Backup of database Thread-Index: AQHO6sa0gkj8QAdVI0eb/JEAjLB+05o4HwoA Date: Tue, 26 Nov 2013 16:53:20 +0000 Message-ID: <7AD89F7A-ADD0-4245-A07F-7FA750CABFEA@breakthroughfuel.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [67.53.157.2] Content-Type: text/plain; charset="iso-8859-1" Content-ID: <711C3C39A2BC34498A5D69266A55E182@breakthroughfuel.com> Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org I highly recommend that you review the page in the PostgreSQL documentation= for pg_dump before proceeding. If this is new to you, this page has all = the information you should need to get started (including examples at the b= ottom). http://www.postgresql.org/docs/9.2/static/app-pgdump.html You don't need pgadmin on any of your server machines. It's really just a = nice to have GUI client for the database. I recommend using psql if you're= connecting with a shell.=20=20 On Nov 26, 2013, at 10:28 AM, joka veera Venkataramana wrote: > Hi, >=20 > We have Postgresql server on Linux environment and have one database.=20 > Now we are planning to take the dump of database with pg_dump utility. >=20 > To use pg_dump utility do I need to install Pgadmin on Linux environment? >=20 > If yes, do we need to install Pgadmin with root user? because Postgre ser= ver instance we have installed with different user (not root user). >=20 > We are planning to take daily database dump in tar file format, so that i= t can occupy less space. Can you please provide the complete pg_dump and re= store command for tar file format. >=20 >=20 > I know all my questions are basic, why we are asking here is previously = we were in DB2 now we moved our database to Postgre (Its new for us). Pleas= e help us. >=20 > Thanks, > Veera. >=20 >=20 >=20 >=20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin