I'm getting familiarized with using PostgreSQL for ArcGIS. I've only ever used SQL Server.
I was successful in setting up an ArcSDE database within PostgreSQL 9.2, but what maintenance should I do for PostgreSQL database?
-
1Lots of Tips (Vacuum pgadmin arcgis tools/scripts) to maintain postgres/postgis proceedings.esri.com/library/userconf/proc13/tech-workshops/…Mapperz– Mapperz ♦2013年11月21日 15:52:57 +00:00Commented Nov 21, 2013 at 15:52
-
unless you have a complex setup, setting autovacuum=on may be all you need (it is enabled by default). Many so called maintenance scripts actually are bad for performance.johanvdw– johanvdw2013年11月21日 16:06:26 +00:00Commented Nov 21, 2013 at 16:06
-
Yeah, I won't get too carried away, I just want to be familiar with them. Does PostGres have a maintenance plan wizard or something similar to SQL Server for daily backups?ianbroad– ianbroad2013年11月21日 16:14:08 +00:00Commented Nov 21, 2013 at 16:14
-
@GISer pgadmin III has these options to do data pumps and backups/maintenance - it should be installed with (as default) postgresMapperz– Mapperz ♦2013年11月21日 16:17:00 +00:00Commented Nov 21, 2013 at 16:17
1 Answer 1
♦Mapperz:
Lots of Tips (Vacuum pgadmin arcgis tools/scripts) to maintain postgres/postgis http://proceedings.esri.com/library/userconf/proc13/tech-workshops/tw_192.pdf
pgadmin III has these options to do data pumps and backups/maintenance - it should be installed with (as default) postgres
johanvdw:
unless you have a complex setup, setting autovacuum=on may be all you need (it is enabled by default). Many so called maintenance scripts actually are bad for performance.
Explore related questions
See similar questions with these tags.