Correct .. this is the windows one.
If I reload the software, I'm good until the next day.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, November 11, 2015 2:40 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GE
Postgresql 9.3
Windows 2008 R2
When I install the software, I can access the databases via pgadmin with no
problems.
However, after a windows GPO push, I receive the fatal error.
error connecting to the server: fatal :could not open file "base/12029/11801"
permission denied
Any suggestions?
ated.
make: *** [src/tds_fdw.o] Error 1
[root@scsblnx-994457 tds_fdw-master]#
Any ideas?
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Wednesday, November 11, 2015 3:53 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: RE: attempting to inst
The following postgresql rpm is installed ..
rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64
on redhat 7
Red Hat Enterprise Linux Server release 7.1 (Maipo)
Currently following the instructions at the following link in attempt to create
the extension:
https://github.com/GeoffMontee/tds_fdw/
Are there any type of 'pgadmin' like interfaces for the linux side?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, November 10, 2015 2:12 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best tool to
Sent: Tuesday, November 10, 2015 1:49 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best tool to pull from mssql
On 11/10/2015 10:26 AM, Mammarelli, Joanne T wrote:
> Continuously syncing .. we have database in mssql. Ideally we'd like to
> conn
esday, November 10, 2015 1:26 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best tool to pull from mssql
On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote:
> Hi .. we're on a hunt to locate either pgloader or the tds_fdw
> extension to assist us with pul
Hi .. we're on a hunt to locate either pgloader or the tds_fdw extension to
assist us with pulling data FROM a Microsoft sql server (we're a windows-based
postgres installation).
Is this the proper way to handle the process?
m Nasby
Cc: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
I would also like to add that I am very suspicious of a table with 80 columns.
Offhand, it sounds like poor database design where someone was trying to put
all the eggs in
connector) it
takes 3 minutes for the data to come back.
-Original Message-
From: Jim Nasby [mailto:jim.na...@bluetreble.com]
Sent: Tuesday, November 10, 2015 11:08 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
O
Hi - same rookie user as before.
We have one table
100,000 rows
80 columns
When we try to retrieve the data (select * from table) using pgadmin, we get a
193456 ms retrieve time.
When I ran a query analyze in the command prompt, we get a 316ms retrieve time.
.. and finally. When we retrieve
Are there any options for linking a Microsoft sql database to a postgresql
database?
(I want the postgresql database to be the "puller")
-Original Message-
From: Jim Nasby [mailto:jim.na...@bluetreble.com]
Sent: Tuesday, November 10, 2015 10:21 AM
To: Mammarelli, Joann
Hi - rookie user here.
I'd like to access data on my Microsoft sql database from my postgres database.
I stumbled upon the tds_fdw extension and it reads as if it it's *nix only.
Would acquiring tds_fdw.control from one of the repos possibly work on a
windows-based postgres installed database?
13 matches
Mail list logo
