[postgis-users] moving a PostGIS db from one server to another

[Paragon Corporation]

Puneet,
You might want to try using --jobs as well.  I do that for databases above
8.4.

You should also be able to see the tables restoring if you do a 

SELECT * FROM pg_stat_activity

We suspect you have some stupid wrong like pg_restore is waiting for a
password.

Leo and Regina
http://www.postgis.us


> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Paul Ramsey
> Sent: Saturday, February 11, 2012 9:49 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] moving a PostGIS db from one 
> server to another
> 
> Seems very reasonable to me.
> P
> 
> On Sat, Feb 11, 2012 at 12:57 PM, Puneet Kishor 
> <punk.kish at gmail.com> wrote:
> > I am trying to move a PostGIS db from a computer with 
> 9.0.5/1.5.3 to 
> > another computer with 9.1.2/1.5.3. All my data are in non-public 
> > schema (several of them). Here are my steps
> >
> >        # On old server
> >        $pg_dump \
> >                --ignore-version \
> >                --username=postgres \
> >                --format=c \
> >                --blobs \
> >                --verbose \
> >                --exclude-schema=public \
> >                --file=dbdump db
> >        $scp dbdump newserver:~
> >
> >        # On the new server
> >        $createdb db
> >        $createlang plpgsql db
> >        $psql -d db -f /path/to/postgis.sql
> >        $psql -d db -f /path/to/spatial_ref_sys.sql
> >        $pg_restore --format=c --file=dbdump
> >
> > The dump file is ~3 GB. `pg_restore` seems to have been 
> going on for ever. Before I kill it and try something else, 
> want to confirm if the above steps are all that is required.
> >
> >
> >
> > --
> > Puneet Kishor
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>