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


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?
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
13
comment pg_ctl start gives FATAL: role does not exist
Anything is possible. ;-) Send in a bug.
May
28
comment How to get the information of the optimizer of PostgreSQL?
Look for "PLANNER STATISTICS" at level "LOG" in the server log.
Apr
28
comment Is there better way to 'touch' a row than performing a dummy update?
That certainly sounds more sane.
Mar
4
comment PostgreSQL 9.1 streaming replication problem: replica fails to use an index properly
Yes, if you replicate to an OS with a different locale implementation, things will break badly.
Jan
2
comment Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu)
That creates a table diagram. Getting from there to an entity-relationship diagram is another step.
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.
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.
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.
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
27
comment Unicode support of PostgreSQL and its performance
Have you read the documentation? postgresql.org/docs/current/static/multibyte.html
Aug
18
comment PostgreSQL: Corrupt primary key, inconsistent table
You might want to look at the plan of the grouping query to check that it doesn't use the index.
Aug
1
comment Index Generation in Postgres
The algorithms for sorting on disk and in memory are not the same, so they will use different amounts of memory. But it's actually more likely that the in-memory sort uses more memory. Still, the numbers that have been quoted are quite bizarre, so it's worth a try.
Jul
30
comment Index Generation in Postgres
This doesn't apply to his case, because he is using pg_dump, which already creates the indexes after loading the data. It says so in the question.
Jul
2
comment Postgresql row-level encryption
Not that it would make a difference in this case, but you are linking to the PostgreSQL 8.0 documentation, which is more than 6 years old.
Jun
27
comment PostgreSQL: Disk space not released after TRUNCATE
It's conceivable that another backend process still has a file descriptor to the file open. If this happens again, I'd try terminating all other backend processes, just to see whether it makes a difference.
Apr
17
comment Where does the magic column “name” come from?
It would help to show the definition of site.
Mar
2
comment How to upgrade PostgreSQL minor releases without a dump/restore?
I didn't downvote anything.