Re: Help With Database Backup - Mailing list pgsql-admin

From Andy Shellam (Mailing Lists)
Subject Re: Help With Database Backup
Date
Msg-id 06871E18-3ECD-4BF8-95C8-A5C4D70B88F8@networkmail.eu
Whole thread Raw
In response to Help With Database Backup  (chalu <chaluwa@yahoo.com>)
Responses Re: Help With Database Backup
List 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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Help With Database Backup
Next
From: Olivier Nicole
Date:
Subject: postgres 8.4 authentication with LDAP