I want to run command line Postgres tools directly on AWS. What is the best approach for this? I know how to access AWS Postgres via psql on my machine and connecting to the host.
On Jun 18, 2020, 12:18 PM, at 12:18 PM, Regina Obe <[email protected]> wrote: >You are probably installing into a newer version of PostGIS is my guess >and >PostGIS 3+ now has postgis_raster as a separate extension. > >Your restore only has CREATE EXTENSION postgis; so would be missing >the >postgis_raster bit. > > > >If you need raster support, you should do > > > >create newdb > > > >In you newdb database run > > > >CREATE EXTENSION postgis; > >CREATE EXTENSION postgis_raster; > > > > > >Then follow with your restore > > > >From: postgis-users [mailto:[email protected]] On >Behalf >Of Crawford Jr., Stephen Rand >Sent: Thursday, June 18, 2020 11:57 AM >To: [email protected] >Subject: [postgis-users] dump and restore > > > >All, > > > >I have a postGIS database that I am moving to a new machine. I tried >these >forms of dump and restore, which have worked on other databases: > > > >pg_dump -Fc db > db.dump > > > >createdb newdb > > > >pg_restore -v -d newdb db.dump > > > >But for this database restore hangs on the first table, which is full >of >rasters, as are most of the tables in this database. Are there any >other >flags or techniques that I should be using? > > > >Thanks, > >Steve > > > >Stephen Crawford > >Center For Environmental Informatics > >The Pennsylvania State University > >[email protected] <mailto:[email protected]> > > > >------------------------------------------------------------------------ > >_______________________________________________ >postgis-users mailing list >[email protected] >https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
