Reputation
1,255
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 11
Newest
 Revival
Impact
~69k people reached

  • 0 posts edited
  • 0 helpful flags
  • 16 votes cast
Apr
28
awarded  Revival
Apr
28
revised postgresql + pgbouncer, idle server and high cl_waiting
improve question
Apr
27
answered Postgres pg_basebackup reports directory exists but is not empty
Apr
27
asked postgresql + pgbouncer, idle server and high cl_waiting
Mar
26
comment Postgresql 9.4 high availability
thx @maletin I included your hints in my answer
Mar
26
revised Postgresql 9.4 high availability
improve answer
Mar
26
comment Postgresql 9.4 high availability
@wolf97084, you have to do this with external tools, PostgreSQL itself does not know how to redirect traffic and it does not do anything outside the database.
Feb
25
answered Postgresql 9.4 high availability
Feb
20
comment Force drop db while others may be connected
@dezso, ALTER did not work for me. try this: createdb foo; psql -c "alter database foo connection limit 1"; psql foo -qAtc "select numbackends from pg_stat_database where datname='foo'"; psql foo -qAtc "select pg_sleep(1000)" & psql foo -qAtc "select pg_sleep(1000)" & psql foo -qAtc "select pg_sleep(1000)" & psql foo -qAtc "select numbackends from pg_stat_database where datname='foo'"
Nov
28
awarded  Good Answer
Oct
3
awarded  Yearling
Aug
25
awarded  Popular Question
Jul
21
revised Connect to PgAdmin III via localhost
improve
Jul
21
revised Does leaving a connection open for a matter of seconds cause deadlocks?
improve
Jul
13
revised Does leaving a connection open for a matter of seconds cause deadlocks?
"sql-server" tag added.
Jul
13
revised database normalization to 3NF
add more tags to describe issue
Jul
13
suggested approved edit on database normalization to 3NF
Jul
13
answered Limiting read access in postgres to few rows
Jul
13
answered Does leaving a connection open for a matter of seconds cause deadlocks?
Jul
13
suggested approved edit on Does leaving a connection open for a matter of seconds cause deadlocks?