Hi Kirk,
How's it going?
You can use pg_dump on the local host to access a db on a remote host, & as the
output is just SQL, pipe this directly intp a psql command, thus
replicating/migrating a database.
One note, if you are doing this with a PostGIS db, I find it works better to
create an em
On Fri, Oct 16, 2009 at 6:11 PM, Kirk Wythers wrote:
> On Oct 16, 2009, at 4:51 PM, Scott Marlowe wrote:
>
>> On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers wrote:
>>
>>> Any ideas what the problem could be here?
>>
>> Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
>> from 8.
On Oct 16, 2009, at 4:51 PM, Scott Marlowe
wrote:
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers
wrote:
Any ideas what the problem could be here?
Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
from 8.3.8 to 8.4.1, use the pg_dump that comes with 8.4.1 to dump the
8.
On Fri, Oct 16, 2009 at 11:25 AM, Kirk Wythers wrote:
> Any ideas what the problem could be here?
Use the pg_dump from the target (i.e. newer) pgsql. I.e. if going
from 8.3.8 to 8.4.1, use the pg_dump that comes with 8.4.1 to dump the
8.3.8 database.
I usually just do it like so:
(First migra
2009/10/16 Kirk Wythers :
> I am trying to move databases to another macine (and update from 8.2 to 8.4
> along the way). I first tried pg_dumpall, but I found that one of the data
> bases did not restore and data, just an empty db with no tables. Since then
> I have tried pg_dump with the followin
