Re:

You can execute the pg_dump command:
pg_dump -f <filename> -d <database<

this command dumps a database into a text file that you can restore with
pg_restore

Vassilis Takidis wrote:

> How can i do backup of prosgres
> thanks
>
> ==================================================================
> Vassilis Takides General Data
> Business S.A.
> IT Consultant Tel: +3 010 6454045
>
> Fax: +3 010 6421357
> SUN Certified System Administrator
> SUN Certified Network Administrator
> CCNA
>
> E-mail: vtac(at)gdb(dot)gr
> http://www.gdb.gr
> ==================================================================
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.346 / Virus Database: 194 - Release Date: 10/4/2002
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org