Difficulty installing and using PostgreSQL.

[Bill Hernandez]

On Jul 15, 2009, at 7:39 PM, Don Fox wrote:

>
> I have been attempting to install and use PostgreSQL without  
> success, using MacPorts. I've installed 8.3.7 and 8.4. Installation  
> goes without apparent hitch but then postgreSQL server is not able  
> to be accessed. I've changed the PATH as per the documentation but  
> postgresql is never to be found.
>
> Ive done a number of previous installations via macports without any  
> problems. I'm using an old MacPowerBook with 2gigs of memory running  
> the current Leopard.
>
> Also, I've attempted the installation using zip files from the  
> postgre site and disk imag from PostgreSQL for Mac. Not any luck!
>
> Any suggestions?
>
> Thanks very much,
>
> Don Fox

I DON'T KNOW IF THISIS A NEW INSTALL, BUT MAKE SURE YOUR DATA IS  
BACKED UP....

YOU SHOULD HAVE DONE SOMETHING LIKE :

$ sudo mkdir -p /backups/pgsql/databases/2009.07.14_22.58.33

$ sudo su - postgres -c "/opt/local/lib/postgresql83/bin/pg_dumpall -U  
postgres >> /backups/pgsql/databases/2009.07.14_22.58.33/main_db.sql"


ASSUMING WE ARE ALL DONE INSTALLING postgresql83

( 1 ) [2009.11.07](11:07AM) -> [roscoe] ~  $ sudo launchctl load -w / 
Library/LaunchDaemons/org.macports.postgresql83-server.plist
  ---> Password:

( 2 ) [2009.11.07](12:22PM) -> [roscoe] ~  $ sudo mkdir -p /opt/local/ 
var/db/postgresql83/defaultdb

( 3 ) [2009.11.07](12:23PM) -> [roscoe] ~  $ sudo chown  
postgres:postgres /opt/local/var/db/postgresql83/defaultdb

( 4 ) [2009.11.07](12:23PM) -> [roscoe] ~  $ sudo su postgres -c '/opt/ 
local/lib/postgresql83/bin/initdb -D /opt/local/var/db/postgresql83/ 
defaultdb'
  ---> The files belonging to this database system will be owned by  
user "postgres".
  ---> This user must also own the server process.

<snip>
  ---> WARNING: enabling "trust" authentication for local connections
  ---> You can change this by editing pg_hba.conf or using the -A  
option the
  ---> next time you run initdb.

  ---> Success. You can now start the database server using:

     /opt/local/lib/postgresql83/bin/postgres -D /opt/local/var/db/ 
postgresql83/defaultdb
  ---> or
     /opt/local/lib/postgresql83/bin/pg_ctl -D /opt/local/var/db/ 
postgresql83/defaultdb -l logfile start


Check and see if I have a postgres user ?

( 5 ) [2009.11.07](12:26PM) -> [roscoe] ~  $ dscl . list /users  
UniqueID | sort -k2 -n | grep postgres
  ---> postgres           505

I had forgotten my postgres password, so...

login as system_root (not sudo) which requires the actual system_root  
password, and force change the postgres user password

( 6 ) [2009.11.07](02:50PM) -> [roscoe] ~  $ su - root
  ---> Password:

Assign the new postgres password and don't forget it this time...

( 7 ) [2009.11.07](02:50PM) -> [root] ~  $ dscl . -passwd /Users/ 
postgres <force_assign_a_new_postgres_password>

( 8 ) [2009.11.07](02:50PM) -> [root] ~  $ exit
  ---> logout

Startup PgSQL

( 9 ) [2009.11.07](02:51PM) -> [roscoe] ~  $ /opt/local/etc/ 
LaunchDaemons/org.macports.postgresql83-server/postgresql83- 
server.wrapper start
  ---> Password:
  ---> server starting

( 10 ) [2009.11.07](02:51PM) -> [roscoe] ~  $ ps aux | grep postgres
  ---> roscoe 92842   1.0  0.0   599740    384 s001  S+    2:52PM    
0:00.00 grep postgres
  ---> root     92561   0.0  0.0    75452    720   ??  Ss   12:22PM    
0:00.00 /opt/local/bin/daemondo
  ---> --label=postgresql83-server
  ---> --start-cmd /opt/local/etc/LaunchDaemons/ 
org.macports.postgresql83-server/postgresql83-server.wrapper start ;
  ---> --stop-cmd /opt/local/etc/LaunchDaemons/ 
org.macports.postgresql83-server/postgresql83-server.wrapper stop ;
  ---> --restart-cmd /opt/local/etc/LaunchDaemons/ 
org.macports.postgresql83-server/postgresql83-server.wrapper restart ;
  ---> --pid=none
  ---> postgres 92840   0.0  0.1    88612   2204   ??  SNs   2:51PM    
0:00.12 /System/Library/Frameworks/CoreServices.framework/Frameworks/ 
Metadata.framework/Versions/A/Support/mdworker MDSImporterWorker  
com.apple.Spotlight.ImporterWorker.505
  ---> postgres 92837   0.0  0.0   599796    460   ??  Ss    2:51PM    
0:00.00 /sbin/launchd
  ---> postgres 92834   0.0  0.0   608916    308   ??  Ss    2:51PM    
0:00.00 postgres: stats collector process
  ---> postgres 92833   0.0  0.0   612852    484   ??  Ss    2:51PM    
0:00.00 postgres: autovacuum launcher process
  ---> postgres 92832   0.0  0.0   612852    424   ??  Ss    2:51PM    
0:00.00 postgres: wal writer process
  ---> postgres 92831   0.0  0.0   612852    468   ??  Ss    2:51PM    
0:00.00 postgres: writer process
  ---> postgres 92827   0.0  0.0   612852   2036 s001  S     2:51PM    
0:00.20 /opt/local/lib/postgresql83/bin/postgres -D /opt/local/var/db/ 
postgresql83/defaultdb

( 11 ) [2009.11.07](02:52PM) -> [roscoe] ~  $


If you still can't get it working try :

( 12 ) [2009.11.07](02:52PM) -> [roscoe] ~  $/opt/local/etc/ 
LaunchDaemons/org.macports.postgresql83-server/postgresql83- 
server.wrapper stop ;

MAKE TRIPLE SURE YOU HAVE YOUR DATA BACKED UP BEFORE THE NEXT STEP...

( 13 ) [2009.11.07](12:22PM) -> [roscoe] ~  $ sudo rm -R /opt/local/ 
var/db/postgresql83/defaultdb

  NOW GO BACK TO STEP ( 2 ) THROUGH ( 10 ) AGAIN

TO SHUTDOWN EVERYTHING :
$ sudo echo
$ sudo launchctl unload -w /Library/LaunchDaemons/ 
org.macports.slapd.plist; \
sudo launchctl unload -w /Library/LaunchDaemons/ 
org.macports.apache2.plist; \
sudo launchctl unload -w /Library/LaunchDaemons/ 
org.macports.mysql5.plist; \
sudo launchctl unload -w /Library/LaunchDaemons/ 
org.macports.postgresql83-server.plist


TO RELAUNCH EVERYTHING
$ sudo echo
$ sudo launchctl load -w /Library/LaunchDaemons/ 
org.macports.slapd.plist; \
sudo launchctl load -w /Library/LaunchDaemons/ 
org.macports.apache2.plist; \
sudo launchctl load -w /Library/LaunchDaemons/ 
org.macports.mysql5.plist; \
sudo launchctl load -w /Library/LaunchDaemons/ 
org.macports.postgresql83-server.plist

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20090716/35bbdebf/attachment.html>