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@your.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@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@face pgsql]# /etc/init.d/postgresql stop
>                                                           [  OK  ]
> [root@face pgsql]# /etc/init.d/postgresql start
> Starting postgresql service:                               [  OK  ]
> [root@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@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
>