John Nealy ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
7.2.1 createdb test gives segmentation fault

Long Description
When installing PG 7.2.1 from source on S/390 Linux using the
--enable-multibyte option I cannot create databases and psql does not work at all.  
Everything is fine using plain ./configure.  I wanted to use the multibyte because I 
need to compile a PHP 4.x Apache module to interface with PgSQL.  Without it I get 
Undefined symbol... pg_encoding_to_char then starting Apache.  Anyway, below is some 
relevant output:

first do initdb:
[postgres@linux1 postgres]$/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.                                  
                                                                             
Fixing permissions on existing directory /usr/local/pgsql/data... ok         
creating directory /usr/local/pgsql/data/base... ok                          
creating directory /usr/local/pgsql/data/global... ok                        
creating directory /usr/local/pgsql/data/pg_xlog... ok                       
creating directory /usr/local/pgsql/data/pg_clog... ok                       
creating template1 database in /usr/local/pgsql/data/base/1... ok            
creating configuration files... ok                                           
initializing pg_shadow... ok                                                 
enabling unlimited row size for system tables... ok                          
creating system views... ok                                                  
loading pg_description... ok                                                 
vacuuming database template1... ok                                           
copying template1 to template0... ok                                         
                                                                             
Success. You can now start the database server using:                        
                                                                             
    /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data                 
or                                                                           
    /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start    
                                                                             
[postgres@linux1 postgres]$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l 
logfile start                                                               
postmaster successfully started

[postgres@linux1 postgres]$ /usr/local/pgsql/bin/createdb test                  
/usr/local/pgsql/bin/createdb: line 172:  9309 Segmentation fault      (core dum
ped) ${PATHNAME}psql $PSQLOPT -d template1 -c "CREATE DATABASE \"$dbname\"$withs
tring"                                                                          
createdb: database creation failed
[postgres@linux1 postgres]$


logfile has 
DEBUG:  database system was shut down at 2002-08-22 09:15:04 GMT        
DEBUG:  checkpoint record is at 0/113640                                
DEBUG:  redo record is at 0/113640; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 89; next oid: 16556                        
DEBUG:  database system is ready                                        
DEBUG:  pq_recvbuf: unexpected EOF on client connection

from command line:
[postgres@linux1 postgres]$ psql template1
Segmentation fault (core dumped)          
[postgres@linux1 postgres]$

Should I just try a previous version on Pg (or PHP)? Any help is greatly appreciated.

Sample Code


No file was uploaded with this report


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to