6,369 reputation
31435
bio website
location Berlin, Germany
age 38
visits member for 2 years, 5 months
seen 16 mins ago

May
30
revised Using PgBarman for PostgreSQL 9.3 backup
edited tags
May
28
awarded  Revival
May
28
revised pgAdmin on a fresh OS X Server installation
added 62 characters in body
May
28
revised Problem JOINing three tables
deleted 508 characters in body
May
28
comment How do I decompose ctid into page and row numbers?
@ErwinBrandstetter: sure :) My builtin orthography processor keeps failing occasionally.
May
27
awarded  Enlightened
May
27
awarded  Nice Answer
May
27
comment How do I decompose ctid into page and row numbers?
IIRC it is a vector type and we don't have accessor methods on these. I am not sure if you can do it from a C function. Craif will tell for sure :)
May
23
comment COPY TO .csv and add quotes to header in PostgreSQL
Why do you need such a thing? :) Otherwise, I am unaware of such a feature. You could add those quotes with sed, for example, after the file is created.
May
21
comment Restricting Insert and Update to functions
@user38729 then please mark the answer as accepted. Thanks!
May
20
comment How can I figure out what service is trying to connect as root?
In our case, using CSV format logging, the IP and port of origin can be seen from the log. On the other hand, when trying to connect with a nonexistent user, I get psql: FATAL: password authentication failed for user "elek", not the error you show. This may be of some help: stackoverflow.com/questions/16973018/…
May
20
answered Postgres ODBC driver versions
May
20
comment Postgres live backup
Then why a hot standby and a plain failover are not an option?
May
20
comment Postgres live backup
I don't really get how do you plan to use the 'backup' database. What do you do with it when the primary fails? Regarding memory usage on the secondary, you can set shared_buffers to a rather low value (leave it at the default, for example) and then it won't use more.
May
15
answered PostgreSQL Function: How to refer to individual column in record return by function
May
15
comment Indexing a large static dataset
And (especially in the light of Craig's answer) what will you gain from an index on the timestamp column?
May
15
comment PostgreSQL Function: How to refer to individual column in record return by function
So, try to call SELECT * FROM circular_ref() instead of SELECT circular_ref().
May
15
revised PostgreSQL Function: How to refer to individual column in record return by function
added 428 characters in body
May
13
comment Force drop db while others may be connected in postgresql
Let me suggest doing the first step like ALTER DATABASE mydb CONNECTION LIMIT 1. I would not touch the catalogs directly unless absolutely necessary.
May
12
revised Query improvements without UNION
added 18 characters in body