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

Mar
11
comment Please Help: LDAP authentication set-up over PostgreSQL
@srchalikonda What have you exactly rebuilt? You mean --with-ldap when runnning ./configure?
Mar
11
comment Centos 7, Postgresql Failed to Read Permission Data Directory in mounted Partition
You are missing some permissions. postgres must have rwx access down to the data/ directory, I mean on all direrctories up to /run/.
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
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
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
Mar
5
comment Storing historical data in DB vs on disk
What are your typical retrieval queries?
Mar
4
comment How can I tell which client process owns a particular Unix domain socket connection?
Do you know what are the suspects? Or who runs all those local processes/applications that open connections to Postgres? And, I guess, there is no such thing something 'owns' a connection. Even more, in the future you may want to set the application_name in the connection strings, so you can identify the culprit easier.
Mar
3
comment Using psql with string variable that has two periods
Why do you use varchar(255)? Why not varchar(256), or, even better, unlimited varchar ortext?
Mar
3
comment SQL error: Unknown column in 'where clause'
Also, you should read the opening warning at php.net/manual/en/function.mysql-query.php
Mar
3
comment Random unguessable primary key which preserves correct order
Why do you have the requirement of being orderable? To me it seems that you want to combine too much into the PK. For identifying a given row, a UUID is more than enough, for ordering one usually uses a creation timestamp or something else that has real meaning.
Mar
3
comment PostgreSQL operator uses index but underlying function does not
@ErwinBrandstetter interesting. I can confirm it trying the same with some other operators and their implementing functions, too.
Mar
3
comment From PostgreSQL to SQL Server (No User/Pass)
If you have access to the server, read into dba.stackexchange.com/questions/19643/…
Mar
3
comment From PostgreSQL to SQL Server (No User/Pass)
What does 'baked' mean? It's hardcoded and then compiled into a binary? How does the lost password issue affect the migration?
Mar
3
comment FATAL: terminating walreceiver due to timeout
So, this is enterprisedb, right?
Mar
2
comment Random unguessable primary key which preserves correct order
Why do you need this?
Feb
27
comment SSIS Merge Join Error
@Kin I'd suggest to delete the question altogether.
Feb
27
comment PostgreSQL 9.x: a clustered index on column A is the same as creating a table ordered by A?
The implementation changed with 9.1: postgresql.org/docs/9.4/static/release-9-1.html#AEN128676
Feb
26
comment restore mysql 5.0.77 backup to mysql 5.5
What have you already achieved? What are the actual problems?
Feb
26
comment Write output from dynamic queries in PL/pgSQL to CSV file
The problem there that to OP wants to use dynamic schema specification.