Skip to main content
clean up
Source Link
Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620

How to drop all connections to a specific database in postgres without stopping the server?

I want to drop all connections (sessions) that are currently opened to a specific postgresqlPostgreSQL database but without restarting the server or disconnecting connections to other databases.

How can I sodo that?

How to drop all connections to a specific database in postgres without stopping the server?

I want to drop all connections (sessions) that are currently opened to a specific postgresql database but without restarting the server or disconnecting connections to other databases.

How can I so that?

How to drop all connections to a specific database without stopping the server?

I want to drop all connections (sessions) that are currently opened to a specific PostgreSQL database but without restarting the server or disconnecting connections to other databases.

How can I do that?

Tweeted twitter.com/#!/StackDBAs/status/585267891257405441
Post Migrated Here from stackoverflow.com (revisions)
Source Link
sorin
  • 1.2k
  • 3
  • 11
  • 14

How to drop all connections to a specific database in postgres without stopping the server?

I want to drop all connections (sessions) that are currently opened to a specific postgresql database but without restarting the server or disconnecting connections to other databases.

How can I so that?