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

Jan
21
revised Creating index using dynamic SQL
deleted 285 characters in body
Jan
21
revised Dealing with partitioned tables in Postgresql
added 305 characters in body
Jan
21
revised Dealing with partitioned tables in Postgresql
added 14 characters in body
Jan
21
answered Dealing with partitioned tables in Postgresql
Jan
21
revised SELECT + INSERT or INSERT alone
added 61 characters in body
Jan
21
revised How to set Postgresql database to see date as “MDY” permanently
added 108 characters in body
Jan
21
revised How to set Postgresql database to see date as “MDY” permanently
added 192 characters in body
Jan
21
revised How to set Postgresql database to see date as “MDY” permanently
added 192 characters in body
Jan
21
revised date/time field value out of range: “21/1/2016”
added 11 characters in body
Jan
20
comment Server Doesn't Listen Error when connecting to PostgreSQL from Client
Try to disable the iptables rules and then the connection. Can you log in locally from an SSH session (psql -h localhost -U someuser)?
Jan
20
revised PostgreSQL Server: Many-to-One replication / Transactional Replication
added 8 characters in body
Jan
20
comment Postgresql cannot drop trigger
I'm not sure why you need the sa.sql.text() magic, does it replace the normal cursor? Or is conn already a cursor? And Phil said to remove the second DROP statement, not any quotes.
Jan
20
comment MySQL InnoDB log files on different location
That link is already dead (at least for me). Please include the important points from there, so that your answer becomes and stays useful even when the link rots (which it did, at least partially).
Jan
20
comment How can I monitor the progress of an import of a large .sql file?
So, based on this, how do you get the progress?
Jan
20
revised Does Greenplum support dynamic sql?
deleted 15 characters in body
Jan
19
revised Server Doesn't Listen Error when connecting to PostgreSQL from Client
deleted 2 characters in body
Jan
19
comment Server Doesn't Listen Error when connecting to PostgreSQL from Client
@LandArch the log looks pretty up there, I don't see where your problem is ;) Other than that, the log lines don't contain anything relevant (which is not surprising, given the error you get). BTW, are the restarts initiated by you?
Jan
19
comment Server Doesn't Listen Error when connecting to PostgreSQL from Client
Could you please post the textual information as actual text? It helps reading your post enormously.
Jan
19
comment Does JSONB column type in export look identical to JSON?
Why is this interesting (apart from curiosity)? In other words, what problem are you trying to solve?
Jan
18
awarded  Marshal