[GENERAL] Undocumented feature? USING INDEX TABLESPACE

2013-10-30 Thread Tim Kane
Hi all, I¹ve been looking for a facility to specify the tablespace of an index that is implicitly created when adding a PK constraint. It turns out that this does indeed exist, though I could find no mention of it in the documentation. ALTER TABLE {table} ADD CONSTRAINT {constraint} PRIMARY KEY

Re: [GENERAL] Undocumented feature? USING INDEX TABLESPACE

2013-10-30 Thread Elliot
On 2013-10-30 06:32, Tim Kane wrote: Hi all, I've been looking for a facility to specify the tablespace of an index that is implicitly created when adding a PK constraint. It turns out that this does indeed exist, though I could find no mention of it in the documentation. ALTER TABLE

Re: [GENERAL] Undocumented feature? USING INDEX TABLESPACE

2013-10-30 Thread Tim Kane
This is indicated in the CREATE TABLE documentation (to which much of the ALTER TABLE documentation defers). So it isŠ My bad, apologies for the noise.

[GENERAL] Connection pooling

2013-10-30 Thread si24
I have geoserver connected to a postgres database and so far I have been reading that I would need some sort of connection pooling but how do I go about doing that when it seems most of the connection pooling aplications/programs seem to only run on linux. I have a windows machine. otherwise is

Re: [GENERAL] Connection pooling

2013-10-30 Thread si24
I'm not sure if its suppose to be under general so please let me know if I need to move it to another topic area please. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776382.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] Connection pooling

2013-10-30 Thread Rémi Cura
Are the geoserver and postgres on same computer? Cheers, Rémi-C 2013/10/30 si24 smrcoutt...@gmail.com I'm not sure if its suppose to be under general so please let me know if I need to move it to another topic area please. -- View this message in context:

Re: [GENERAL] Connection pooling

2013-10-30 Thread si24
yes they are as well as the tomcat which is where geoserver is running from. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776386.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general

Re: [GENERAL] Connection pooling

2013-10-30 Thread Igor Neyman
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of si24 Sent: Wednesday, October 30, 2013 10:14 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Connection pooling I have geoserver connected to a postgres

Re: [GENERAL] Connection pooling

2013-10-30 Thread Adrian Klaver
On 10/30/2013 07:13 AM, si24 wrote: I have geoserver connected to a postgres database and so far I have been reading that I would need some sort of connection pooling but how do I go about doing that when it seems most of the connection pooling aplications/programs seem to only run on linux. I

[GENERAL] Extension plr not listed in pgadmin3

2013-10-30 Thread BOUVARD Aurélien
Hi all, I've installed the PL/R extension with the « CREATE EXTENSION » in psql (PostgreSQL 9.3) , my extension is correctly installed but i see that's extension does not appear in pgadmin3 (i only see previous installed extension such as plpgsql , hstore...) It's not really important , but

[GENERAL] LDAP support for 9.3 rpm

2013-10-30 Thread Michael Ma
Hello, Can anyone confirm that http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpmwas compiled with LDAP support (option --with-ldap for configure)? Thanks, Mike

Re: [GENERAL] Connection pooling

2013-10-30 Thread Gavin Flower
On 31/10/13 03:13, si24 wrote: I have geoserver connected to a postgres database and so far I have been reading that I would need some sort of connection pooling but how do I go about doing that when it seems most of the connection pooling aplications/programs seem to only run on linux. I have a

[GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-10-30 Thread Brian Crowell
Hello again! I've been setting up my PostgreSQL server by doing something I've never done before: I've joined a Linux server to a domain so I can use integrated Kerberos authentication from server to server. I've managed to make this work from Linux machine to Linux machine. On the client, I

Re: [GENERAL] GSSAPI server side on Linux, SSPI client side on Windows

2013-10-30 Thread Brian Crowell
I've thought of one option, which I'm investigating: implementing GSSAPI support in Npgsql. Microsoft claims this is possible using the SSPI API: http://msdn.microsoft.com/en-us/library/windows/desktop/aa380496(v=vs.85).aspx —Brian On Wed, Oct 30, 2013 at 3:16 PM, Brian Crowell br...@fluggo.com