From: | "Nigel Bishop" <Nigel(dot)Bishop(at)ioko(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | FW: Error in logfile on DB startup |
Date: | 2004-07-26 09:02:32 |
Message-ID: | 72558D9A7573814BB4082A28843E03D421B7B5@intyodc01.uk.ioko365.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Any help would be much appreciated especially with the first problem
Thanks,
Nigel
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Nigel Bishop
Sent: 20 July 2004 14:50
To: pgsql-admin(at)postgresql(dot)org
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-07-26 11:59:12 | Re: Utilizing multiple disks |
Previous Message | Tom Lane | 2004-07-26 05:24:04 | Re: could not fork new process for connection: Cannot allocate memory |