www.bonsaiframework.com
Page tree

Versions Compared

Old Version 8

changes.mady.by.user Tin Pham

Saved on

compared with

New Version 9

changes.mady.by.user Tin Pham

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

Server instrumentation

The server lacks instrumentation functions.

pgAdmin III uses some support functions that are not available by default in all PostgreSQL versions. These enable some tasks that make life easier when dealing with log files and configuration files.
When you install PostgreSQL 8.0 or up using the Windows installer, you just need to select the "admin" or "adminpack" module.c

When compiling from source, the necessary files can be found in the xtra subdirectory of the pgAdmin source tree. For PostgreSQL 8.0, copy the admin directory under the postgresql contrib source directory, make and make install from there. For PostgreSQL 8.1, use the admin81 directory for that.

PostgreSQL 8.2 and above include the instrumentation functions in the "adminpack" contrib module. After the module is installed, you need to create the instrumentation functions in your maintenance database using the admin.sql script (admin81.sql for PostgreSQL 8.1) which are usually located in the pgsql share directory (e.g. /usr/local/pgsql/share)
Extended server instrumentation is not supported for PostgreSQL 7.3 and 7.4.

Backup of a Database

Warning

This section needs to be written and tested.

http://www.postgresql.org/docs/8.1/static/backup.html - not too clear, for example how do I specify a user?

http://www.thegeekstuff.com/2009/01/how-to-backup-and-restore-postgres-database-using-pg_dump-and-psql/ - looks promising, syntax looks very different from official manual though.

Also, there is a backup interface via the gui... figure out how to get the command line equivalent of that... and also not sure I can do it given I'm using the client on a different machine.