Tagged Questions

1
vote
1answer
42 views

multiple postgresql installations in osx

I have multiple installations of postgres on my machine, and would like to narrow down to a single installation (macports flavor). I believe that OSX comes shipped with some sort of package, but I am ...
0
votes
1answer
51 views

postgres add user error

I am trying to add a new user as follows: sudo -u postgres createuser -D -A -P onemoreadmin I am entering the password right. Then, I get the following error: createuser: could not connect to ...
1
vote
1answer
435 views

Django, PostGIS, Postgres on Mac OS X Installation Issues [closed]

So the context Django1.4.x doesn't support postgis2.0 (https://code.djangoproject.com/ticket/16455) Postgres9.2x doesnt support postgis1.5 ...
1
vote
1answer
530 views

Completely remove Postgres on Mac OSX Lion [closed]

I'm trying to get postgis running on my machine. Running brew install postgis seems to have installed postgres 9.2.1 on to my machine. I would like to remove my previous version 9.1.2 to keep my ...
0
votes
2answers
119 views

database on SSD: data only or the DBM program too?

I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s ...
0
votes
0answers
226 views

Postgresql on Mac OS X Lion: remove all installations and install 9.1

This appears to be very messy, so I would like to remove all trace of PostgreSQL on my system. I followed various instructions found on the web, but to no avail. After that, what's the best way to ...
0
votes
1answer
431 views

Cannot access psql after installing postgres

I installed postgresql via homebrew on my 10.7.3. The install seemed successful and I was able to start up the server. However when I try to access psql I get the following error: psql: FATAL: role ...
0
votes
3answers
1k views

Postgres cannot start on lion due to missing server configuration file

I am trying to setup pg on a relatively clean lion install and it's not being successful. First I successfully installed homebrew, and installed postgresql without any errors. Then I tried to run a ...
0
votes
1answer
175 views

pgbench install?

I'm running postgres 8.4 but pgbench does not appear to be installed on my Mac. I've looked but I am unable to find anywhere where I can get a copy of pgbench to augment my postgres install. Looking ...
0
votes
2answers
3k views

PostgreSQL under Mac OSX Lion. Wrong userpass?

I'm completely helpless, maybe you guys can help me out. I installed PostgreSQL under my new MacOSX Lion. When I try to connect to my localhost with pgAdminIII.app it says: Error connecting to the ...
1
vote
0answers
88 views

Add new ODBC driver libs to PHP on OS X 10.6?

I'm trying to access a PostgreSQL datasource via ODBC from the installed stock PHP (OS X 10.6). Queries just hang, and I'm suspecting it can't find the PostgreSQL driver library which was installed ...
0
votes
1answer
136 views

Problem restarting postgres on OS X

I am running PostgreSQL in OS X. I am trying to restart the postgres service. When I attempt to sudo su postgres, nothing happens admin$ sudo su postgres admin$ Then, I try using -l and this is ...
0
votes
2answers
675 views

PostgreSQL no password supplied

$ brew install postgresql $ initdb /usr/local/var/postgres -U kimball -W Entered blank password when prompted. Also tried with no flags previously, but still get locked out. $ cat ...
0
votes
1answer
119 views

How do I eject an encrypted disk while Postgres is running on Mac OS X? [closed]

I've created an encrypted volume with TrueCrypt that is currently mounted on Mac OS X (v10.6.6). I have moved both MySQL and Postgres (v8.4) data to my encrypted volume and created symlinks to them. ...
21
votes
7answers
21k views

How to restart postgres on OS X?

After a reboot, postgres on my machine hasn't restarted. What command should I use in Terminal to get it going again?
0
votes
3answers
2k views

Incorrect checksum during recovery PostgreSQL database (32bits) from a backup on Mac Os X 64 bits

When I try to recover PostgreSQL database from a backup saved under my old version of Mac Os X 10.5 (32bits) on my new version 10.6 (64bits), I have this error : # sudo -u postgres ...
5
votes
4answers
3k views

Postgresql installation issues on OS X

I used Fink to install postgresql on os x. when i try to start psql, i get: psql: could not connect to server: No such file or directory Is the server running locally and accepting ...