Re: how to use pg_dump and then restored onto development server - Mailing list pgsql-general

From Douglas McNaught
Subject Re: how to use pg_dump and then restored onto development server
Date
Msg-id m2mzp90ym7.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Re: how to use pg_dump and then restored onto development server  ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>)
Responses Re: how to use pg_dump and then restored onto development server
List pgsql-general
"Zlatko Matic" <zlatko.matic1@sb.t-com.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

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users
Next
From: D A GERM
Date:
Subject: Re: Need help writing SQL statement