Re: [GENERAL] can postgres run well on NFS mounted partitions?

On 11/11/2015 12:37 AM, Albe Laurenz wrote: It would be good to know of other pitfalls; I (and no doubt not only I) keep getting asked why we shouldn't run PostgreSQL on NFS when Oracle has no problem with it (and don't tell me that Oracle does not care about data corruption). Last I looked,

Re: [GENERAL] can postgres run well on NFS mounted partitions?

Scott Mead wrote: > Don't do it. Period. I've used 4 big-vendor appliances with NFS as well as > my own server. With > maybe 3 exceptions, most of the 'total-data-loss' scenarios I've dealt with > regarding transactional > data was due to NFS. Can you share more details? What happened and

Re: [GENERAL] attempting to install tds_fw-master on redhat

Mammarelli, Joanne T wrote: > The following postgresql rpm is installed .. > > rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64 > > on redhat 7 > [root@scsblnx-994457 tds_fdw-master]# make USE_PXGS=1 install > > Makefile:53: /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk: No such file or >

[GENERAL] recursive table performance (CTE)

Hi, I'm using table with parent_id to themselve and WITH RECURSIVE in SELECT on about 3thousands records. The "tree" of data is wide (each node has more children) but not deep (maximal depth of branch is 10 nodes). I'm planning to use same schema on much deeper but narrower tree (most of nodes

Re: [GENERAL] can postgres run well on NFS mounted partitions?

John R Pierce wrote: > On 11/11/2015 12:37 AM, Albe Laurenz wrote: > > It would be good to know of other pitfalls; I (and no doubt not only I) > > keep getting asked why we shouldn't run PostgreSQL on NFS when Oracle > > has no problem with it (and don't tell me that Oracle does not care > > about

Re: [GENERAL] Best tool to pull from mssql

SSIS can be used to migrate data from MSSQL to Postgres and back. It is native for MS SQL You can use PG ODBC driver http://www.postgresql.org/ftp/odbc/versions/msi/ or Devart ODBC driver https://www.devart.com/odbc/postgresql/ On Wed, Nov 11, 2015 at 9:27 AM, Scott Mead

Re: [GENERAL] Best tool to pull from mssql

On Wed, Nov 11, 2015 at 9:37 AM, taspotts wrote: > Take a look at Pentaho Kettle > . They have a > free community edition. > > +10 > I use it frequently to migrate data from MSSQL to Postgres. It has a nice > GUI

Re: [GENERAL] attempting to install tds_fw-master on redhat

On 11/11/2015 04:53 AM, Mammarelli, Joanne T wrote: Installed postgresql-devel .. getting closer .. Installed Packages postgresql.x86_64 9.2.13-1.el7_1 @rhel7-x86_64-2015-07 postgresql-devel.x86_64 9.2.13-1.el7_1 @rhel-x86_64-server-7

Re: [GENERAL] attempting to install tds_fw-master on redhat

On 11/11/2015 05:06 AM, Albe Laurenz wrote: Mammarelli, Joanne T wrote: Installed postgresql-devel .. getting closer .. Installed Packages postgresql.x86_64 9.2.13-1.el7_1 @rhel7-x86_64-2015-07 postgresql-devel.x86_64 9.2.13-1.el7_1

Re: [GENERAL] attempting to install tds_fw-master on redhat

Mammarelli, Joanne T wrote: > Installed postgresql-devel .. getting closer .. > > Installed Packages > postgresql.x86_64 9.2.13-1.el7_1 > @rhel7-x86_64-2015-07 > postgresql-devel.x86_64 9.2.13-1.el7_1 > @rhel-x86_64-server-7 > postgresql-libs.x86_64

Re: [GENERAL] attempting to install tds_fw-master on redhat

Installed postgresql-devel .. getting closer .. Installed Packages postgresql.x86_64 9.2.13-1.el7_1 @rhel7-x86_64-2015-07 postgresql-devel.x86_64 9.2.13-1.el7_1 @rhel-x86_64-server-7 postgresql-libs.x86_649.2.13-1.el7_1

Re: [GENERAL] Best tool to pull from mssql

Take a look at Pentaho Kettle . They have a free community edition. I use it frequently to migrate data from MSSQL to Postgres. It has a nice GUI for setting everything up and the transforms/jobs can be scheduled. -- View this

Re: [GENERAL] attempting to install tds_fw-master on redhat

On 11/11/2015 05:06 AM, Albe Laurenz wrote: Mammarelli, Joanne T wrote: Installed postgresql-devel .. getting closer .. Installed Packages postgresql.x86_64 9.2.13-1.el7_1 @rhel7-x86_64-2015-07 postgresql-devel.x86_64 9.2.13-1.el7_1

Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

On 11/11/2015 11:40 AM, Mammarelli, Joanne T wrote: Correct .. this is the windows one. If I reload the software, I'm good until the next day. I should have been clearer. The error you are seeing is Postgres being denied access to its files by the OS. That is not something that can be

[GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

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

Re: [GENERAL] attempting to install tds_fw-master on redhat

On 11/11/2015 10:55 AM, Geoff Montee wrote: Hi Joanne, On Wed, Nov 11, 2015 at 4:53 AM, Mammarelli, Joanne T wrote: Installed postgresql-devel .. getting closer .. Installed Packages postgresql.x86_64 9.2.13-1.el7_1

Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

On 11/11/2015 11:40 AM, Mammarelli, Joanne T wrote: Correct .. this is the windows one. If I reload the software, I'm good until the next day. Reload what software, Postgres or the GPO? In either case you need to have a discussion with the creators of the GPO. -Original

Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

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:

Re: [GENERAL] attempting to install tds_fw-master on redhat

Hi Joanne, On Wed, Nov 11, 2015 at 4:53 AM, Mammarelli, Joanne T wrote: > Installed postgresql-devel .. getting closer .. > > Installed Packages > postgresql.x86_64 9.2.13-1.el7_1 > @rhel7-x86_64-2015-07 > postgresql-devel.x86_64

Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission denied

On 11/11/2015 11:32 AM, Mammarelli, Joanne T wrote: Postgresql 9.3 Windows 2008 R2 When I install the software, I can access the databases via pgadmin with no problems. So to be clear the Postgres server is installed on Windows? Not talking about the one you installed on RedHat? However,

Re: [GENERAL] recursive table performance (CTE)

2015-11-11 10:44 GMT+01:00 Dusan : > Hi, > I'm using table with parent_id to themselve and WITH RECURSIVE in SELECT on > about 3thousands records. > The "tree" of data is wide (each node has more children) but not deep > (maximal depth of branch is 10 nodes). > > I'm planning to