From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
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:28:04 |
Message-ID: | dcc563d10909301428p2327973dve380007aadbcb5a0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Sep 30, 2009 at 6:38 AM, chalu <chaluwa(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Banyas | 2009-09-30 21:56:15 | Seek info on 7.4.23 server/8.1.1 psql compatibility issues. |
Previous Message | Andy Shellam (Mailing Lists) | 2009-09-30 21:24:27 | Re: Help With Database Backup |