Re: Reload only specific databases from pg_dumpall

From: Guido Neitzer <lists(at)event-s(dot)net>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: "Postgresql General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reload only specific databases from pg_dumpall
Date: 2008-02-04 18:54:11
Message-ID: 3D57CFF9-2E33-4399-A90C-3676E9281875@event-s.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04.02.2008, at 10:41, Gurjeet Singh wrote:

> What was the output format option used (-f option) ? Was it the
> plain-text (SQL) or custom format?

I cannot see a -f option on pg_dumpall. This is the command:

pg_dumpall > `date "+%y-%m-%d"`.sql

I just want to use an older file from a dump to restore a server, but
I don't want to reload all databases (because that will take way
longer).

cug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2008-02-04 18:54:35 Re: [Cert] Re: PostgreSQL Certification
Previous Message Lewis Cunningham 2008-02-04 18:50:37 Re: [GENERAL] PostgreSQL Certification