Re: Help With Database Backup

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-admin by date

  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