Re: [HACKERS] problem with RH7.3 Pg7.3.4 binaries

[Andrew Dunstan]

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 <[EMAIL PROTECTED]>
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
-------------------------


[EMAIL PROTECTED] 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%]
[EMAIL PROTECTED] pgsql]# /etc/init.d/postgresql stop
                                                          [  OK  ]
[EMAIL PROTECTED] pgsql]# /etc/init.d/postgresql start
Starting postgresql service:                               [  OK  ]
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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