Re: how to use pg_dump and then restored onto development server

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: "ketan shah" <ketan_dba(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to use pg_dump and then restored onto development server
Date: 2005-06-29 19:08:48
Message-ID: m2mzp90ym7.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> writes:

> OK..i get it. It works...
> My additional question is: how to incorporate timestamp in dumped file
> name ?
> Let's say, if we have script: pg_dump -f D:\MYDB_BCP -Fc -c -x -h
> localhost -U postgres MYDB,
> so that output file is named something like MYDB_BCP_2005-29-01, for
> example. Is that possible?

I'm sure it's possible, but I'm not an expert on Windows batch command
language. There are some good references for that stuff on the
web--check them out.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message D A GERM 2005-06-29 19:15:54 Re: Need help writing SQL statement
Previous Message Vivek Khera 2005-06-29 18:59:46 Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users