[Pgpool-general] pgpool newbie questions

[Joe Conway]

Hello all,

I'm a pgpool newbie with a question or two.

I'm trying to test pgpool for an existing application. What I did was to
dump the existing database from one Postgres cluster, and load it into
another Postgres cluster running on a different port of the same
machine. One of the Postgres clusters was installed from RPM. The other
was compiled from source. Both run perfectly on their own.

backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/var/lib/pgsql/data'
backend_hostname1 = 'localhost'
backend_port1 = 55439
backend_weight1 = 1
backend_data_directory1 = '/usr/local/pgsql-8.3/data'

I defined one partitioned table and two replicated tables in the pgpool.
There are many other tables.

At that point I tried to use psql to run a query on the partitioned
table. I never get that far. Instead I get this:

psql -p 9999 mydatabase
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

However, if I modify the backend definition so that both databases point
to the same postgres cluster, the psql login succeeds.

What am I doing wrong?

Thanks,

Joe


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 897 bytes
Desc: OpenPGP digital signature
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090811/a36ebe3d/attachment.bin>