Re: problem with RH7.3 Pg7.3.4 binaries

BTW, the init file has this:

# chkconfig: - 85 15

I would modestly suggest changing this to something like 81 19. The
reason - these are the same settinga as httpd, and I normally want Pg
started up before the web server and shut down after the web server.

andrew

Andrew Dunstan wrote:

>
> Seems to be OK. See below.
>
> BTW, for those interested, following up a note from Joe Conway I
> discovered yesterday the Right Way (tm) to build RPMs (nothing Pg
> specific in this). Basically, you set up some rpm macros like this in
> ~/.rpmmacros:
> %_topdir %(echo ${HOME}/rpm)
> %_tmppath %{_topdir}/tmp
> %packager Your Name <yourusername(at)your(dot)org>
> and a directory tree something like this under your homedir:
> rpm
> rpm/BUILD
> rpm/RPMS
> rpm/RPMS/i386
> rpm/RPMS/i586
> rpm/RPMS/noarch
> rpm/SOURCES
> rpm/SPECS
> rpm/SRPMS
> rpm/tmp
> adjusting the subdirs of RPMS appropriately.
>
> now you can run
> rpmbuild -ba postgresql-7.3.4-1PGDG.src.rpm
>
> and everything builds nicely (assuming your have the right stuff
> installed). No need to build as root (building as root is Evil) nor to
> install the source rpm before building.
>
> Now having rescued the boat anchor \b\b\b\b\b\b\b old P1 box from the
> attic I need to find a new use for it .....
>
> cheers
>
> andrew
> -------------------------
>
>
>
> [root(at)face pgsql]# rpm -Fhv postgresql-*.rpm
> Preparing...
> ########################################### [100%]
> 1:postgresql-docs ###########################################
> [ 12%]
> 2:postgresql-jdbc ###########################################
> [ 25%]
> 3:postgresql-libs ###########################################
> [ 37%]
> 4:postgresql ###########################################
> [ 50%]
> 5:postgresql-contrib ###########################################
> [ 62%]
> 6:postgresql-devel ###########################################
> [ 75%]
> 7:postgresql-server ###########################################
> [ 87%]
> 8:postgresql-pl ###########################################
> [100%]
> [root(at)face pgsql]# /etc/init.d/postgresql stop
> [ OK ]
> [root(at)face pgsql]# /etc/init.d/postgresql start
> Starting postgresql service: [ OK ]
> [root(at)face pgsql]# su - facedba -c "psql face"
> Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> face=# select version();
> version
> -----------------------------------------------------------------
> PostgreSQL 7.3.4 on i386-redhat-linux-gnu, compiled by GCC 2.96
> (1 row)
>
> face=# \q
> [root(at)face pgsql]#
> -------------------------------------------------------
> Lamar Owen wrote:
>
>> On Tuesday 05 August 2003 08:14, Andrew Dunstan wrote:
>>
>>
>>> Will check later today.
>>>
>>
>>
>> When you do, let me know, so that I can post them.
>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>