Any help would be much appreciated especially with the first problem Thanks, Nigel
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nigel Bishop Sent: 20 July 2004 14:50 To: [EMAIL PROTECTED] Subject: [ADMIN] Error in logfile on DB startup Hi Solaris 8, PG 7.4.2 installed from source The DB appears to be running OK I set the following in the pg_conf file to invoke statistics gathering: stats_start_collector = true stats_block_level = true In the logfile after the DB was re-started the following appeared: 2004-07-19 16:25:12 LOG: could not bind socket for statistics collector: Cannot assign requested address I found 1 hit with someone who had a similar problem but I was unsure to the fix I believe that the solution lies with this file /etc/inet/ipnodes, the contents of which are: # # Internet host table # ::1 localhost 127.0.0.1 localhost Am I right in assuming that the line beginning ::1 needs to be commented out? And PG restarted ~ If this does fix the problem does that then mean that the following view will be populated - pg_statio_all_tables - at the moment it's empty ***** One other question how do I format the output from a SQL query - in Oracle I can use the COLUMN command: COLUMN col1 FORMAT A10 COLUMN col2 FORMAT 999,999 SELECT col1,col2 FROM table1; Thanks very much for any help provided. Nigel ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
