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

[Paul Ramsey]

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