4,202 reputation
922
bio website petereisentraut.blogspot.com
location Pennsylvania
age 35
visits member for 3 years, 6 months
seen Jun 25 at 14:23

PostgreSQL and Debian hacker, DBA at MeetMe


Dec
31
answered Custom Postgres function not working
Dec
12
comment Postgresql could not find pg_xlog
Could you show the output of ls -l $PGDATA and the exact messages from the server log?
Dec
6
comment What is the purpose of PGBouncer's parameter server_reset_query?
@FrançoisBeausoleil: I disagree. I want to check the connection as the client sees it, and the fact that it's pgbouncer should be transparent to the monitoring software.
Jun
8
awarded  Caucus
May
7
answered Oracle to PostgreSQL
Mar
16
awarded  Enlightened
Mar
16
awarded  Nice Answer
Feb
15
comment pg_restore fails for a pg_dump from a db that worked just fine
But varchar(200) means 200 characters, not 200 bytes.
Jan
3
awarded  Yearling
Dec
17
awarded  Enlightened
Dec
17
awarded  Nice Answer
Dec
9
answered What is the purpose of PGBouncer's parameter server_reset_query?
Nov
30
answered Force PostgreSQL clients to use SSL?
Nov
17
answered How can I see a query after rules have been applied?
Nov
9
comment PgAdmin III - How to connect to database when password is empty?
I don't know for sure, but it's easy to imagine that PgAdmin doesn't support that.
Nov
9
awarded  Enlightened
Nov
9
awarded  Nice Answer
Oct
28
comment storing a mirror of IMAP/pop3 folder/inbox in a local DB, what choices are there?
Hence the suggestion to use IMAP synching.
Oct
28
answered storing a mirror of IMAP/pop3 folder/inbox in a local DB, what choices are there?
Oct
27
comment Unicode support of PostgreSQL and its performance
Have you read the documentation? postgresql.org/docs/current/static/multibyte.html