On Wed, Sep 30, 2009 at 6:38 AM, chalu <[email protected]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
