Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Germany
    Posts
    7

    Unanswered: Cannot connect to any DB because of datallowconn=false

    Hi!

    Accidentally I set all databases to datallowconn=false to create a backup.
    Now I cannot connect to any DB.
    I tried the database "postgres", but it doesn't exist.

    Any idea how to connect to the system tables or to set datallowconn to true?!

    Version is 8.0.3.

    TIA, Oliver.
    Last edited by olimen; 11-28-05 at 07:52. Reason: PG_VERSION added

  2. #2
    Join Date
    Jan 2003
    Location
    Germany
    Posts
    7

    Problem solved

    If you ever get into this situation:
    Stop the postmaster and run PostgreSQL in standalone mode
    postgres -D $PGDATA template1
    and set datallowconn back to true (press Strg-D to execute the command)!

Posting Permissions

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