From: Samuel Stearns <SStearns@internode.com.au>
To: Khangelani Gama <Khangelani.Gama@ucs-software.co.za>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3
Date: Wed, 26 May 2010 08:15:05 +0930
Message-ID: <68B59BEDCD36854AADBDF17E91B2937A01A57CCDF4@EXCHMAIL.staff.internode.com.au> (raw)
In-Reply-To: <D78A8169F9436B4DB978300336168F3B3359E501D3@SWBREXCH00.ucs-software.net>
References: <D78A8169F9436B4DB978300336168F3B3359E501D3@SWBREXCH00.ucs-software.net>
Try this:
pg_dump -a source_db | psql target_db
Sam
________________________________
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Khangelani Gama
Sent: Tuesday, 25 May 2010 5:45 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3
Hi all
I would like to know the quickest way of dumping and restoring the database in version 8.3 of PostgreSQL database running in RedHat 5.3.
We are currently using the command below, which seems to be very slow. We are moving from individual database to centralized database
pg_dump -U enterprisedb -Fc -t ${i} --data-only --ignore-version ${STORE_DB_HOST} -p ${DB_PORT} ${STORE_DB} | ${PG_BIN}/pg_restore -U enterprisedb -p ${DB_PORT} -t ${i} --data-only --dbname=${CDBS_DB}
Please assist...Thanks in advance
Thanks
Confidentiality Notice:http://ucs.co.za/conf.html
________________________________
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of UCS Group and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediately and destroy the e-mail. UCS Group Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: SStearns@internode.com.au, Khangelani.Gama@ucs-software.co.za
Subject: Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3
In-Reply-To: <68B59BEDCD36854AADBDF17E91B2937A01A57CCDF4@EXCHMAIL.staff.internode.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox