#2374 Postgresql backup warnings - template0

1.250
closed
Jamie Cameron
5
2005-12-27
2005-12-27
William McKee
No

I am running Postgresql v7.4.7 under FreeBSD v5.1. I
have scheduled dumps enabled on a nightly schedule
which is a wonderful feature. In my installation,
template0 is configured to not allow
connections--probably to prevent overwriting it since
it's the emergency backup to template1.

Now whenever the backup runs, I get the following email:

Backup of database template0 to file
/tmp/template0.post failed:
pg_dump: [archiver (db)] connection to database
"template0" failed: FATAL: database "template0" is not
currently accepting connections

Would it possible to add an option to skip template0 so
that I can avoid receiving this email everyday?

Thanks,
William

Discussion

  • Jamie Cameron
    Jamie Cameron
    2005-12-27

    • status: open --> closed
     
  • Jamie Cameron
    Jamie Cameron
    2005-12-27

    Logged In: YES
    user_id=129364

    Thanks for pointing this out .. the next release of Webmin
    will silently skip the backup of databases that are not
    accepting connections.