Hi,

As part of updating qt3 from version 3.2 to version 3.3, I'm trying to
install postgresql74-ssl.  It built fine, but it won't install.

The first time, I got this:

dpkg -i 
/sw/fink/dists/unstable/crypto/binary-darwin-powerpc/postgresql74-ssl-dev_7.4.5-11_darwin-powerpc.deb
 
/sw/fink/dists/unstable/crypto/binary-darwin-powerpc/postgresql74-ssl_7.4.5-11_darwin-powerpc.deb
 
/sw/fink/dists/unstable/crypto/binary-darwin-powerpc/postgresql74-ssl-shlibs_7.4.5-11_darwin-powerpc.deb
Selecting previously deselected package postgresql74-ssl-dev.
(Reading database ... 71246 files and directories currently installed.)
Unpacking postgresql74-ssl-dev (from 
.../postgresql74-ssl-dev_7.4.5-11_darwin-powerpc.deb) ...
Selecting previously deselected package postgresql74-ssl.
Unpacking postgresql74-ssl (from .../postgresql74-ssl_7.4.5-11_darwin-powerpc.deb) ...
Selecting previously deselected package postgresql74-ssl-shlibs.
Unpacking postgresql74-ssl-shlibs (from 
.../postgresql74-ssl-shlibs_7.4.5-11_darwin-powerpc.deb) ...
Setting up postgresql74-ssl-shlibs (7.4.5-11) ...

Setting up postgresql74-ssl (7.4.5-11) ...
- making postgresql directories: ok
- initializing database in /sw/var/postgresql-7.4/data: failed

*** bailing because an error ocurred:

couldn't initialize database
dpkg: error processing postgresql74-ssl (--install):
 subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql74-ssl-dev:
 postgresql74-ssl-dev depends on postgresql74-ssl (>= 7.4.5-11); however:
  Package postgresql74-ssl is not configured yet.
dpkg: error processing postgresql74-ssl-dev (--install):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 postgresql74-ssl
 postgresql74-ssl-dev
### execution of dpkg failed, exit code 1
Failed: can't batch-install packages: 
/sw/fink/dists/unstable/crypto/binary-darwin-powerpc/postgresql74-ssl-dev_7.4.5-11_darwin-powerpc.deb
 
/sw/fink/dists/unstable/crypto/binary-darwin-powerpc/postgresql74-ssl_7.4.5-11_darwin-powerpc.deb
 
/sw/fink/dists/unstable/crypto/binary-darwin-powerpc/postgresql74-ssl-shlibs_7.4.5-11_darwin-powerpc.deb

Then I remembered a similar trouble I had on a Linux box:  postgresql
initialization doesn't play well with internationalization.  So I did
this:

$ (unset LC_ALL; LANG=C fink install postgresql74-ssl-shlibs postgresql74-ssl 
postgresql74-ssl-dev)

and everything went swimmingly.

Now, however, I can't get the database to start.  When I follow the
instructions in the info file (I have to play the same game LC_ALL and
LANG), I get this:

$ (unset LC_ALL; LANG=C sudo -u postgres postmaster)
postmaster does not know where to find the database system data.
You must specify the directory that contains the database system
either by specifying the -D invocation option or by setting the
PGDATA environment variable.

Okay, so following the trail to /sw/bin/pgsql.sh, I tried this:

$ (unset LC_ALL; LANG=C PGDATA=/sw/var/postgresql-7.4/data sudo -u postgres postmaster)

which works, but now the server is running attached to my terminal.

I can run "pgsql.sh start" from a terminal (as root or otherwise), and
it *says* that it started postmaster, but pstree says otherwise.
Strangely, "pgsql.sh stop" will stop the server when it is running in my
terminal.

When I tried the daemonic route, the database still wouldn't start, but
I do get a line in /var/log/system.log that indicates that daemonic did
try to start the database:

Oct 23 12:16:06 Graviton SystemStarter: Unable to load localization strings for 
/Library/StartupItems/daemonic-postgresql74-ssl 
Oct 23 12:16:06 Graviton SystemStarter: Starting  PostgreSQL database server 

FWIW, I can now proceed with my original adventure, updating qt3 and
eventually kde.  :-/

Any ideas on how to get postgresql to run?

Thanks,
Dan

-- 
Dan Sommers                                        Atoms are not things.
This sentence is false.                              --Werner Heisenberg
<mailto:[EMAIL PROTECTED]>                  Intercourse the penguin.
<http://www.tombstonezero.net/dan/>       --Monty Python's Flying Circus


-------------------------------------------------------
This SF.net email is sponsored by: IT Product Guide on ITManagersJournal
Use IT products in your business? Tell us what you think of them. Give us
Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more
http://productguide.itmanagersjournal.com/guidepromo.tmpl
_______________________________________________
Fink-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/fink-users

Reply via email to