Reputation
9,166
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 13 34
Newest
 Revival
Impact
~482k people reached

1d
answered Postgres Error: could not read block 167593 in file… SQL state: XX001
Apr
28
comment Dumping and restoring tables in PostgreSQL - ERROR: extra data after last expected column
Can you try -f backup.sql instead of < backup.sql to get the line number of the error, and inspect the backup around that line?
Apr
28
answered PostgreSQL, display role members
Apr
21
comment PostgreSQL user can not connect to server after changing password
@ericpeters0n: temporarily switch the authentication method to trust or peer in the pg_hba.conf file for this account.
Apr
14
comment Losing connection while refreshing materialised view postgresql-9.5
@allight: that's just what I expected. We're talking about memory, not disk. See if dmesg command (kernel logs) confirms the kill by linux OOM killer and then How to debug when OS kills postgres for high memory usage
Apr
12
comment Losing connection while refreshing materialised view postgresql-9.5
Possible reason: an out-of-mem condition in the backend leading to termination by the OS. The client-side error explains nothing because a dead process cannot communicate, but there will be traces in the postmaster and OS logs.
Apr
12
answered Filtering special characters in to_tsquery
Apr
1
answered Converting standard_conforming_strings from off to on when importing Postgres dump
Mar
30
answered psql: FATAL: password authentication failed for user “GuardDog_02”
Mar
28
awarded  Revival
Mar
15
awarded  Nice Answer
Mar
9
answered Incorrect Query Result
Mar
8
answered How do I make a locale available in Postgresql?
Mar
7
comment Where to look for possible deadlock causes?
The queries that deadlock are in the server's log.
Mar
7
answered Store same sequence value in two columns
Mar
7
comment Store same sequence value in two columns
How does that matter if there are multiple inserts per session? It's not obvious what kind of INSERTs queries fail to work with your current technique. Can you elaborate on that?
Mar
7
comment Optimizing “random” choice in PostgreSQL
ISTM that tablesample cannot be used on a subselect, only on a physical relation, so even with 9.5+, how would it help here? Otherwise a 9.5+ answer would be interesting, even if not directly useful to the asker.
Mar
6
revised Is there a maximum length constraint for a postgres query?
added 42 characters in body
Mar
6
answered Is there a maximum length constraint for a postgres query?
Mar
5
answered PostgreSQL Database not opening