Have postgresql 8.1 installed, built 8.2 and then attempted to
install. Did this using two fink commands; fink build postgresql82,
fink install postgresql82.
Received the following warning.
<snip>
Unpacking postgresql82 (from .../postgresql82_8.2.0-1021_darwin-
powerpc.deb) ...
Selecting previously deselected package postgresql82-shlibs.
Unpacking postgresql82-shlibs (from .../postgresql82-
shlibs_8.2.0-1021_darwin-powerpc.deb) ...
Setting up postgresql82-shlibs (8.2.0-1021) ...
Setting up postgresql82 (8.2.0-1021) ...
- starting PostgreSQL on port 12761
WARNING: unable to start postgresql on an alternate port, not
installing plpgsql!
If you wish to install it manually, run:
sudo /sw/bin/pgsql.sh-8.2 start
sudo -u postgres /sw/bin/createlang-8.2 plpgsql
template1
When I attempted to run the command suggested it provided the following:
$ sudo /sw/bin/pgsql.sh-8.2 start
could not identify current directory: Permission denied
could not identify current directory: Permission denied
could not identify current directory: Permission denied
The program "postgres-8.2" is needed by pg_ctl-8.2 but was not found
in the
same directory as "pg_ctl-8.2".
Check your installation.
But in fact the file was present as follows:
/sw/bin $ ls -la postgres*
lrwxr-xr-x 1 root admin 29 Dec 20 08:00 postgres -> /sw/etc/
alternatives/postgres
-rwxr-xr-x 1 root admin 2905568 Dec 20 07:59 postgres-8.1
-rwxr-xr-x 1 root admin 3119124 Dec 20 08:33 postgres-8.2
When I looked at the console log i found:
Dec 20 09:29:00 NT sudo: ntiffin : TTY=ttyp1 ; PWD=/sw/src/
fink.build ; USER=postgres ; COMMAND=/sw/bin/pg_ctl-8.2 start -D /sw/
var/postgresql-8.2/data -l /sw/var/postgresql-8.2/pgsql.log
Dec 20 09:29:11 NT sudo: ntiffin : TTY=ttyp1 ; PWD=/sw/src/
fink.build ; USER=postgres ; COMMAND=/sw/bin/pg_ctl-8.2 stop -D /sw/
var/postgresql-8.2/data -m fast
When I looked at the install directory I found:
NT:/sw/var/postgresql-8.2$ ll
total 56
drwxr-xr-x 10 postgres admin 340 Dec 20 09:29 .
drwxr-xr-x 23 root admin 782 Dec 20 08:58 ..
-rw-r--r-- 1 root admin 54 Dec 20 09:27 README
-rw-r--r-- 1 root admin 241 Dec 20 09:27 binary.list
drwxr-xr-x 2 postgres admin 68 Dec 20 08:58 data
-rw-r--r-- 1 root admin 250 Dec 20 09:27 man1.list
-rw-r--r-- 1 root admin 1576 Dec 20 09:27 man7.list
-rw------- 1 postgres admin 130 Dec 20 09:29 pgsql.log
-rwxr-xr-x 1 root admin 1292 Dec 20 09:27 remove-
alternatives.sh
-rwxr-xr-x 1 root admin 2410 Dec 20 09:27 update-
alternatives.sh
NT:/sw/var/postgresql-8.2 ntiffin$ sudo cat pgsql.log
postgres-8.2 cannot access the server configuration file "/sw/var/
postgresql-8.2/data/postgresql.conf": No such file or directory
Since I never use the default install location for the database, I do
not think this is really a problem but it does also not seem exactly
correct. Furthermore I have created an 8.2 db and loaded with 8.1
data and all seems to work at this point.
Neil
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Fink-devel mailing list
Fink-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fink-devel
