Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 10:49 PM, John R Pierce wrote: > its looking for the RPM installed packages it was linked against. its not > looking to see if any same named files just happen to be on your system. Oh, got it. So the only way is to do bless it thru 'yum install unixODBC-libs' only. Hmm

Re: [GENERAL] [PERFORM] Very slow inner join query Unacceptable latency.

On Wednesday, May 22, 2013 3:24 AM fburgess wrote: > The SARS_ACTS table currently has 37,115,515 rows > we have indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree > (sars_run_id) > we have pk constraint on the SARS_ACTS_RUN table; sars_acts_run_pkey PRIMARY > KEY (id ) > serverdb=# e

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 10:37 PM, Dev Kumkar wrote: BTW where does the 'postgresql91-odbc.x86_64' looking for libodbc.so.1 and libodbcinst.so.1 files. its looking for the RPM installed packages it was linked against. its not looking to see if any same named files just happen to be on your system. --

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 8:40 PM, Dann Corbit wrote: >>> > > I guess that if you did a successful make install of unixODBC-2.3.0 it > will work as your ODBC driver manager. > > On the other hand, it is easier and more trouble free to use the > standardized package installer for your distributi

Re: [GENERAL] Table Partitioning

On Tuesday, May 21, 2013, Richard Onorato wrote: > I am wanting to partition my data based on a mod of one of the bigint > columns, but when I run my insert test all the data goes into the base > table and not the partitions. Here is what the table looks like: > This works for me, on 9.2.4. Ca

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 8:33 PM, Dev Kumkar wrote: I can do 'yum update' and its started to update 1st package. Although I exit, just want to confirm there is no unixODBC-libs package so it will not update it. Is that correct? I have no idea what you're saying here. what 1st package? you should app

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:40 PM, John R Pierce wrote: > # yum install unixODBC-libs > > should install the latest version from the distribution base repositories. Its not finding it. May be I need to get on another box then, not sure. Since ODBC driver was missing, downloaded unixODBC-2.3.0.t

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 7:33 PM, Dev Kumkar wrote: Red Hat Enterprise Linux Server release 5.5. 5.5 is a fairly old release of Red Hat Enteprise Linux Server release 5, they are up to 5.9 now. simply running `yum update` should get you the latest incremental files now, if you're running RHEL withou

Re: [ODBC] [GENERAL] ODBC constructs

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Dev Kumkar Sent: Tuesday, May 21, 2013 7:27 PM To: John R Pierce Cc: pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] Suggestions? >> http

Re: [GENERAL] Authorization,Authentication issues trying basic commands.

On 22/05/13 14:15, luis redondo wrote: It's my first time using PostgreSQL and I need to do basic things as establishing a new user,create a new database,access psql command line client etc. I tried : su - postgres to access the server but I don't have a valid password,I don't know if the ser

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:35 PM, John R Pierce wrote: > On 5/21/2013 7:02 PM, Dev Kumkar wrote: > > The link > http://www.enterprisedb.com/products-services-training/pgdownload#windows > which > you had earlier provided was postgres installation. It installed libpq but > odbc library was not in

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 7:27 PM, Dev Kumkar wrote: Ya it should have been with base registry. Where to get unixODBC-libs-2.2.11-10.el5.i386? # yum install unixODBC-libs should install the latest version from the distribution base repositories. Since ODBC driver was missing, downloaded unixODBC-2.3

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 7:02 PM, Dev Kumkar wrote: The link http://www.enterprisedb.com/products-services-training/pgdownload#windows which you had earlier provided was postgres installation. It installed libpq but odbc library was not installed. I hope am looking at correct things. after installing p

Re: [ODBC] [GENERAL] ODBC constructs

> > Currently looking for RHEL 5. Thanks! yes looked into my machine and "yum > list postgres*" listed "postgresql91-odbc.x86_64" > But when trying to install, then found the base ODBC library itself are > missing and those needs to be configured first on test machine. > > Error: Missing Dependenc

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:13 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs On Tue, May 21, 2013 at 7:09 PM, Dann Corbit mailto:dcor...@connx.com>> wr

[GENERAL] Authorization,Authentication issues trying basic commands.

It's my first time using PostgreSQL and I need to do basic things as establishing a new user,create a new database,access psql command line client etc. I tried : su - postgres to access the server but I don't have a valid password,I don't know if the server is requesting the postgres system acc

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 7:09 PM, Dann Corbit wrote: > The ODBC library is contained in either the iodbc or unixodbc RPMs. > > The correct RPM to use will depend on your operating system. > Where are these located?

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 7:03 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] The link http://www.enterprisedb.com/products-services-training/pgdo

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 5:21 PM, Dann Corbit wrote: > When you install an ODBC driver, it does not install a library. It > installs a DLL or shared object. > > If you have already installed the driver, then set up your data source > with a data source manager. > > ** ** > > IODBC is a popul

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 3:49 PM, Dev Kumkar wrote: On Tue, May 21, 2013 at 3:17 PM, John R Pierce > wrote: what specific non-Windows operating system distribution are you using? ODBC stuff is packaged for most of them. for instance, the yum.postgresql.org

Re: [GENERAL] Table Partitioning

Were you able to get it to insert with the bigserial being used on the table?   Every time I go to do an insert into one of the inherited tables I am now getting the following exception: org.hibernate.HibernateException: The database returned no natively generated identity value Is auto-increm

Re: [ODBC] [GENERAL] ODBC constructs

From: Dev Kumkar [mailto:devdas.kum...@gmail.com] Sent: Tuesday, May 21, 2013 1:59 PM To: Dann Corbit Cc: John R Pierce; pgsql-general@postgresql.org; pgsql-o...@postgresql.org Subject: Re: [ODBC] [GENERAL] ODBC constructs [snip] I already have installed this on Linux from above link some days bac

Re: [GENERAL] Strange locking problem

On Tue, May 21, 2013 at 12:24 PM, Moshe Jacobson wrote: > I wanted to see what was happening in that transaction ID that might be > causing this lock to be held, but I was unsure how. I know I can look in > pg_locks for the other transaction, but that will not tell me what statement > is executing

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 3:17 PM, John R Pierce wrote: > what specific non-Windows operating system distribution are you using? > ODBC stuff is packaged for most of them. for instance, the > yum.postgresql.org repository has it packaged as postgresql92-odbc, > available for a variety of redhat/f

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 1:59 PM, Dev Kumkar wrote: I already have installed this on Linux from above link some days back but not able to find library. Can you point me to the same? Also this link says to compile if its non-windows - http://psqlodbc.projects.pgfoundry.org/faq.html#1.2 Check 1.3 Can you

Re: [GENERAL] [PERFORM] Very slow inner join query Unacceptable latency.

On Tue, May 21, 2013 at 4:53 PM, wrote: > The SARS_ACTS table currently has 37,115,515 rows > > we have indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree > (sars_run_id) > we have pk constraint on the SARS_ACTS_RUN table; sars_acts_run_pkey PRIMARY > KEY (id ) > > serverdb=# explain sel

[GENERAL] Very slow inner join query Unacceptable latency.

The SARS_ACTS table currently has 37,115,515 rowswe have indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree (sars_run_id)we have pk constraint on the SARS_ACTS_RUN table; sars_acts_run_pkey PRIMARY KEY (id )serverdb=# explain select count(*) as y0_ from SARS_ACTS this_ inner join SARS_ACTS

Re: [GENERAL] pg_upgrade link mode

On Thu, May 16, 2013 at 02:21:16PM -0400, AI Rumman wrote: > I told you I would never go for a production with link mode. However, I was > working with pg_upgrade copy mode and in the middle I got an error saying > missing some extensions. I rollback and start the operation after setting > everythi

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:45 PM, Dann Corbit wrote: > >> > > Just install the driver and use it. You don’t have to build the driver. > It is already built for you. Look here if you need Solaris or BSD: > > http://www.postgresql.org/download/ > > Or go directly here for Mac, Windows

Re: [GENERAL] replanning Prepared Statements ?

On Mon, May 13, 2013 at 02:39:17PM -0400, Tom Lane wrote: > "Sahagian, David" writes: > > I see in the Release Notes for 9.3 beta . . . > > "Force cached functions to be replanned if the search_path changes (Tom > > Lane) > > Previously functions already run in the current session ignored >

[GENERAL] SR Slave leaves off every 32nd wal segment ?!

Hi, We have following situation: Pg master on US east coast. Pg slave on US west coast. Replication set using omnipitr + streaming replication. Setup on slave: postgres=# select name, setting from pg_settings where name ~ '(checkpo|wal)'; name | setting ---

Re: [ODBC] [GENERAL] ODBC constructs

[snip] Yeah, hope you got my confusion and inclination now. Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? http://www.postgresql.org/ftp/odbc/versions/src/ has sources for windows or am I missing something here? Regards... >

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:35 PM, Guy Rouillier wrote: > On 5/21/2013 3:32 PM, Dev Kumkar wrote: > >> Well to work with psqlODBC, will I need to recompile the psqlODBC binary >> and any additional stuff to get ODBC working? >> > > No, you don't need to recompile any libraries. You just use them.

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:32 PM, Dev Kumkar wrote: > On Tue, May 21, 2013 at 12:16 PM, John R Pierce wrote: > > for pooling, check out pgbouncer. IMHO its a better basic pooler than >> pg_pool. >> > > Sure, looks like its more light weight. And I hope, its not related to the > decision between

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 3:32 PM, Dev Kumkar wrote: Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? No, you don't need to recompile any libraries. You just use them. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-gen

Re: [ODBC] [GENERAL] ODBC constructs

On Tue, May 21, 2013 at 12:16 PM, John R Pierce wrote: for pooling, check out pgbouncer. IMHO its a better basic pooler than > pg_pool. > Sure, looks like its more light weight. And I hope, its not related to the decision between libpq and psqlODBC. And will work with both? thats the perfect

Re: [GENERAL] Strange locking problem

On Tue, May 21, 2013 at 2:39 PM, Moshe Jacobson wrote: > What could be causing this ROW SHARE lock to be in place for some cloning > operations and not others? Perhaps there is a way to see which specific > statement is causing the lock to occur, but I'm not sure how to look this > up. Any help w

Re: [ODBC] [GENERAL] ODBC constructs

On 5/21/2013 11:58 AM, Dev Kumkar wrote: Thanks everyone for sharing comments, really useful ones. Yes the requirement is not connecting to other DBMS but only Postgres and libpq is the correct way so far from comments here. Regarding libpq performance wanted to discuss about connection polling

Re: [ODBC] [GENERAL] ODBC constructs

On Mon, May 20, 2013 at 11:32 PM, Heikki Linnakangas < hlinnakan...@vmware.com> wrote: > libpq is generally-speaking better than psqlodbc. The advantage of ODBC is > that if you have a suitable driver, you can connect to other DBMS' as well, > while libpq will only work with PostgreSQL. Unless you

Re: [GENERAL] pg_upgrade -u

On Wed, May 8, 2013 at 08:52:40PM -0400, Bruce Momjian wrote: > On Wed, May 8, 2013 at 05:05:05PM -0400, Ray Stell wrote: > > A minor detail in 9.2.4, but I noticed that the pg_upgrade flag for > > superuser, -u, does not get carried to a -U flag on the vacuumdb commands > > written to analyze_ne

[GENERAL] Strange locking problem

We have a long-running stored proc that duplicates a particular row in table called tb_location_map and also duplicates all related rows in several other tables. The new records created contain foreign keys to our user data table, tb_entity. However there is no other reference to tb_entity in the

Re: [GENERAL] Table Partitioning

Interesting. I wonder what I am doing wrong. I will try and setup the database again and see if I can get it to work. thank you for testing it out for me. Richard On May 21, 2013, at 1:06 PM, Raghavendra wrote: > On Tue, May 21, 2013 at 11:03 PM, Richard Onorato > wrote: > I am wanting

Re: [GENERAL] Table Partitioning

On Tue, May 21, 2013 at 11:03 PM, Richard Onorato wrote: > I am wanting to partition my data based on a mod of one of the bigint > columns, but when I run my insert test all the data goes into the base > table and not the partitions. Here is what the table looks like: > > CREATE table MyMappingT

[GENERAL] Table Partitioning

I am wanting to partition my data based on a mod of one of the bigint columns, but when I run my insert test all the data goes into the base table and not the partitions.  Here is what the table looks like: CREATE table MyMappingTable ( id bigserial NOT NULL,                                    

Re: [GENERAL] WAL contains references to invalid pages

Try to take backups of that table & index only. If succeeded drop and recreate them. May be it fix your issue. Thanks On Thu, May 16, 2013 at 11:14 PM, JotaComm wrote: > Hello, Fabrízio > > > 2013/5/16 Fabrízio de Royes Mello > >> >> On Thu, May 16, 2013 at 11:12 AM, JotaComm wrote: >> >>> >

Re: [GENERAL] Cross compile custom data types for Linux and windows

OK, thank you. Then I believe I have to go with a Wine-VisualC setup for that. Thanks, Daniel Migowski -Ursprüngliche Nachricht- Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von John R Pierce Gesendet: Dienstag, 21. Mai 2013 08:10 An: pg