Re: [Fwd: [Fwd: Re: UK BST Time Settings]]

Adam Tauno Williams wrote:
>> Adam Tauno Williams wrote:
>>     
>> {snip}
> I usually restore to my test server with:
>
> Backup:
> pg_dump --username=OGo --host=localhost --format=t --file=OGo.Ft.pg OGo
>
> Restore:
> dropdb OGo
> createdb -E UTF-8 -O OGo OGo
> pg_restore --verbose --format=t --dbname=OGo /home/awilliam/OGo.Ft.pg
>
> If the versions are the same you can use format "c" (binary) which is
> faster and produces a smaller file.
>
> I believe this is documented in the "PostgreSQL" chapter of WMOGAG.
>
>
>   
Thank you, That worked, although I'm sure I got the recipe  i was using 
from an earlier WMOGAG

Ken

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users