pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql error
16+ messages / 10 participants
[nested] [flat]
* psql error
@ 2002-02-19 11:47 Gtrica <gtricarico@intin.it>
2002-02-19 16:32 ` Re: psql error Andrey Romanchenko <RomanchenkoAV@belhard.com>
2002-02-22 00:30 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 16+ messages in thread
From: Gtrica @ 2002-02-19 11:47 UTC (permalink / raw)
To: pgsql-admin
I'm new with postgress datbase..
I have started correctly postmaster, I created a database "primo" ...
Now when I try to start "psql primo" I receive the following error
"psql : FATAL 1: cannot create init file
.//base/primo/pg_internal.init.1179"
Regards
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2002-02-19 11:47 psql error Gtrica <gtricarico@intin.it>
@ 2002-02-19 16:32 ` Andrey Romanchenko <RomanchenkoAV@belhard.com>
1 sibling, 0 replies; 16+ messages in thread
From: Andrey Romanchenko @ 2002-02-19 16:32 UTC (permalink / raw)
To: pgsql-admin
Gtrica wrote:
> I'm new with postgress datbase..
>
> I have started correctly postmaster, I created a database "primo" ...
> Now when I try to start "psql primo" I receive the following error
> "psql : FATAL 1: cannot create init file
> .//base/primo/pg_internal.init.1179"
>
> Regards
What permissions on base/primo?
seems that postmaster cannot create file in directory above.
--
Best regards!
Andrey Romanchenko (RomanchenkoAV@belhard.com)
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2002-02-19 11:47 psql error Gtrica <gtricarico@intin.it>
@ 2002-02-22 00:30 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 16+ messages in thread
From: Tom Lane @ 2002-02-22 00:30 UTC (permalink / raw)
To: Gtrica <gtricarico@intin.it>; +Cc: pgsql-admin
"Gtrica" <gtricarico@intin.it> writes:
> I'm new with postgress datbase..
> I have started correctly postmaster, I created a database "primo" ...
> Now when I try to start "psql primo" I receive the following error
> "psql : FATAL 1: cannot create init file
> .//base/primo/pg_internal.init.1179"
It looks to me like you tried to start the postmaster with a relative
PGDATA path (something like "postmaster -D ."). Try an absolute
path instead.
(IIRC, PG 7.1 and later will accept a relative path, but earlier versions
don't cope. If you are indeed running something older than 7.1, it's
definitely a good idea to update.)
regards, tom lane
^ permalink raw reply [nested|flat] 16+ messages in thread
* psql error
@ 2006-11-03 04:07 Tahir Tamba <tamba.tahir@courrier.uqam.ca>
2006-11-03 07:15 ` Re: psql error Adam Radlowski <adamr@informatyka.gdansk.pl>
0 siblings, 1 reply; 16+ messages in thread
From: Tahir Tamba @ 2006-11-03 04:07 UTC (permalink / raw)
To: pgsql-admin
This is a multi-part message in MIME format.
--Boundary_(ID_NmMOnj4f7z82KPIJx2SkMA)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline
<BODY><P>Dear all,</P>
<P>I installed the compiled version of PostgreSQL 8.1.5 on WinXP Pro OS and I'm experiencing some difficulties using psql terminal to do some commun tasks like adding columns and populate them with values.</P>
<P>when executing the command for this statement: <FONT face=NimbusMonL-Regu-Extend_850></P></FONT>
<P align=left>AddGeometryColumn ( [Table],</P>
<P align=left>[ Colonne_Geometrique ],</P>
<P align=left>[SRID],</P>
<P align=left>[ Type_Geometrie ],</P>
<P align=left>[Dimension ]);</P>
<P align=left>I receive the following error message: "more" is not recognized as an intern command , an executable program or command files.</P>
<P align=left>This seems like a broken installation of Windows. So I could not seen more.exe into my Win32Systems.</P>
<P align=left>Any idea or suggestion to resolve this would be appreciated</P>
<P align=left>Kind regards<BR><BR>Tahir Tamba <BR></P></BODY>
--Boundary_(ID_NmMOnj4f7z82KPIJx2SkMA)
Content-type: text/x-vcard; name=tamba.tahir.vcf; charset=iso-8859-1
Content-transfer-encoding: base64
Content-disposition: attachment; filename=tamba.tahir.vcf
Content-description: Card for Tahir Tamba <tamba.tahir@courrier.uqam.ca>
YmVnaW46dmNhcmQNCm46VGFtYmE7VGFoaXINCmZuOiAgVGFoaXIgVGFtYmENCnRlbDto
b21lOig1MTQpIDUyNi03NTQzDQp2ZXJzaW9uOjIuMQ0KZW1haWw7aW50ZXJuZXQ6dGFt
YmEudGFoaXJAY291cnJpZXIudXFhbS5jYQ0KdGl0bGU6Q29uc2VpbGxlciBlbiBhbelu
YWdlbWVudCBkdSB0ZXJyaXRvaXJlIGV0IFN5c3TobWVzIGQnaW5mb3JtYXRpb24gZ+lv
Z3JhcGhpcXVlDQplbmQ6dmNhcmQNCg==
--Boundary_(ID_NmMOnj4f7z82KPIJx2SkMA)--
Attachments:
tamba.tahir.vcf (text/x-vcard, 226B) download
begin:vcard
n:Tamba;Tahir
fn: Tahir Tamba
tel;home:(514) 526-7543
version:2.1
email;internet:tamba.tahir@courrier.uqam.ca
title:Conseiller en aménagement du territoire et Systèmes d'information géographique
end:vcard
* Re: psql error
2006-11-03 04:07 psql error Tahir Tamba <tamba.tahir@courrier.uqam.ca>
@ 2006-11-03 07:15 ` Adam Radlowski <adamr@informatyka.gdansk.pl>
0 siblings, 0 replies; 16+ messages in thread
From: Adam Radlowski @ 2006-11-03 07:15 UTC (permalink / raw)
To: Tahir Tamba <tamba.tahir@courrier.uqam.ca>; +Cc: pgsql-admin
If "more.com" (not more.exe) in windos XP Pro is not installed in
WINDIR/system32 (WINDIR directory is usually after standard installation
called WINDOWS), You can it find on install disk in directory "i386" as
more.co_ - You shuold extract it with "extract.exe". You can use
"more.exe" from DJGPP (gcc project for DOS) too, when You have install
disk without "more.co_" (but it should be on this disk).
I'm sure, that You know this, but:
You If You can't call programs from WINDIR/system32 without call them
with full path (this is abnormal situation), put line into Your
"autoexec.bat":
SET PATH=%PATH%;c:\windows\system32
...and restart Windos
Greetings
Adam
Tahir Tamba wrote:
> Dear all,
>
> I installed the compiled version of PostgreSQL 8.1.5 on WinXP Pro OS
> and I'm experiencing some difficulties using psql terminal to do some
> commun tasks like adding columns and populate them with values.
>
> when executing the command for this statement:
>
> AddGeometryColumn ( [Table],
>
> [ Colonne_Geometrique ],
>
> [SRID],
>
> [ Type_Geometrie ],
>
> [Dimension ]);
>
> I receive the following error message: "more" is not recognized as an
> intern command , an executable program or command files.
>
> This seems like a broken installation of Windows. So I could not seen
> more.exe into my Win32Systems.
>
> Any idea or suggestion to resolve this would be appreciated
>
> Kind regards
>
> Tahir Tamba
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
^ permalink raw reply [nested|flat] 16+ messages in thread
* FW: psql error
@ 2013-04-02 06:25 archana shinde <archii4u@gmail.com>
2013-04-03 09:48 ` Re: FW: psql error Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 1 reply; 16+ messages in thread
From: archana shinde @ 2013-04-02 06:25 UTC (permalink / raw)
To: pgsql-admin
Please look at below mail and help me on this.
------------------------------
From: Archana.2.Shinde
Sent: 02-04-2013 11:53
To: archii4u@gmail.com
Subject: psql error
Hi postgres team,
Please could you help me to resolve this error which I am getting, I am
using postgres 7.4.5 on solaris 9.
2013-03-28 12:03:05 LOG: could not bind socket for statistics collector:
Cannot assign requested address
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 LOG: connection received: host=[local] port=
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 FATAL: the database system is starting up
2013-03-28 12:03:05 LOG: database system was interrupted at 2013-03-26
19:44:47 GMT
2013-03-28 12:03:05 LOG: checkpoint record is at 338B/87AC3F68
2013-03-28 12:03:05 LOG: redo record is at 338B/87AC3F68; undo record is
at 0/0; shutdown TRUE
2013-03-28 12:03:05 LOG: next transaction ID: 210567474; next OID:
283025408
2013-03-28 12:03:05 LOG: database system was not properly shut down;
automatic recovery in progress
2013-03-28 12:03:05 LOG: record with zero length at 338B/87AC3FA8
2013-03-28 12:03:05 LOG: redo is not required
2013-03-28 12:03:06 LOG: connection received: host=[local] port=
2013-03-28 12:03:06 FATAL: the database system is starting up
2013-03-28 12:03:06 LOG: connection received: host=[local] port=
2013-03-28 12:03:06 FATAL: the database system is starting up
2013-03-28 12:03:07 LOG: connection received: host=[local] port=
2013-03-28 12:03:07 FATAL: the database system is starting up
2013-03-28 12:03:07 LOG: connection received: host=[local] port=
2013-03-28 12:03:07 FATAL: the database system is starting up
2013-03-28 12:03:07 LOG: connection received: host=[local] port=
2013-03-28 12:03:07 FATAL: the database system is starting up
2013-03-28 12:03:08 LOG: database system is ready
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection received: host=[local] port=
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:10 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:12 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 LOG: connection received: host=[local] port=
2013-03-28 12:03:15 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:15 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:16 LOG: connection received: host=[local] port=
2013-03-28 12:03:16 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:16 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:16 LOG: connection received: host=[local] port=
2013-03-28 12:03:16 LOG: connection received: host=[local] port=
2013-03-28 12:03:17 2013-03-28 12:03:17 LOG: connection received:
host=[local] port=
2013-03-28 12:03:17 2013-03-28 12:03:17 2013-03-28 12:03:17 LOG:
connection authorized: user=mcdonner database=template1
LOG: connection authorized: user=mcdonner database=template1
LOG: connection received: host=[local] port=
LOG: connection received: host=[local] port=
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:17 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:17 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:17 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:22 LOG: connection received: host=[local] port=
2013-03-28 12:03:22 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 2013-03-28 12:03:23 ERROR: database "backupnetwork"
does not exist
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:23 LOG: connection received: host=[local] port=
2013-03-28 12:03:23 LOG: connection authorized: user=mcdonner
database=template1
LOG: connection authorized: user=mcdonner database=template1
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:23 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:25 LOG: connection received: host=[local] port=
2013-03-28 12:03:25 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:25 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:26 LOG: connection received: host=[local] port=
2013-03-28 12:03:26 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:26 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:27 LOG: connection received: host=[local] port=
2013-03-28 12:03:27 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:27 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 LOG: connection received: host=[local] port=
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:33 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:33 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:35 LOG: connection received: host=[local] port=
2013-03-28 12:03:35 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:35 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:36 LOG: connection received: host=[local] port=
2013-03-28 12:03:36 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:36 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:37 LOG: connection received: host=[local] port=
2013-03-28 12:03:37 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:37 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 12:03:43 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 12:03:43 ERROR: database "backupnetwork" does not exist
2013-03-28 12:03:43 LOG: connection received: host=[local] port=
2013-03-28 19:59:56 ERROR: database "backupnetwork" does not exist
2013-03-28 19:59:56 LOG: connection received: host=[local] port=
2013-03-28 19:59:56 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 19:59:56 ERROR: database "backupnetwork" does not exist
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:11 LOG: connection received: host=[local] port=
2013-03-28 20:00:12 2013-03-28 20:00:12 LOG: connection authorized:
user=mcdonner database=template1
LOG: connection authorized: user=mcdonner database=template1
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
TopMemoryContextTopMemoryContext: 24576: total in 245762 total in blocks;
210272 blocks; free (102722 free ( chunks); 2143
04 chunks); used
14304CacheMemoryContext used
: CacheMemoryContext8192: total in 81921 total in blocks; 12864 blocks;
free (28640 free ( chunks); 05328 chunks); used
5328pg_class_oid_index used
: pg_class_oid_index1024: total in 10241 total in blocks; 1640 blocks;
free (6400 free ( chunks); 0384 chunks); used
384MdSmgr used
: MdSmgr8192: total in 81921 total in blocks; 16120 blocks; free (61200
free ( chunks); 02072 chunks); used
2072DynaHash used
: DynaHash8192: total in 81921 total in blocks; 14664 blocks; free
(46640 free ( chunks); 03528 chunks); used
3528DynaHashTable used
: DynaHashTable8192: total in 81921 total in blocks; 15080 blocks; free
(50800 free ( chunks); 03112 chunks); used
3112DynaHashTable used
: DynaHashTable8192: total in 81921 total in blocks; 15080 blocks; free
(50800 free ( chunks); 03112 chunks); used
3112DynaHashTable used
: DynaHashTable8192: total in 81921 total in blocks; 15080 blocks; free
(50800 free ( chunks); 03112 chunks); used
3112DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
( chunks); 00 chunks); used
0DynaHashTable used
: 0DynaHashTable total in : 00 total in blocks; 00 blocks; free (00 free
(TopMemoryContext0 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
DynaHashTableDynaHashTable: 0: 0 total in total in 00 blocks; blocks; 00
free ( free (00 chunks); chunks); 00 used
used
ErrorContextErrorContext: : 81928192 total in total in 11 blocks; blocks;
81768176 free ( free (44 chunks); chunks); 1616
used
used
: 2013-03-28 20:00:12 2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 112.
FATAL: out of memory
DETAIL: Failed on request of size 112.
24576TopMemoryContext total in TopMemoryContext2 blocks; 10272 free (2
chunks); 14304 used
CacheMemoryContext: 8192 total in 1 blocks; 2864 free (0 chunks); 5328 used
pg_class_oid_index: 1024 total in 1 blocks; 640 free (0 chunks); 384 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 4664 free (0 chunks); 3528 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 112.
DETAIL: Failed on request of size 112.
: 24576 total in 2 blocks; 10272 free (2 chunks); 14304 used
CacheMemoryContext: 8192 total in 1 blocks; 2864 free (0 chunks); 5328 used
pg_class_oid_index: 1024 total in 1 blocks; 640 free (0 chunks); 384 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 4664 free (0 chunks); 3528 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 8192 total in 1 blocks; 5080 free (0 chunks); 3112 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 112.
2013-03-28 20:00:12 LOG: connection received: host=[local] port=
2013-03-28 20:00:12 LOG: connection authorized: user=mcdonner
database=template1
: 24576 total in 2 blocks; 10680 free (2 chunks); 13896 used
CacheMemoryContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
MdSmgr: 8192 total in 1 blocks; 6120 free (0 chunks); 2072 used
DynaHash: 8192 total in 1 blocks; 4952 free (0 chunks); 3240 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
2013-03-28 20:00:12 LOG: could not fork new process for connection: Not
enough space
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
DynaHashTable: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used
2013-03-28 20:00:12 FATAL: out of memory
DETAIL: Failed on request of size 1024.
2013-03-28 20:00:37 LOG: could not fork checkpoint process: Not enough
space
2013-03-28 20:00:40 LOG: server process (PID 224) was terminated by signal
11
2013-03-28 20:00:40 LOG: terminating any other active server processes
2013-03-28 20:00:40 LOG: all server processes terminated; reinitializing
2013-03-28 20:00:41 FATAL: could not create shared memory segment: Not
enough space
DETAIL: Failed system call was shmget(key=5432001, size=118464512, 03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space
. To reduce the request size (currently 118464512 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 14080) and/
or its max_connections parameter (currently 40).
The PostgreSQL documentation contains more information about shared
memory configuration.
============================================================================================================================Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you
may review the policy at http://www.techmahindra.com/Disclaimer.html
externally and http://tim.techmahindra.com/tim/disclaimer.html
internally within Tech
Mahindra.============================================================================================================================
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: FW: psql error
2013-04-02 06:25 FW: psql error archana shinde <archii4u@gmail.com>
@ 2013-04-03 09:48 ` Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 0 replies; 16+ messages in thread
From: Albe Laurenz @ 2013-04-03 09:48 UTC (permalink / raw)
To: archana shinde *EXTERN* <archii4u@gmail.com>; pgsql-admin
archana shinde wrote:
> Please look at below mail and help me on this.
> Please could you help me to resolve this error which I am getting, I am using postgres 7.4.5 on
> solaris 9.
[...]
> 2013-03-28 20:00:12 FATAL: out of memory
> DETAIL: Failed on request of size 112.
[...]
> 2013-03-28 20:00:12 FATAL: out of memory
> DETAIL: Failed on request of size 1024.
> 2013-03-28 20:00:37 LOG: could not fork checkpoint process: Not enough space
> 2013-03-28 20:00:40 LOG: server process (PID 224) was terminated by signal 11
> 2013-03-28 20:00:40 LOG: terminating any other active server processes
> 2013-03-28 20:00:40 LOG: all server processes terminated; reinitializing
> 2013-03-28 20:00:41 FATAL: could not create shared memory segment: Not enough space
> DETAIL: Failed system call was shmget(key=5432001, size=118464512, 03600).
> HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded
> available memory or swap space
> . To reduce the request size (currently 118464512 bytes), reduce PostgreSQL's shared_buffers parameter
> (currently 14080) and/
> or its max_connections parameter (currently 40).
>
> The PostgreSQL documentation contains more information about shared memory configuration.
7.4 has been out of support for a while.
This looks like you cannot allocate enough shared memory.
If there is enough RAM in the machine, consider increasing
SHMALL (or maybe SHMMNI).
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 16+ messages in thread
* psql error
@ 2018-03-21 17:20 dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 16+ messages in thread
From: dbx postgres @ 2018-03-21 17:20 UTC (permalink / raw)
To: pgsql-admin
Hello,
I have postgres running on my server but when i try to run psql I get the
below error
*psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams *
I have set the environment variable and the data directory but still no
luck. Can anyone guide me how I can resolve this?
Thanks,
Azim
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
@ 2018-03-21 19:06 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
0 siblings, 1 reply; 16+ messages in thread
From: Tom Lane @ 2018-03-21 19:06 UTC (permalink / raw)
To: dbx postgres <dbx2postgres@gmail.com>; +Cc: pgsql-admin
dbx postgres <dbx2postgres@gmail.com> writes:
> I have postgres running on my server but when i try to run psql I get the
> below error
> *psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams *
Apparently, you have a 9.0-or-later psql trying to use a pre-9.0 copy
of libpq.so, because that function was added in 9.0. This would seem
to mean that you have (portions of?) at least two different PG
installations, and they're not staying out of each others' way.
Hard to say more than that with only this much data.
If this is a Linux platform, applying "ldd" to the psql executable
would reveal which libpq it's trying to use.
regards, tom lane
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
@ 2018-03-21 19:25 ` Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 16+ messages in thread
From: Azimuddin Mohammed @ 2018-03-21 19:25 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: dbx postgres <dbx2postgres@gmail.com>; pgsql-admin
You are right, current postgres version installed is 9.4 and below is the
output for ldd. Is there a way I can fix this ?
linux-vdso.so.1 => (0x00007fff05bef000)
libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x0000003eb9a00000)
libpam.so.0 => /lib64/libpam.so.0 (0x000000390f600000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x000000390ee00000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x0000003eb7600000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2
(0x000000390ea00000)
libdl.so.2 => /lib64/libdl.so.2 (0x0000003eb1200000)
libm.so.6 => /lib64/libm.so.6 (0x0000003eb1e00000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00000031e5000000)
libc.so.6 => /lib64/libc.so.6 (0x0000003eb0a00000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x000000390e600000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x000000390de00000)
libz.so.1 => /lib64/libz.so.1 (0x0000003eb1a00000)
libaudit.so.1 => /lib64/libaudit.so.1 (0x000000390d600000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000003eb4e00000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x0000003eb8a00000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x0000003eb3200000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0
(0x0000003eb9600000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x0000003eb6e00000)
/lib64/ld-linux-x86-64.so.2 (0x0000003eb0600000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00000031e3c00000)
libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003eb8600000)
libssl3.so => /usr/lib64/libssl3.so (0x00000031e3800000)
libsmime3.so => /usr/lib64/libsmime3.so (0x00000031e3400000)
libnss3.so => /usr/lib64/libnss3.so (0x00000031e3000000)
libnssutil3.so => /usr/lib64/libnssutil3.so (0x0000003eb3600000)
libplds4.so => /lib64/libplds4.so (0x0000003eb4200000)
libplc4.so => /lib64/libplc4.so (0x0000003eb3e00000)
libnspr4.so => /lib64/libnspr4.so (0x0000003eb2e00000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003eb0e00000)
libfreebl3.so => /lib64/libfreebl3.so (0x0000003eb4600000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x0000003eb2200000)
librt.so.1 => /lib64/librt.so.1 (0x0000003eb1600000)
On Wed, Mar 21, 2018 at 2:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> dbx postgres <dbx2postgres@gmail.com> writes:
> > I have postgres running on my server but when i try to run psql I get the
> > below error
>
> > *psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams *
>
> Apparently, you have a 9.0-or-later psql trying to use a pre-9.0 copy
> of libpq.so, because that function was added in 9.0. This would seem
> to mean that you have (portions of?) at least two different PG
> installations, and they're not staying out of each others' way.
> Hard to say more than that with only this much data.
>
> If this is a Linux platform, applying "ldd" to the psql executable
> would reveal which libpq it's trying to use.
>
> regards, tom lane
>
>
--
Regards,
Azim
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
@ 2018-03-21 19:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:44 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 20:12 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
0 siblings, 2 replies; 16+ messages in thread
From: Tom Lane @ 2018-03-21 19:29 UTC (permalink / raw)
To: Azimuddin Mohammed <azimeiu@gmail.com>; +Cc: dbx postgres <dbx2postgres@gmail.com>; pgsql-admin
Azimuddin Mohammed <azimeiu@gmail.com> writes:
> You are right, current postgres version installed is 9.4 and below is the
> output for ldd. Is there a way I can fix this ?
I don't see libpq.so in that list at all. Maybe you don't have it
installed, or it's not in the loader search path?
regards, tom lane
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
@ 2018-03-21 19:44 ` dbx postgres <dbx2postgres@gmail.com>
2018-03-22 07:38 ` Re: psql error Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 1 reply; 16+ messages in thread
From: dbx postgres @ 2018-03-21 19:44 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Azimuddin Mohammed <azimeiu@gmail.com>; pgsql-admin
How can I get all libs required for 9.4 version without loosing data?
On Wed, Mar 21, 2018 at 2:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Azimuddin Mohammed <azimeiu@gmail.com> writes:
> > You are right, current postgres version installed is 9.4 and below is the
> > output for ldd. Is there a way I can fix this ?
>
> I don't see libpq.so in that list at all. Maybe you don't have it
> installed, or it's not in the loader search path?
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:44 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
@ 2018-03-22 07:38 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-03-22 08:10 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
0 siblings, 1 reply; 16+ messages in thread
From: Laurenz Albe @ 2018-03-22 07:38 UTC (permalink / raw)
To: dbx postgres <dbx2postgres@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Azimuddin Mohammed <azimeiu@gmail.com>; pgsql-admin
dbx postgres wrote:
> How can I get all libs required for 9.4 version without loosing data?
That depends a lot on your operating system, the way you installed PostgreSQL,
what exactly you installed where, and so on - details you didn't care to tell us.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:44 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-22 07:38 ` Re: psql error Laurenz Albe <laurenz.albe@cybertec.at>
@ 2018-03-22 08:10 ` dbx postgres <dbx2postgres@gmail.com>
2018-03-22 08:23 ` Re: psql error Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 16+ messages in thread
From: dbx postgres @ 2018-03-22 08:10 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Azimuddin Mohammed <azimeiu@gmail.com>; pgsql-admin
I did not say bcoz I did not installed it :-) What I know is it was
upgraded from 8.4 to 9.4 with all default directory(s).
On Thu, Mar 22, 2018 at 2:38 AM, Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> dbx postgres wrote:
> > How can I get all libs required for 9.4 version without loosing data?
>
> That depends a lot on your operating system, the way you installed
> PostgreSQL,
> what exactly you installed where, and so on - details you didn't care to
> tell us.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:44 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-22 07:38 ` Re: psql error Laurenz Albe <laurenz.albe@cybertec.at>
2018-03-22 08:10 ` Re: psql error dbx postgres <dbx2postgres@gmail.com>
@ 2018-03-22 08:23 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 16+ messages in thread
From: Laurenz Albe @ 2018-03-22 08:23 UTC (permalink / raw)
To: dbx postgres <dbx2postgres@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Azimuddin Mohammed <azimeiu@gmail.com>; pgsql-admin
dbx postgres wrote:
> > > How can I get all libs required for 9.4 version without loosing data?
> >
> > That depends a lot on your operating system, the way you installed PostgreSQL,
> > what exactly you installed where, and so on - details you didn't care to tell us.
>
> I did not say bcoz I did not installed it :-) What I know is it was upgraded from
> 8.4 to 9.4 with all default directory(s).
Then it might be a good idea to hire somebody with a basic knowledge of the operating
system you are on, who could fix the problem for you.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 16+ messages in thread
* Re: psql error
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Re: psql error Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Re: psql error Tom Lane <tgl@sss.pgh.pa.us>
@ 2018-03-21 20:12 ` dbx postgres <dbx2postgres@gmail.com>
1 sibling, 0 replies; 16+ messages in thread
From: dbx postgres @ 2018-03-21 20:12 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Azimuddin Mohammed <azimeiu@gmail.com>; pgsql-admin
How can I get the libs required for 9.4 without loosing any data ? can
anyone please help?
On Wed, Mar 21, 2018 at 2:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Azimuddin Mohammed <azimeiu@gmail.com> writes:
> > You are right, current postgres version installed is 9.4 and below is the
> > output for ldd. Is there a way I can fix this ?
>
> I don't see libpq.so in that list at all. Maybe you don't have it
> installed, or it's not in the loader search path?
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 16+ messages in thread
end of thread, other threads:[~2018-03-22 08:23 UTC | newest]
Thread overview: 16+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-02-19 11:47 psql error Gtrica <gtricarico@intin.it>
2002-02-19 16:32 ` Andrey Romanchenko <RomanchenkoAV@belhard.com>
2002-02-22 00:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-11-03 04:07 psql error Tahir Tamba <tamba.tahir@courrier.uqam.ca>
2006-11-03 07:15 ` Adam Radlowski <adamr@informatyka.gdansk.pl>
2013-04-02 06:25 FW: psql error archana shinde <archii4u@gmail.com>
2013-04-03 09:48 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2018-03-21 17:20 psql error dbx postgres <dbx2postgres@gmail.com>
2018-03-21 19:06 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:25 ` Azimuddin Mohammed <azimeiu@gmail.com>
2018-03-21 19:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2018-03-21 19:44 ` dbx postgres <dbx2postgres@gmail.com>
2018-03-22 07:38 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-03-22 08:10 ` dbx postgres <dbx2postgres@gmail.com>
2018-03-22 08:23 ` Laurenz Albe <laurenz.albe@cybertec.at>
2018-03-21 20:12 ` dbx postgres <dbx2postgres@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox