Reputation
8,155
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~372k people reached

May
13
comment pgAgent : how to configure pgpass.conf for a local connection on Windows Server 2008
Do you see (maybe in the Postgres logs) what exactly the error is? What you quote here does not come from the backend, I believe.
May
12
comment How to handle user with no password in postgresql
\password [ username ] Changes the password of the specified user (by default, the current user). This command prompts for the new password, encrypts it, and sends it to the server as an ALTER ROLE command. This makes sure that the new password does not appear in cleartext in the command history, the server log, or elsewhere. postgresql.org/docs/9.4/static/app-psql.html
May
12
comment How to handle user with no password in postgresql
You should use psql's \password instead, so the password change (and the password itself) is not logged under any circumstance.
May
12
comment how many tables do i need to create in MYSQL
I'm voting to close this question as off-topic because we don't know what your boss wants from you.
May
12
comment jdbc error org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend
So we don't know anything about your connection details. Do you connect to the DB directly or pgpool? Can you ping, telnet or whatever there as expected? Did you try anything to figure this out?
May
11
comment Postgresql performance issues when issuing many small inserts and updates one at a time
How your setup does look like? Are the two servers on the same machine? VMs involved? What sort of disks are there? And what do you see when you monitor the DB activity during the update/insert time?
May
11
comment Put Postgres query result in array
I've just made a small test where I see the two producing the exact same query plan, therefore the same execution time.
May
11
comment Combining separate ranges into largest possible contiguous ranges
@ErwinBrandstetter yes, that's an issue I wanted to test (after my first extreme was 9999-12-31 :). At the same time, I am wondering why my answer has more upvotes than yours. This is possibly easier to understand... So, future voters: Erwin's answer is superior to mine! Vote there!
May
10
comment Postgres automatic insert time stamp with time zone (india)
@0x54MUR41 You don't have to be sorry. If every first-time poster spent this much energy on their post, this site would be even awesomer :) You see, you got some nice upvotes for a reason.
May
10
comment Speed up SELECT with WINDOW, (PARTITION … ORDER) with compound index
Is this an actual problem? The query runs in under a millisecond...
May
9
comment Combining separate ranges into largest possible contiguous ranges
@ErwinBrandstetter that won't really work with generate_series() :)
May
9
comment Postgres automatic insert time stamp with time zone (india)
With which part do you have the problem? What sort of query do you want to insert? Are your servers have proper time zone settings? And finally, what do you mean by desired time format?
May
9
comment Postgres automatic insert time stamp with time zone (india)
I think you slightly overthought the problem - in my understanding, they just want to have a timestamp with every row inserted.
May
8
comment what is causing Errors running from Localhost
Some formatting and a description of what you are actually doing would be more than welcome.
May
8
comment Combining separate ranges into largest possible contiguous ranges
How many different values do you (plan to) have?
May
8
comment Can't list users - “select * from user” returns only one row with one column
This is not really correct, see the output of \dt *."user". Regardless, I'd suggest removing this question in favour of the SO one (with an excellent answer).
May
8
comment Can you force pgpool to require SSL connections?
As far as I can tell from looking at the docs, this is not possible (though it would make sense).
May
8
comment Is it possible to set a timer for autovacuum in PostgreSQL
Please confirm that it is the autovacuum that blovks your access - this is not supposed to be so, the workers give way to allow other activities. Set up some monitoring and watch what happens at that time. You can choose something from here: wiki.postgresql.org/wiki/Monitoring, I recommend pg_view as it was developed by my colleagues.
May
7
comment postgres fetch record from partitions without the check constraints
Could you add an example of the situation, with a few rows only? I am still a bit confused about the requirements.
May
7
comment postgresql - granting schema to users
Partly yes, see my edit.