Reputation
6,683
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 11 30
Newest
 Organizer
Impact
~295k people reached

1d
comment Simultaneous calls to the same function: how are deadlocks occurring?
I mean within the same transaction, not just the same session (as locks are released at tx end). The answer by @alexk is what I was thinking about, but if the tx starts and ends with the function, that can't explain the deadlock.
1d
comment Simultaneous calls to the same function: how are deadlocks occurring?
In the same transaction, before entering that function, is customer used in a way that would grab a weaker lock? Then it could be a lock upgrade problem.
2d
reviewed Leave Open Should I use a separate postgres schema for application logins?
2d
comment psql and coordinator not working on postgres-xl?
5432 is the default port. As your server is explicitly configured to use 9999 instead, the psql client also must indicate explicitly that port. Adding --port 9999 option to psql will do.
Jul
24
comment PostgreSQL 9.4 : server closed the connection unexpectedly
If auditd is active (otherwise activate it), does ausearch -m ANOM_ABEND -ui postgres report the abnormal terminations ? If yes, arrange to get core dumps
Jul
24
comment psql and coordinator not working on postgres-xl?
You're trying to connect to port 5432 while it listens to port 9999.
Jul
23
answered error recovering pg_dump compressed file
Jul
23
comment Full text search on multiple joined tables
The string_agg with empty string delimiter looks suspicious. What's the point of producing Author1Author2Author3 ?
Jul
23
answered How to get all roles that a user is a member of (including inherited roles)?
Jul
21
comment How to get notices to the output stream?
channel/file descriptor is used for outputting the messages raised from a procedure: it's the standard error. \o | cat > out.sql 2>&1 redirects the standard error of cat but not the one of psql, so it's of no use for the notices.
Jul
21
comment How to log custom messages from inside a PostgreSQL transaction?
@dezso: indeed. To me, this is because \o | program does redirect psql's stdout to |program but does not redirect psql's stderr at all. Same behavior as the pipe in shell. Adding 2>&1 redirects the stderr of program to its stdout, but it's still independant of psql's stderr.
Jul
21
comment How to log custom messages from inside a PostgreSQL transaction?
I've elaborated in an answer.
Jul
21
answered How to log custom messages from inside a PostgreSQL transaction?
Jul
17
comment How to log custom messages from inside a PostgreSQL transaction?
Try to redirect in the opposite order with >clog.log 2>&1. Then the notices should go to clog.log.
Jul
15
comment PostgreSQL suddenly using all my disk space
These entries date from 2015-07-05 (surprisingly), days ago. The warnings on checkpoints are related to intense database activity such as caused by a large import. Simply having tables in a database, geospatial or otherwise, should not generate continuous errors.
Jul
14
comment PostgreSQL suddenly using all my disk space
And in the meantime you may delete postgresql-9.1-main.log.*.gz, the database does not need them, it's just for you to consult.
Jul
14
comment PostgreSQL suddenly using all my disk space
In normal conditions, these files contain only errors and warnings and should be near empty. Look at 100 lines with head -n 100 postgresql-9.1-main.log to see what kind of contents fills them.
Jul
14
answered how do you prevent dead rows from hanging around in postgresql?
Jul
13
comment psql breaks if I specify host localhost
Maybe there is a packet filter closing connections. Mac OS has pf. Note in any case that based on the Trying ::1 telnet output above, localhost does not resolve to 127.0.0.1 but to ::1 (IPv6).
Jul
12
comment psql breaks if I specify host localhost
Then telnet 127.0.0.1 5432 in the hope of getting a more meaningful error message.