| From: | "Andy Shellam (Mailing Lists)" <andy-lists(at)networkmail(dot)eu> |
|---|---|
| To: | chalu <chaluwa(at)yahoo(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Help With Database Backup |
| Date: | 2009-09-30 21:24:27 |
| Message-ID: | 06871E18-3ECD-4BF8-95C8-A5C4D70B88F8@networkmail.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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).
I believe if you don't select "schema only" you get schema and data.
Regards,
Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-09-30 21:28:04 | Re: Help With Database Backup |
| Previous Message | Stephen Frost | 2009-09-30 15:28:33 | Re: postgresql 8.x history |