pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Users and multiple server environment
13+ messages / 4 participants
[nested] [flat]

* Users and multiple server environment
@ 2004-10-03 05:02 Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 13+ messages in thread

From: Michael Long @ 2004-10-03 05:02 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

I now have 2 versions of postgres running on one box (7.3.2 and 8.0b3)  
each listening on a different port. When creating a database, user or 
schema in 8.0 that exists in 7.3.2 I get an error saying it already 
exists. Can I have only one of each of these per server or am I missing 
something? If possible I would like to be able to create a test database 
on my production server that contains the same schemas and users as the 
production database.

tia,
Mike



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 05:18 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  0 siblings, 1 reply; 13+ messages in thread

From: Tom Lane @ 2004-10-03 05:18 UTC (permalink / raw)
  To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin

Michael Long <mlong@datalong.com> writes:
> I now have 2 versions of postgres running on one box (7.3.2 and 8.0b3)  
> each listening on a different port. When creating a database, user or 
> schema in 8.0 that exists in 7.3.2 I get an error saying it already 
> exists. Can I have only one of each of these per server or am I missing 
> something?

You're missing something.  Check which port you are actually talking to.

I do this all the time --- my development machine standardly has half a
dozen postmasters running on it, one for each major release 7.0-current.
They do not impinge on each other at all.  It helps to build each
release from source so that you can set a different install prefix and
default port number for each one.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-03 05:31   ` Michael Long <mlong@datalong.com>
  2004-10-03 05:45     ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  0 siblings, 2 replies; 13+ messages in thread

From: Michael Long @ 2004-10-03 05:31 UTC (permalink / raw)
  To: pgsql-admin


>You're missing something.  Check which port you are actually talking to.
>
>I do this all the time --- my development machine standardly has half a
>dozen postmasters running on it, one for each major release 7.0-current.
>They do not impinge on each other at all.  It helps to build each
>release from source so that you can set a different install prefix and
>default port number for each one.
>
>  
>
I had just discovered that I need to specify the port when creating a 
database. I had thought that I had read in the documentation that if I 
built the server from source and specified the port to use that the 
client would be bound to that by default. This does not appear to be the 
case. Maybe I misread it. Thanks for the quick response.




^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 05:45     ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 13+ messages in thread

From: Tom Lane @ 2004-10-03 05:45 UTC (permalink / raw)
  To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin

Michael Long <mlong@datalong.com> writes:
> I had just discovered that I need to specify the port when creating a 
> database. I had thought that I had read in the documentation that if I 
> built the server from source and specified the port to use that the 
> client would be bound to that by default.

The client *that you built along with the server* will bind to that port
by default.  It's not going to somehow magically propagate to other
clients built with other default port numbers.

The default port number on the client side is actually built into libpq,
not psql.  So one possible explanation if you think you've covered the
obvious bases is that you're invoking the correct version-specific psql
programs, but they are all binding to the same libpq.so.  Check
LD_LIBRARY_PATH, ldconfig configuration, etc.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 06:22     ` Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 13+ messages in thread

From: Michael Long @ 2004-10-03 06:22 UTC (permalink / raw)
  To: pgsql-admin

Michael Long wrote:

>
>> You're missing something.  Check which port you are actually talking to.
>>
>> I do this all the time --- my development machine standardly has half a
>> dozen postmasters running on it, one for each major release 7.0-current.
>> They do not impinge on each other at all.  It helps to build each
>> release from source so that you can set a different install prefix and
>> default port number for each one.
>>
Further investigation shows that I was not using the newly built psql 
binary. When attempting to use the newly built binary I get an error. 
Did I miss something during the configure/make dance. Here is what I get.

 ./psql -U proporg
./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity




^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 06:33       ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:53         ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  0 siblings, 1 reply; 13+ messages in thread

From: Tom Lane @ 2004-10-03 06:33 UTC (permalink / raw)
  To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin

Michael Long <mlong@datalong.com> writes:
> Further investigation shows that I was not using the newly built psql 
> binary. When attempting to use the newly built binary I get an error. 
> Did I miss something during the configure/make dance. Here is what I get.

>  ./psql -U proporg
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity

This looks like a 7.4 psql trying to use a pre-7.4 libpq.so.  You need
to take a close look at where you've installed the different libpq
generations and how this matches up to the ldconfig search path.

Personally I like to use rpath-style link specifications to ensure that
a particular psql generation will hook to the corresponding libpq
generation, regardless of any system-wide ldconfig settings.  There are
other ways to do it, but the default Linux mechanism doesn't work very
well for this :-(

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-03 06:53         ` Michael Long <mlong@datalong.com>
  2004-10-03 16:47           ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 13+ messages in thread

From: Michael Long @ 2004-10-03 06:53 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin


>This looks like a 7.4 psql trying to use a pre-7.4 libpq.so.  You need
>to take a close look at where you've installed the different libpq
>generations and how this matches up to the ldconfig search path.
>
>Personally I like to use rpath-style link specifications to ensure that
>a particular psql generation will hook to the corresponding libpq
>generation, regardless of any system-wide ldconfig settings.  There are
>other ways to do it, but the default Linux mechanism doesn't work very
>well for this :-(
>
>  
>
This is where I am getting into areas I don't really understand. I 
believe I have 7.3.2 installed along with 8.0b3.

/usr/bin/psql -V
psql (PostgreSQL) 7.3.2

/usr/local/pgsql_8.0b3/bin/psql -V
psql (PostgreSQL) 8.0.0beta3

The when configuring 8.0b3 I thought that I had specified to use the 
rpath style link, although now that I look at the string again, maybe not :)

./configure --prefix=/usr/local/pgsql_8.0b3 --disable-rpath 
--with-pgport=5480 --with-perl --with-python --with-tcl 
--enable-thread-safety --enable-debug --enable-cassert --enable-depend 
--with-libraries=/lib:/usr/local/lib/python2.3/lib-dynload

How do I go about sorting this out? If I rerun the istall without the 
--disable-rpath switch will this help?





^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:53         ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 16:47           ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 20:28             ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  0 siblings, 1 reply; 13+ messages in thread

From: Tom Lane @ 2004-10-03 16:47 UTC (permalink / raw)
  To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin

Michael Long <mlong@datalong.com> writes:
> The when configuring 8.0b3 I thought that I had specified to use the 
> rpath style link, although now that I look at the string again, maybe not :)

> ./configure --prefix=/usr/local/pgsql_8.0b3 --disable-rpath 

Looks like not ...

> How do I go about sorting this out? If I rerun the istall without the 
> --disable-rpath switch will this help?

I would recommend "make distclean", reconfigure, rebuild whenever you
change configure arguments.  That's the only way to be really sure the
changes propagate to everywhere they need to.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:53         ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 16:47           ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-03 20:28             ` Michael Long <mlong@datalong.com>
  2004-10-03 21:18               ` Re: Users and multiple server environment dan@kwasar.biz
  2004-10-03 22:24               ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 13+ messages in thread

From: Michael Long @ 2004-10-03 20:28 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin


>I would recommend "make distclean", reconfigure, rebuild whenever you
>change configure arguments.  That's the only way to be really sure the
>changes propagate to everywhere they need to.
>
>  
>
Tom, I followed your recommendation and rebuilt postgres after doing 
"make distclean". I still get the following

./psql template1
./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity

Is psql linked to the proper libraries?

--This is version 7.3.2
ldd /usr/bin/psql
        libpq.so.3 => /usr/lib/libpq.so.3 (0x40015000)
        libpam.so.0 => /lib/libpam.so.0 (0x4003a000)
        libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x40042000)
        libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x40072000)
        libz.so.1 => /lib/libz.so.1 (0x40149000)
        libreadline.so.4 => /lib/libreadline.so.4 (0x40158000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x40185000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x401b6000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x401c9000)
        libdl.so.2 => /lib/libdl.so.2 (0x401de000)
        libm.so.6 => /lib/libm.so.6 (0x401e1000)
        libc.so.6 => /lib/libc.so.6 (0x40203000)
        libncurses.so.5 => /lib/libncurses.so.5 (0x40339000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

ldd /usr/local/pgsql_8.0b3/bin/psql
        libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)
        libz.so.1 => /lib/libz.so.1 (0x40039000)
        libreadline.so.4 => /lib/libreadline.so.4 (0x40049000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x40076000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000)
        libdl.so.2 => /lib/libdl.so.2 (0x400ce000)
        libm.so.6 => /lib/libm.so.6 (0x400d1000)
        libc.so.6 => /lib/libc.so.6 (0x400f4000)
        libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x4022a000)
        libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x4025a000)
        libncurses.so.5 => /lib/libncurses.so.5 (0x40331000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)




^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:53         ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 16:47           ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 20:28             ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 21:18               ` dan@kwasar.biz
  1 sibling, 0 replies; 13+ messages in thread

From: dan@kwasar.biz @ 2004-10-03 21:18 UTC (permalink / raw)
  To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin

Quoting Michael Long <mlong@datalong.com>:

>
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
>
> Is psql linked to the proper libraries?
>
> --This is version 7.3.2

Below looks okay.

> ldd /usr/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40015000)
>         libpam.so.0 => /lib/libpam.so.0 (0x4003a000)
>         libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x40042000)
>         libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x40072000)
>         libz.so.1 => /lib/libz.so.1 (0x40149000)
>         libreadline.so.4 => /lib/libreadline.so.4 (0x40158000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x40185000)
>         libresolv.so.2 => /lib/libresolv.so.2 (0x401b6000)
>         libnsl.so.1 => /lib/libnsl.so.1 (0x401c9000)
>         libdl.so.2 => /lib/libdl.so.2 (0x401de000)
>         libm.so.6 => /lib/libm.so.6 (0x401e1000)
>         libc.so.6 => /lib/libc.so.6 (0x40203000)
>         libncurses.so.5 => /lib/libncurses.so.5 (0x40339000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>

I've never installed 8.0b3, but I would guess that libpq is also found in
/usr/local. Check for a second copy there and modify LD_LIBRARY_PATH and/or
/etc/ld.so.conf (followed by ldconfig) on Linux to look there first.

> ldd /usr/local/pgsql_8.0b3/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)
>         libz.so.1 => /lib/libz.so.1 (0x40039000)
>         libreadline.so.4 => /lib/libreadline.so.4 (0x40049000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x40076000)
>         libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000)
>         libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000)
>         libdl.so.2 => /lib/libdl.so.2 (0x400ce000)
>         libm.so.6 => /lib/libm.so.6 (0x400d1000)
>         libc.so.6 => /lib/libc.so.6 (0x400f4000)
>         libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x4022a000)
>         libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x4025a000)
>         libncurses.so.5 => /lib/libncurses.so.5 (0x40331000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:53         ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 16:47           ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 20:28             ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
@ 2004-10-03 22:24               ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-04 13:17                 ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  1 sibling, 1 reply; 13+ messages in thread

From: Tom Lane @ 2004-10-03 22:24 UTC (permalink / raw)
  To: Michael Long <mlong@datalong.com>; +Cc: pgsql-admin

Michael Long <mlong@datalong.com> writes:
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity

> Is psql linked to the proper libraries?

> ldd /usr/local/pgsql_8.0b3/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)

Obviously not :-(.  This should be pointing to /usr/local/pgsql_8.0b3/lib/
so it seems you didn't do the rpath enabling correctly; or maybe your
system is configured in a way that overrides rpath (do you have
LD_LIBRARY_PATH set in your environment?).

I don't have any more advice than that to give; you may need to find a
Linux shared-library guru to help you fix it.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
  2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 05:18 ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 05:31   ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:22     ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 06:33       ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 06:53         ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 16:47           ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-03 20:28             ` Re: Users and multiple server environment Michael Long <mlong@datalong.com>
  2004-10-03 22:24               ` Re: Users and multiple server environment Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-04 13:17                 ` Michael Long <mlong@datalong.com>
  0 siblings, 0 replies; 13+ messages in thread

From: Michael Long @ 2004-10-04 13:17 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin


>Obviously not :-(.  This should be pointing to /usr/local/pgsql_8.0b3/lib/
>so it seems you didn't do the rpath enabling correctly; or maybe your
>system is configured in a way that overrides rpath (do you have
>LD_LIBRARY_PATH set in your environment?).
>
>  
>
Yay!! When I set LD_LIBRARY_PATH then things work correctly. Your 
patience and help is very much appreciated. If you are ever in the 
Boston area I will buy you a beer.

>I don't have any more advice than that to give; you may need to find a
>Linux shared-library guru to help you fix it.
>  
>
One final question, I used the following to configure the build. Did I 
do something to cause the library to not link properly or do I need to 
find a Linux shared-library guru?

./configure --prefix=/usr/local/pgsql_8.0b3 --with-pgport=5480 
--with-perl --with-python --with-tcl --enable-thread-safety 
--enable-debug --enable-cassert --enable-depend



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: Users and multiple server environment
@ 2004-10-05 01:17 Cao Van Khanh <cvkhanh@cmc.com.vn>
  0 siblings, 0 replies; 13+ messages in thread

From: Cao Van Khanh @ 2004-10-05 01:17 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Try : 
./psql -d template1




-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Monday, October 04, 2004 5:25 AM
To: Michael Long
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Users and multiple server environment 

Michael Long <mlong@datalong.com> writes:
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol:
PQsetErrorVerbosity

> Is psql linked to the proper libraries?

> ldd /usr/local/pgsql_8.0b3/bin/psql
>         libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)

Obviously not :-(.  This should be pointing to
/usr/local/pgsql_8.0b3/lib/
so it seems you didn't do the rpath enabling correctly; or maybe your
system is configured in a way that overrides rpath (do you have
LD_LIBRARY_PATH set in your environment?).

I don't have any more advice than that to give; you may need to find a
Linux shared-library guru to help you fix it.

			regards, tom lane

---------------------------(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





^ permalink  raw  reply  [nested|flat] 13+ messages in thread


end of thread, other threads:[~2004-10-05 01:17 UTC | newest]

Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-03 05:02 Users and multiple server environment Michael Long <mlong@datalong.com>
2004-10-03 05:18 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-03 05:31   ` Michael Long <mlong@datalong.com>
2004-10-03 05:45     ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-03 06:22     ` Michael Long <mlong@datalong.com>
2004-10-03 06:33       ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-03 06:53         ` Michael Long <mlong@datalong.com>
2004-10-03 16:47           ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-03 20:28             ` Michael Long <mlong@datalong.com>
2004-10-03 21:18               ` dan@kwasar.biz
2004-10-03 22:24               ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-04 13:17                 ` Michael Long <mlong@datalong.com>
2004-10-05 01:17 Re: Users and multiple server environment Cao Van Khanh <cvkhanh@cmc.com.vn>

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