#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    2
    Rep Power
    0

    Backup postgresql database


    I'm new to PostgreSQL, and I'm trying to back up a database on a server. I found instructions for listing the databases and using pg_dump, but when I type "psql -l", it says "psql: FATAL: database "postgres" does not exist". Any help would be appreciated.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    2
    Rep Power
    0

    solution


    Never mind. I found that it successfully lists the databases if I type "psql -l template1".

IMN logo majestic logo threadwatch logo seochat tools logo