Re: Consulta about BACKUP DB - Mailing list pgsql-admin

From jcmd@acer.com.mx
Subject Re: Consulta about BACKUP DB
Date
Msg-id Pine.LNX.4.21.0102021108200.25278-100000@cofradia.corp.mex
Whole thread Raw
In response to Consulta about BACKUP DB  (<vlal@ideay.net.ni>)
List pgsql-admin

pg_dump -Dn databasename > mybackupdatabasename.sql

to restore:

create databasename_new
psql -e databasename_new < mybackupdatabasename_new.sql

more information man pg_dump

regards

On Fri, 2 Feb 2001 vlal@ideay.net.ni wrote:

{Hi all,
{
{I going to cahge machine, but I need to make backup of my database, my
{version of postgresql is: 6.5.3 now my version will be 7.0.
{
{How can I to make the backup of tables, index and data?
{
{Thanks in advanced.
{
{
{


pgsql-admin by date:

Previous
From: "Leland V. Lammert"
Date:
Subject: Re: Dumb Question
Next
From: "jcmd@acer.com.mx"
Date:
Subject: Re: Insert failures