Depends what you want if you want schema, inserts etc.
Do pg_dump --help for a list of the valid switches and these will tell you
what they do
Darren
Darren Ferguson
Software Engineer
Openband
On Thu, 7 Feb 2002, David Siebert wrote:
> what is the best way to backup a database?
> The database I am working with does have a few columns that are of the type
> text.
> I know i should use pg_dump but what should the command line be?
>
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Doug McNaught
> Sent: Thursday, February 07, 2002 3:37 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Release docs
>
>
> The website still has the 7.1 doc set under "Release Docs"--shouldn't
> that be updated?
>
> I'm looking at "http://www.us.postgresql.org/users-lounge/docs/"...
>
> -Doug
> --
> Let us cross over the river, and rest under the shade of the trees.
> --T. J. Jackson, 1863
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>