Re: [GENERAL] Export and import from one postgres server to another

2012-05-30 Thread Guillaume Lelarge
On Wed, 2012-05-30 at 09:56 +0800, Craig Ringer wrote: > On 05/29/2012 02:27 AM, Alexander Reichstadt wrote: > > Hi, > > > > I am trying to "simply" export my postgres database from one server and > > then import it into another. I thought I could use PhpPgAdmin, but the > > hints on the web don'

Re: [GENERAL] Export and import from one postgres server to another

2012-05-29 Thread Craig Ringer
On 05/30/2012 10:01 AM, Adrian Klaver wrote: On 05/29/2012 06:56 PM, Craig Ringer wrote: On 05/29/2012 02:27 AM, Alexander Reichstadt wrote: Hi, I am trying to "simply" export my postgres database from one server and then import it into another. I thought I could use PhpPgAdmin, but the hint

Re: [GENERAL] Export and import from one postgres server to another

2012-05-29 Thread Adrian Klaver
On 05/29/2012 06:56 PM, Craig Ringer wrote: On 05/29/2012 02:27 AM, Alexander Reichstadt wrote: Hi, I am trying to "simply" export my postgres database from one server and then import it into another. I thought I could use PhpPgAdmin, but the hints on the web don't seem to work. One said to s

Re: [GENERAL] Export and import from one postgres server to another

2012-05-29 Thread Craig Ringer
On 05/29/2012 02:27 AM, Alexander Reichstadt wrote: Hi, I am trying to "simply" export my postgres database from one server and then import it into another. I thought I could use PhpPgAdmin, but the hints on the web don't seem to work. One said to simply get a dump from one phpPgAdmin, the go

Re: [GENERAL] Export and import from one postgres server to another

2012-05-29 Thread Merlin Moncure
On Mon, May 28, 2012 at 1:27 PM, Alexander Reichstadt wrote: > Hi, > > I am trying to "simply" export my postgres database from one server and then > import it into another. I thought I could use PhpPgAdmin, but the hints on > the web don't seem to work. One said to simply get a dump from one >

Re: [GENERAL] Export and import from one postgres server to another

2012-05-29 Thread Alban Hertroys
On 29 May 2012 14:58, Adrian Klaver wrote: > Q: Why can't I reload the SQL script I dumped in the SQL window? > > A: The following limitations currently exist in SQL script execution: > >        * 'psql' commands such as '\connect' will not work at all. Wait a minute! They use the pg_dump utility

Re: [GENERAL] Export and import from one postgres server to another

2012-05-29 Thread Adrian Klaver
On 05/28/2012 11:27 AM, Alexander Reichstadt wrote: Hi, I am trying to "simply" export my postgres database from one server and then import it into another. I thought I could use PhpPgAdmin, but the hints on the web don't seem to work. One said to simply get a dump from one phpPgAdmin, the go t

Re: [GENERAL] Export and import from one postgres server to another

2012-05-28 Thread Sergey Konoplev
On Mon, May 28, 2012 at 10:27 PM, Alexander Reichstadt wrote: > I am trying to "simply" export my postgres database from one server and then > import it into another. I thought I could use PhpPgAdmin, but the hints on > the web don't seem to work. One said to simply get a dump from one > phpPgA

[GENERAL] Export and import from one postgres server to another

2012-05-28 Thread Alexander Reichstadt
Hi, I am trying to "simply" export my postgres database from one server and then import it into another. I thought I could use PhpPgAdmin, but the hints on the web don't seem to work. One said to simply get a dump from one phpPgAdmin, the go to the other server, select the database, click the S