Re: Help With Database Backup

> Subject: Re: [ADMIN] Help With Database Backup
> From: andy-lists(at)networkmail(dot)eu
> Date: Wed, 30 Sep 2009 22:24:27 +0100
> CC: pgsql-admin(at)postgresql(dot)org
> To: chaluwa(at)yahoo(dot)com
>
> Hi,
>
> >
> > Hello there, I am new to PostgreSQL, succeded in running a little
> > database on
> > my dev. machine and now I am having problems exporting the local
> > database to
> > the one I want to use on my site online. I am getting errors when I
> > try to
> > run the SQL online with phpPgAdmin.
>
> What errors are you getting? It's impossible to give you any help
> unless you can provide a bit more information.
>
> >
> > I exported / backup the local database using pgAmin, I choose the
> > PLAIN
> > format and then selected the No Owner option as well as the Schema
> > Only
> > option (how canI export schema and data at once).

as postgresql user
pg_dump dbname > anyname.out
copy the .out file to your target box

in your target box as postgresql user

createdb dbname
psql dbname -f anyname.out

>
> I believe if you don't select "schema only" you get schema and data.
>
> Regards,
> Andy
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin