Re: Reload only specific databases from pg_dumpall - Mailing list pgsql-general

From Guido Neitzer
Subject Re: Reload only specific databases from pg_dumpall
Date
Msg-id 3D57CFF9-2E33-4399-A90C-3676E9281875@event-s.net
Whole thread Raw
In response to Re: Reload only specific databases from pg_dumpall  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Responses Re: Reload only specific databases from pg_dumpall  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Lewis Cunningham
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Certification
Next
From: "fkater@googlemail.com"
Date:
Subject: Alternative to tableoids?