Reputation
17,909
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 14 41
Newest
 Announcer
Impact
~387k people reached

2d
comment PostgreSQL function definition “syntax error at or near +”
It's nice if you mention that, since sometimes even the most careful people make mistakes when anonymizing their identifiers. I've had very confusing and frustrating issues that turned out to be caused by someone "anonymizing" their schema/queries, not mentioning that, and getting it wrong...
2d
comment PostgreSQL function definition “syntax error at or near +”
Thanks for actually showing a complete error message and the relevant queries. Wish more people did without being asked.
2d
answered PostgreSQL function definition “syntax error at or near +”
2d
comment How to move a specific Postgres database to different harddrive?
Use a tablespace. postgresql.org/docs/current/static/manage-ag-tablespaces.html . Understand, though, that the table(s) in F: are not readable without the database directory contents in D:.
2d
comment Is it possible for a client to kill a long-running Postgres query?
pg_terminate_backend and pg_cancel_backend do not require superuser rights on 9.2 or above if you're terminating a connection owned by the same user. So if you're on a recent version, use that.
Apr
23
answered What to do with WAL files for Postgres Slave reset
Apr
23
comment PostgreSQL DB freezes with large inserts
Do you have any AFTER triggers? Deferred constraints? If not, it's highly likely that it won't be PostgreSQL its self using the RAM. Check top.
Apr
23
answered Anything like a hash for Postgresql databases?
Apr
22
comment pg_ctl status responds with “available” during failed startup
It strikes me that we should add pg_ctl status -w or similar, i.e. something that, like -w does for start/stop, makes an actual libpq connection.
Apr
21
comment pg_ctl status responds with “available” during failed startup
Uh, that doesn't seem right at all then...
Apr
21
comment pg_ctl status responds with “available” during failed startup
Is it in hot_standby mode? If so, it is available, if it's replayed enough that it's accepting connections and responding to queries.
Apr
21
comment pg_ctl status responds with “available” during failed startup
Details please - exact PostgreSQL version, PostgreSQL log file output, etc.
Apr
21
awarded  Announcer
Apr
20
comment Can't connect to EC2 Postgresql instance unless I change the default port 5432
That was my first thought when it was this specific port. Weird port to block. If you want to properly confirm that it's your ISP, you should use traceroute in TCP mode, or a similar TCP traceroute tool.
Apr
19
revised RHEL 6: postmaster dead but pid file exists
edited title
Apr
19
answered Sharing PostgreSQL database on one dual-boot machine without duplication (cross-platform)
Apr
19
comment debugging PostgreSQL serialization failures
It'd be good to have, but I don't think there's really much there at the moment. It's particularly tricky because multiple statements are often involved and the culprit(s) aren't always the current running ones, especially on at-commit failures. Collecting the extra info would be ruinous for performance and memory use, but it'd be a great option to be able to turn on when debugging.
Apr
17
answered Unable to create read only user— postgresql 9.4
Apr
16
comment installing pgagent on centos
There isn't really "OS authentication" like in MS SQL Server. You can use sspi authentication, but you still have to CREATE USER the users in PostgreSQL, it just decides based on the OS whether to let them log in or not. See the Client Authentication chapter of the documentation for details.
Apr
16
comment How to cancel query as non-superuser?
@MikeT Huh, I wasn't aware that query cancel on remote disconnect was as new as 9.2. Thanks for the pointer.