Reputation
1,222
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 11
Newest
 Yearling
Impact
~78k people reached

Dec
19
answered Incremental database/table backup using pg_dump on CentOS7
Dec
13
answered I do not know how to install Npgsql version 3.0.3
Nov
20
comment How can I add a flag in PostgreSQL source code that works in both frontend and backend?
@Dareen No there isn't. What about \copy? Or stdio redirection? or other clients like psycopg2 writing to files? Is this meant to be some kind of audit log?
Nov
19
revised How can I add a flag in PostgreSQL source code that works in both frontend and backend?
added 353 characters in body
Nov
19
answered How can I add a flag in PostgreSQL source code that works in both frontend and backend?
Nov
6
comment Postgres files taking up lots of space
First thing to do is figure out what they are. Are you certain they're part of the currently running PostgreSQL you're using, not some different instance? Check which table they are. select datname from pg_database where oid = 9466989 to get the database they are from. Then select relname, nspname from pg_class c inner join pg_namespace n on (c.relnamespace = n.oid) where c.oid = 10107638 to get the table name.
Oct
31
answered Postgres restoring replication, timeline conflict
Oct
31
comment Postgres restoring replication, timeline conflict
x-posted to stackoverflow.com/q/33437732/398670
Oct
23
awarded  Yearling
Oct
14
revised “FATAL: lock file ”postmaster.pid“ already exists”
added 75 characters in body
Oct
14
awarded  Good Answer
Oct
10
comment How can I delete Postgresql without using the terminal?
So the real question here is "how do I solve this problem I'm having when I try to uninstall PostgreSQL. The command I ran is <x> and the error I get is <y>. I installed PostgreSQL <version> from <location>."
Sep
14
comment Is there a way to get the complete zone file for a domain without contacting its host?
In the case of some people (like 1and1) the support people don't even know what a zone file or zone transfer are, and just send canned replies for "how to transfer your domain registration". Um, no, that's not what I want.
Aug
16
answered How to move postgresql database from one computer to another?
Aug
16
comment How to move postgresql database from one computer to another?
pg_dump and pg_restore.
Jun
25
comment Unable to install PosgreSQL on Ubuntu 14.04
X-posted to stackoverflow.com/q/31039261/398670
May
22
answered Is the order of columns significant in a Postgresql Primary key definition?
Apr
29
comment I can't loign as postgres user
Also, how was PostgreSQL installed in the first place, and to what location? Time machine user data migration only moves stuff in your home folder as far as I know. It quite likely has not moved the database across.
Apr
19
comment How to check database relationships in PostgreSQL?
If you mean foreign key constraints: psql's \d command on the table(s) of interest. Or view in PgAdmin-III.
Apr
12
comment How do I host the PostgreSQL server locally? It won't let me run as SuperUser, and it won't let me log out of SuperUser
Please show the exact error message(s) you get, and the exact command(s) you ran to get them. Generally on Windows you should be letting the installer set up PostgreSQL as a service; check in the Services control panel (Start->Run->services.msc) to see if you have a postgresql-9.4-x64 service listed there.