4,292 reputation
922
bio website petereisentraut.blogspot.com
location Pennsylvania
age 35
visits member for 3 years, 8 months
seen 19 hours ago

PostgreSQL and Debian hacker, DBA at MeetMe


Jan
3
awarded  Yearling
Dec
23
revised Postgres cannot rename table because of AccessExcusiveLock
remove inappropriate php tag
Dec
13
answered Merging two backups form a postgresql database
Dec
4
answered PosgtreSQL - Change multiple fields collation in one query
Nov
21
awarded  Good Answer
Nov
14
awarded  Nice Answer
Nov
12
answered PostgreSQL: How to backup only One Schema from a database and restore it on another server
Nov
6
awarded  Nice Answer
Oct
30
answered How do I monitor PostgreSQL WAL shipping if I'm not using streaming replication?
Oct
29
comment How to change temporary directory for pg_dump?
How are you invoking pg_dump? Where is the temp file, what is it called?
Oct
29
answered Change propagation among connections
Oct
24
answered PL/pgSQL functions and optimizations fences?
Oct
8
answered Newly installed Postgresql 9.2 on same box as 9.1
Sep
10
answered In what order does postgresql handle queries which have conflicting locks?
Aug
24
answered Geohash implementation in PostgreSQL
Jul
16
answered How to choose a collation for international database?
Jul
11
comment Have Postgresql accept 1 and 0 as true and false for boolean
My answer would have been to change the cast. Please upgrade your comment to an answer.
Jun
14
answered Is using SUM() twice suboptimal?
Jun
13
comment pg_ctl start gives FATAL: role does not exist
Anything is possible. ;-) Send in a bug.
Jun
13
answered pg_ctl start gives FATAL: role does not exist