Reputation
922
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
3 11
Newest
 Nice Answer
Impact
~46k people reached

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.
Mar
29
comment Can't install libpq-dev on debian wheezy
Well, in that case you're going to have to get krb5-multidev from the same place you got the rest from. You've got your system in a weird state where there are a bunch of packages that come from no currently configured repository, so it can't fetch additional packages from it, but they conflict with packages from the repos you do have configured.
Mar
29
comment Can't install libpq-dev on debian wheezy
You seem to have manually installed a newer Kerbros via local dpkg commands, not from a repository. It didn't install krb5-multidev, which libpq requires. The older krb5-multidev in Debian is not compatible with the newer Kerberos libs you installed, so it refuses to install. You might be able to uninstall the newer libkrb5-3 and other libraries krb5-multidev conflicts with using apt-get remove, but this might also remove packages that depend on these, possibly software you still use and wish to keep. Check the changes apt-get proposes before saying yes.
Mar
29
comment Can't install libpq-dev on debian wheezy
OK, interesting. Also apt-cache policy libkrb5-3 please.
Mar
29
comment Can't install libpq-dev on debian wheezy
Are you sure you're actually running wheezy? cat /etc/debian_version. apt-cache show krb5-multidev and `apt-cache policy krb5-multidev" please.
Mar
26
comment Is there a way to let PostgreSQL restore but not create a new timeline
sDid you promote the standby at some point? It can't replay the \
Mar
10
awarded  Nice Answer
Feb
8
comment If pg_dump with -o is enough?
If your app relies on OIDs it should be fixed. Really.
Jan
20
comment Cannot start PostgreSQL: postgresql-upgrade is missing
Please show rpm -qi postgresql
Jan
4
comment Postgres won't start after restore point
Check the service logs in Event Viewer too; looks kind of like it's just timing out. Also try setting log_min_messages = debug1 in postgresql.conf and trying again then posting the full log somewhere and posting a link here.
Jan
2
revised PostGreSQL DB - phpPgAdmin using XAMPP
Invalid URL, period at end
Jan
2
suggested approved edit on PostGreSQL DB - phpPgAdmin using XAMPP
Jan
2
comment PostGreSQL DB - phpPgAdmin using XAMPP
If you're using Linux, why are you using some external packaged stack like this "XAMPP" instead of just installing the packaged PHP, Apache and PostgreSQL from your Linux distribution? These third party bundles tend, in my experience, to be a recipe for ongoing problems and upgrade nightmares. They can be OK for development, but even then I'd avoid them. (Also, which "Linux"? There are quite a few. Distro/version please.)
Jan
2
comment PostGreSQL DB - phpPgAdmin using XAMPP
Previously posted to stackoverflow.com/q/27743243/398670 where user was advised to come here.
Dec
28
comment Failing to start Postgres SQL Server on Centos
X-post from stackoverflow.com/q/27670841/398670
Oct
28
awarded  Nice Answer
Oct
23
awarded  Yearling
Oct
13
comment PostgreSQL 9.3 denying remote connection from user despite pg_hba.conf/postgresql.conf configurations
In addition to giomasce's point, also make sure you reloaded PostgreSQL after changing pg_hba.conf.