Re: Help With Database Backup

On Wed, Sep 30, 2009 at 6:38 AM, chalu <chaluwa@yahoo.com> wrote:
>
> 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.
>
> 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).
> It is the SQL statements from the backup that I am trying to execute online.
>
> Am I missing something, I'll appreciate suggestions / links  e.t.c
> Kind Regards.

What error message are you getting?  The most common problem is
running restore against a db that already has part of the schema in
place.  You might need to dropdb / createdb a new db for it to work.
Just guessing tho