[GENERAL] Tcl PG on Win 7 64 bit - is it working for anyone?

2013-02-09 Thread Carlo Stonebanks
I have been trying to get the Tcl package for client applications PgTcl to
work for some time now. I have tried the SourceForge pgtclng 2.0 project, I
have recompiled it with MinGW-64, I have installed PG 9.1.8 64 bit and made
sure  PATH points to its lib folder so it can find libpq.dll. NO matter what
I try, the Tcl command 'load libpgtcl' returns: 'couldn't load library
libpgtcl: invalid argument'

 

The Pure Tcl interface pgintcl package works on Win 7 64, but is very slow
to load so I imagine slow to run as well.

 

If anyone is running Tcl client apps to access PostgreSQL on Win 7 64 using
I would love to hear about it.

 

Thanks,

 

Carlo



Re: [GENERAL] Tcl PG on Win 7 64 bit - is it working for anyone?

2013-02-09 Thread Adrian Klaver

On 02/09/2013 09:52 AM, Carlo Stonebanks wrote:

I have been trying to get the Tcl package for client applications PgTcl
to work for some time now. I have tried the SourceForge pgtclng 2.0
project, I have recompiled it with MinGW-64, I have installed PG 9.1.8
64 bit and made sure  PATH points to its lib folder so it can find
libpq.dll. NO matter what I try, the Tcl command ‘load libpgtcl’
returns: ‘couldn't load library libpgtcl: invalid argument’


It would seem you need to point the PATH at libpgtcl(.dll) also.



The “Pure Tcl interface” pgintcl package works on Win 7 64, but is very
slow to load so I imagine slow to run as well.

If anyone is running Tcl client apps to access PostgreSQL on Win 7 64
using I would love to hear about it.

Thanks,

Carlo




--
Adrian Klaver
adrian.kla...@gmail.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] Running multiple instances off one set of binaries

2013-02-09 Thread Karl Denninger
Let's assume I want to run:

1. An instance of the database that is a replicated copy from another site.

2. A LOCAL instance that contains various things on the local machine
that are not shared.

Let's further assume all are to be 9.2 revs.

Am I correct in that I can do this by simply initdb-ing the second
instance with a different data directory structure, and when starting it
do so with a different data directory structure?

e.g. initdb -D data

and

initdb -D data2

And that as long as there are no collisions (E.g. port numbers) this
works fine?

-- 
-- Karl Denninger
/The Market Ticker ®/ http://market-ticker.org
Cuda Systems LLC


Re: [GENERAL] Running multiple instances off one set of binaries

2013-02-09 Thread Sergey Konoplev
On Sat, Feb 9, 2013 at 7:39 PM, Karl Denninger k...@denninger.net wrote:
 Am I correct in that I can do this by simply initdb-ing the second instance
 with a different data directory structure, and when starting it do so with a
 different data directory structure?

You are correct.

 And that as long as there are no collisions (E.g. port numbers) this works
 fine?

Sure.

-- 
Sergey Konoplev
Database and software architect
http://www.linkedin.com/in/grayhemp

Phones:
USA +1 415 867 9984
Russia, Moscow +7 901 903 0499
Russia, Krasnodar +7 988 888 1979

Skype: gray-hemp
Jabber: gray...@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] Tcl PG on Win 7 64 bit - is it working for anyone?

2013-02-09 Thread Carlo Stonebanks
I am actually in the same folder as the libpgtcl.dll, and that particular
failure would raise a different error in any case:

'couldn't load library libpgtc: this library or a dependent library could
not be found in library path'


-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com] 
Sent: February 9, 2013 1:01 PM
To: Carlo Stonebanks
Cc: 'Postgres General'
Subject: Re: [GENERAL] Tcl  PG on Win 7 64 bit - is it working for anyone?

On 02/09/2013 09:52 AM, Carlo Stonebanks wrote:
 I have been trying to get the Tcl package for client applications 
 PgTcl to work for some time now. I have tried the SourceForge pgtclng 
 2.0 project, I have recompiled it with MinGW-64, I have installed PG 
 9.1.8
 64 bit and made sure  PATH points to its lib folder so it can find 
 libpq.dll. NO matter what I try, the Tcl command 'load libpgtcl'
 returns: 'couldn't load library libpgtcl: invalid argument'

It would seem you need to point the PATH at libpgtcl(.dll) also.


 The Pure Tcl interface pgintcl package works on Win 7 64, but is 
 very slow to load so I imagine slow to run as well.

 If anyone is running Tcl client apps to access PostgreSQL on Win 7 64 
 using I would love to hear about it.

 Thanks,

 Carlo



--
Adrian Klaver
adrian.kla...@gmail.com



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general