Re: Help With Database Backup

Поиск
Список
Период
Сортировка
От Julio Leyva
Тема Re: Help With Database Backup
Дата
Msg-id BLU102-W5E325F4AB5BD99DB13AF0A1D30@phx.gbl
обсуждение исходный текст
Ответ на Re: Help With Database Backup  ("Andy Shellam (Mailing Lists)" <andy-lists@networkmail.eu>)
Список pgsql-admin


> Subject: Re: [ADMIN] Help With Database Backup
> From: andy-lists@networkmail.eu
> Date: Wed, 30 Sep 2009 22:24:27 +0100
> CC: pgsql-admin@postgresql.org
> To: chaluwa@yahoo.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kenneth Banyas
Дата:
Сообщение: Seek info on 7.4.23 server/8.1.1 psql compatibility issues.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Seek info on 7.4.23 server/8.1.1 psql compatibility issues.