Reputation
Next tag badge:
686/1000 score
213/200 answers
Badges
7 32 55
Newest
 Revival
Impact
~590k people reached

Mar
17
revised how to delete all rows with empty field via function/trigger combo in Postgres v 9.3?
added 1 character in body
Mar
17
comment Tool to find CPU utilization for a particular query in Postgres
Why have you asked this question once again? Have you checked my comment on the other one (which, incidentally, overlaps with @a_horse_with_no_name's answer below...)?
Mar
17
revised How do I set the external editor for PostgreSQL's psql client?
edited body
Mar
13
comment CPU utilization for a particular query in Postgres
Get the PID from pg_stat_activity and look it up in top. Or just use pg_view, for example. (I work for the company, but the tool is free.)
Mar
13
revised CPU utilization for a particular query in Postgres
edited body; edited tags
Mar
13
comment Moving PostgreSQL database to new server
Please be aware that the current PostgreSQL version is 9.4 - about six years newer than 8.4, not to mention 8.3... If by 'move the data over' you mean restoring from an existing dump (I suppose this as you know the data is OK), then you should be able to restore everything without serious problems. A few years ago, the only problems I experienced AFAIK were some easy-to-fix errors related to implicit casting.
Mar
13
comment Errors importing data using COPY comand at postgresql 9.3.5
Well, some of the errors that you show definitely don't come from the two lines of your input. It's very hard to tell what's exactly wrong. Try to export the data in a proper, quoted CSV format and COPY that.
Mar
12
comment Errors importing data using COPY comand at postgresql 9.3.5
Have you tried to specify the delimiter?
Mar
12
comment Can duplicate pg_hba entries result in a connection error?
Here you don't even get to the pg_hba.conf. The problem is stated in the message: the host either does not listen on that port, or the port is not available from host trying to connect. This latter can be a result of missing routing or firewalls or I don't know.
Mar
11
comment Do Statement-level AFTER triggers occur asynchronously after the statement returns?
You could, for example, drop a row into a sort of housekeeping table and visit it from a scheduled job. Once it finds this row there, it refreshes the MV.
Mar
11
revised CentOS 7, PostgreSQL failed to read permission data directory in mounted partition
added 87 characters in body
Mar
10
revised COMMIT after EXPLAIN ANALYZE of a read-only query
added 575 characters in body
Mar
10
answered COMMIT after EXPLAIN ANALYZE of a read-only query
Mar
6
comment Create/copy new superuser from an existing one
The thing is that if super1 has some user-specific settings, those are not inherited this way.
Mar
6
revised Create/copy new superuser from an existing one
added 11 characters in body; edited title
Mar
6
answered Get table name by foreign key
Mar
6
comment Get table name by foreign key
Got to psql, issue \d your_table and look up the referenced table's name. If you set \set ECHO_HIDDEN on beforehand, you'll get a bunch of queries that produce the output, those you can reuse in your own discovery script.
Mar
6
revised Pgpool II : unable to read message length between two network interfaces
added 9 characters in body
Mar
6
comment query to find all dblink()
@ErwinBrandstetter yes, that was clear, but what I saw was that even SQL functions don't observe the dependency on the dblink extension's functions...
Mar
5
comment Table with both primary key and unique key
Not sure what that person means about SQL Server, but in PostgreSQL there is no such thing. Apart from this, +1 for @a_horse_with_no_name