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 gener
Michael Long <[EMAIL PROTECTED]> 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: relo
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
I am trying to dump a schema that was created on the windows version of
postgres. I am getting an error that I don't understand.. I can dump the
entire database with the superuser but dumping one schema doesn't seem
to work.
pg_dump -v -U proporg > temp1.sql
pg_dump: reading schemas
pg_dump: re
Michael Long <[EMAIL PROTECTED]> 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 defau
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 s
Michael Long <[EMAIL PROTECTED]> 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 o
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
somet
Don´t forget to remove your old bison BEFORE "gmake install":
type 'rpm -q -a|grep bison'
you´ll get the installed bison package,
type 'rpm -e '
to remove it
You need the readline-devel-package, because you need the headers for readline.
If you ever get such an error like the one with readline
On Sat, 2004-10-02 at 15:42, Stephan Szabo wrote:
> On Sat, 2 Oct 2004, Scott Marlowe wrote:
> > So would a union give good performance? Just union the first 25 or less
> > with status=5 with the rest, using a 1 and 0 in each union to order by
> > first? Hopefully the indexes would then be used.
Michael Long <[EMAIL PROTECTED]> writes:
> I should have also included that when I do a "locate readline" I get the
> following list.
> ...
> /lib/libreadline.so.4.3
Well, you've evidently got the library, but I don't see
/usr/include/readline/readline.h, which makes me think you didn't
install t
John McBride wrote:
stig erikson wrote:
John McBride wrote:
As user postgres I try and run the tests:
$ pwd
/usr/lib/pgsql/test/regress
$ time ./pg_regress.sh --schedule=parallel_schedule
I've no idea what the others should be set to. I think the tests
directory is setup for people who install fro
Igor Maciel Macaubas wrote:
> Hi Guys,
>
> I have a PostgreSQL server, running 7.4.2, that will store a really large
> amount of data (200GB) being migrated from an Oracle database. I have a
> machine with two 120GB Ultra ATA IDE disks, and I'd like to know if
> PostgreSQL could split it over bot
On Sat, 2 Oct 2004, Scott Marlowe wrote:
> On Sat, 2004-10-02 at 09:14, Stephan Szabo wrote:
> > On Fri, 1 Oct 2004, Scott Marlowe wrote:
> >
> > > On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
> > > > Okay, just so no one posts about this again...
> > > >
> > > > the 'ORDER BY t.status=5
On Sat, 2004-10-02 at 09:14, Stephan Szabo wrote:
> On Fri, 1 Oct 2004, Scott Marlowe wrote:
>
> > On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
> > > Okay, just so no one posts about this again...
> > >
> > > the 'ORDER BY t.status=5,lastreply' clause is meant to float the threads
> > >
stig erikson wrote:
John McBride wrote:
As user postgres I try and run the tests:
$ pwd
/usr/lib/pgsql/test/regress
$ time ./pg_regress.sh --schedule=parallel_schedule
Okay, some of these problems are my fault. The README file in the test
directory clearly states to run the tests via "gmake check"
Hi,
I have downloaded the latest tar ball and am attempting to install this
on SuSE 9.1. When I run configure I get several error messages and don't
know how to resolve them. The configure command and output are below.
Any help is appreciated.
./configure --prefix=/usr/local/pgsql_8.0b3 --disab
Hi again,
I should have also included that when I do a "locate readline" I get the
following list.
/home/mlong/Python-2.3.3/build/lib.linux-i686-2.3/xreadlines.so
/home/mlong/Python-2.3.3/build/temp.linux-i686-2.3/xreadlinesmodule.o
/home/mlong/Python-2.3.3/Doc/lib/libreadline.tex
/home/mlong/Pyt
On Fri, 1 Oct 2004, Scott Marlowe wrote:
> On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
> > Okay, just so no one posts about this again...
> >
> > the 'ORDER BY t.status=5,lastreply' clause is meant to float the threads
> > with a status of '5' to the top of the list... it is NOT meant
stig erikson wrote:
John McBride wrote:
As user postgres I try and run the tests:
$ pwd
/usr/lib/pgsql/test/regress
$ time ./pg_regress.sh --schedule=parallel_schedule
6 of 93 tests failed, 1 of these failures ignored.
=
20 matches
Mail list logo
