Reputation
7,773
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 42
Newest
 Revival
Impact
~351k people reached

Mar
31
comment Restoring plain-text pg_dump with psql and --disable-triggers
You can go and edit your dump in any editor. Just prepend the COPY with an ALTER TABLE table DISABLE TRIGGER ALL and reenable these at the end.
Mar
30
comment Have: Postgres database files. Need: Functioning database
Interesting, I see postgresql-9.1 in my output of apt-cache search postgresql...
Mar
30
comment SQL update multiple columns matching a pattern
postgresql.org/docs/9.4/static/sql-update.html
Mar
30
comment What will be best (for performance) transaction isolation level?
Why are you worried about the performance in any given isolation level? BTW, is your ORM prepared to retry every transaction that would be the victim of a serialization error?
Mar
27
comment Unique Index much bigger than the table itself
@IvanDeSousaPaz the index is organized like a tree, and (provided that the order of columns in its definition makes sense, for example follow the most-selective-first approach) can significantly reduce the number of pages to be visited. Look at this page to have an idea how. And yes, you need the index for maintaining uniqueness.
Mar
26
comment Umlauts in DBeaver
this may help: dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=677
Mar
26
comment Recovering from a partial recover/migration
Unless you can figure out where the restoration stopped, you have to restart. If you have the restart point, you can edit the dump (this may be tricky if it's too big, you may want to use some non-interactive editors) by removing everything that's already there. TBH I would simply restart, it is much cleaner.
Mar
20
comment Does Postgres preserve insertion order of records?
The actual answer aside (which I believe is no) you should not rely on any other order than the one you specify in your queries.
Mar
17
comment upgrading posgresql 9.0 to 9.4 with pg_upgrade on CentOS 6.6
Anyway, the problem looks like pg_upgrade tries to connect via TCP/IP, while the cluster is configured to allow socket connections only.
Mar
17
comment upgrading posgresql 9.0 to 9.4 with pg_upgrade on CentOS 6.6
Do you run pg_ctl start?
Mar
17
comment upgrading posgresql 9.0 to 9.4 with pg_upgrade on CentOS 6.6
Could you show the non-commented lines of the old cluster's postgresql.conf?
Mar
17
comment how to delete all rows with empty field via function/trigger combo in Postgres v 9.3?
A big +2 for the last sentence
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
comment How do I set the external editor for PostgreSQL's psql client?
@Tony fixed, thanks.
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
comment Centos 7, Postgresql Failed to Read Permission Data Directory in mounted Partition
Yes, I mean that.
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.