Re: [HACKERS] [GENERAL] Insert result does not match record count

2014-02-02 Thread Vik Fearing
On 02/01/2014 02:26 AM, Bruce Momjian wrote: > On Sat, Feb 1, 2014 at 02:25:16AM +0100, Vik Fearing wrote: >>> OK, thanks for the feedback. I understand now. The contents of the >>> string will potentially have a larger integer, but the byte length of >>> the string in the wire protocol doesn't

Re: [GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Edson Richter
Em 02/02/2014 04:24, John R Pierce escreveu: On 2/1/2014 4:26 PM, Adrian Klaver wrote: On 02/01/2014 03:26 PM, John R Pierce wrote: On 2/1/2014 3:18 PM, Edson Richter wrote: It is possible to put a PostgreSQL database in substitution of a Oracle database for an app running BDE? Any tips (beyon

Re: [HACKERS] [GENERAL] Insert result does not match record count

2014-02-02 Thread Tom Lane
Vik Fearing writes: > Without re-doing the work, my IRC logs show that I was bothered by this > in src/backend/tcop/postgres.c: > max_rows = pq_getmsgint(&input_message, 4); > I needed to change max_rows to int64 which meant I had to change > pq_getmsgint to pq_getmsgint64 wh

Re: [GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Gavin Flower
On 03/02/14 01:18, Edson Richter wrote: Em 02/02/2014 04:24, John R Pierce escreveu: On 2/1/2014 4:26 PM, Adrian Klaver wrote: On 02/01/2014 03:26 PM, John R Pierce wrote: On 2/1/2014 3:18 PM, Edson Richter wrote: It is possible to put a PostgreSQL database in substitution of a Oracle databas

Re: [GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Erik Darling
unsubscribe On Sun, Feb 2, 2014 at 11:28 AM, Gavin Flower wrote: > On 03/02/14 01:18, Edson Richter wrote: > >> Em 02/02/2014 04:24, John R Pierce escreveu: >> >>> On 2/1/2014 4:26 PM, Adrian Klaver wrote: >>> On 02/01/2014 03:26 PM, John R Pierce wrote: > On 2/1/2014 3:18 PM, Eds

Re: [GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Alfonso Afonso
Hi everybody I have not follow all the advices and answer you probably has received, so my apologises if I repeat something ;) I have been working with Delphi/BDE over 14 years and some projects had to be moved from one database system to another thanks to ODBC layer BUT you have to consider t

[GENERAL] HOT Standby & SSL

2014-02-02 Thread CS DBA
All; How do I force a standby to connect to the master via ssl only? Thanks in advance -- 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] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Adrian Klaver
On 02/02/2014 04:18 AM, Edson Richter wrote: Em 02/02/2014 04:24, John R Pierce escreveu: On 2/1/2014 4:26 PM, Adrian Klaver wrote: On 02/01/2014 03:26 PM, John R Pierce wrote: On 2/1/2014 3:18 PM, Edson Richter wrote: It is possible to put a PostgreSQL database in substitution of a Oracle da

Re: [GENERAL] HOT Standby & SSL

2014-02-02 Thread Adrian Klaver
On 02/02/2014 09:14 AM, CS DBA wrote: All; How do I force a standby to connect to the master via ssl only? Use hostssl in the pg_hba.conf file: http://www.postgresql.org/docs/9.3/interactive/auth-pg-hba-conf.html hostssl This record matches connection attempts made using TCP/IP, but onl

[GENERAL] In a moment of madness I destroyed...

2014-02-02 Thread Jerry Levan
Today I updated my fedora machine from f19 to f20 without taking a data dump. When ‘fedup’ finished my 9.2.x binaries were updated to 9.3.x and postgresql can no longer start… I have all of the tables on another machine ( a mac running 9.1.x postgresql) so no important data was lost. ( My db c

Re: [GENERAL] In a moment of madness I destroyed...

2014-02-02 Thread Adrian Klaver
On 02/02/2014 04:33 PM, Jerry Levan wrote: Today I updated my fedora machine from f19 to f20 without taking a data dump. When ‘fedup’ finished my 9.2.x binaries were updated to 9.3.x and postgresql can no longer start… I have all of the tables on another machine ( a mac running 9.1.x postgresq

Re: [GENERAL] In a moment of madness I destroyed...

2014-02-02 Thread Tom Lane
Jerry Levan writes: > Today I updated my fedora machine from f19 to f20 without taking a > data dump. > When ‘fedup’ finished my 9.2.x binaries were updated to 9.3.x and > postgresql can no longer start… Install postgresql-upgrade and do "service postgresql upgrade". More or less ... that's fro