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@gdb.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@postgresql.org