[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 ®/ 
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  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