Re: Failed to restore/recreate database (one more piece of info)

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Cc: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Failed to restore/recreate database (one more piece of info)
Date: 2009-11-17 17:25:09
Message-ID: 200911171825.09506.guillaume@lelarge.info
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin

Le mardi 17 novembre 2009 à 07:57:41, Tena Sakai a écrit :
> Hi Tom,
>
> Many thanks for your assistance.
>
> I am on my way. Here's what I am doing:
>
> dropdb musket
> createdb musket
> pg_dump canon > canon.dump
> psql -d musket -f canon.dump
>
> I am on the 4th step. But I could achieve the same with:
>
> dropdb musket
> createdb musket
> pg_dump canon | psql -d musket -f -
>
> can't I?

You can do it this way.

> Aside from styling, there is no functional difference
> between two procedures, is there?
>

You're right, there are no functional differences.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2009-11-17 17:29:10 Re: Differences in installing Postgres 8.3.8
Previous Message Tena Sakai 2009-11-17 06:57:41 Re: Failed to restore/recreate database (one more piece of info)