Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: PostgreSQL Backup Script?

    Does anyone have a PostgreSQL backup script? I remember there was one I downloaded for MySQL that would backup my databases I specify and name-date the dumps accordingly. I have no found anything like this for PostgreSQL. I know how to do this manually using the 'pgdump' utility but I would love to automate this process and name it accordingly. Does anyone know of a successful backup script I can use for PostgreSQL?

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    You don't say what kind of server that pg is installed on, but here's one for Windows.

    Here's the console help for pg_dump
    Quote Originally Posted by pg_dump help
    pg_dump --help
    pg_dump dumps a database as a text file or to other formats.

    Usage:
    pg_dump [OPTION]... [DBNAME]

    General options:
    -f, --file=FILENAME output file name
    -F, --format=c|t|p output file format (custom, tar, plain text)
    -i, --ignore-version proceed even when server version mismatches
    pg_dump version
    -v, --verbose verbose mode
    -Z, --compress=0-9 compression level for compressed formats
    --help show this help, then exit
    --version output version information, then exit

    Options controlling the output content:
    -a, --data-only dump only the data, not the schema
    -b, --blobs include large objects in dump
    -c, --clean clean (drop) schema prior to create
    -C, --create include commands to create database in dump
    -d, --inserts dump data as INSERT commands, rather than COPY
    -D, --column-inserts dump data as INSERT commands with column names
    -E, --encoding=ENCODING dump the data in encoding ENCODING
    -n, --schema=SCHEMA dump the named schema(s) only
    -N, --exclude-schema=SCHEMA do NOT dump the named schema(s)
    -o, --oids include OIDs in dump
    -O, --no-owner skip restoration of object ownership
    in plain text format
    -s, --schema-only dump only the schema, no data
    -S, --superuser=NAME specify the superuser user name to use in
    plain text format
    -t, --table=TABLE dump the named table(s) only
    -T, --exclude-table=TABLE do NOT dump the named table(s)
    -x, --no-privileges do not dump privileges (grant/revoke)
    --disable-dollar-quoting disable dollar quoting, use SQL standard quoting
    --disable-triggers disable triggers during data-only restore
    --use-set-session-authorization
    use SESSION AUTHORIZATION commands instead of
    ALTER OWNER commands to set ownership

    Connection options:
    -h, --host=HOSTNAME database server host or socket directory
    -p, --port=PORT database server port number
    -U, --username=NAME connect as specified database user
    -W, --password force password prompt (should happen automatically)

    If no database name is supplied, then the PGDATABASE environment
    variable value is used.

    Report bugs to <pgsql-bugs@postgresql.org>.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •