Re: [GENERAL] Request to share information regarding errors

Hello Yogesh > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yogesh Sharma > Sent: Mittwoch, 16. November 2016 07:59 > To: Charles Clavadetscher ; > pgsql-general@postgresql.org > Subject: Re: [GENERAL] Request to

Re: [GENERAL] dumping table contents in a sensible order

On 16/11/2016 01:05, Adrian Klaver wrote: INSERT 0 1 ERROR: insert or update on table "table_one" violates foreign key constraint "table_one_parent_id_fkey" DETAIL: Key (parent_id)=(xxx) is not present in table "table_one". So, the problem appears to be that table_one is self-referential by wa

Re: [GENERAL] Request to share information regarding errors

Dear Charles, Thanks for sharing such information. First thing, I want to confirm. >You are trying to insert a row in a table that has a not-null constraint on a >field. >Find the record that causes the error and include a valid value for the column >that has the not null constraint. Entry is al

Re: [GENERAL] Request to share information regarding errors

Good morning > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yogesh Sharma > Sent: Mittwoch, 16. November 2016 07:09 > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Request to share information regardin

Re: [GENERAL] Request to share information regarding errors

Dear All, Thanks for your support. I am using postgresql 9.3.6 rpm in RHEL6 version. In postgresql logs, I have found below error messages. ERROR: null value in column "column name" violates not-null constraint. Second error found: ERROR: there is no unique constraint matching given keys for

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

On 11/15/2016 05:55 PM, John DeSoi wrote: On Nov 10, 2016, at 12:55 AM, Cynthia Hombakazi Ngejane wrote: I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture on site (offline) and my column is of type BLOB. Now I w

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On Tue, 15 Nov 2016, Adrian Klaver wrote: So what do you get with /usr/bin/pg_ctl --version Interesting: $ /usr/bin/pg_ctl --version pg_ctl (PostgreSQL) 9.6.1 and given John's suggestion: ls -al /usr/bin/pg_ctl ls -al /usr/bin/pg_ctl lrwxrwxrwx 1 root root 32 Nov 15 14:16 /usr/bin/pg_ct

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

> On Nov 10, 2016, at 12:55 AM, Cynthia Hombakazi Ngejane > wrote: > > I have two databases SQLlite and Postgres, SQLite is my local database in it > I am saving fingerprint templates that get capture on site (offline) and my > column is of type BLOB. Now I want to sync these templates into

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:18 PM, Rich Shepard wrote: On Tue, 15 Nov 2016, Adrian Klaver wrote: Rich is using Slackware and I am pretty sure it marches to a different drummer. Adrian, And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL is not part of the base distribution. But

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:18 PM, Rich Shepard wrote: On Tue, 15 Nov 2016, Adrian Klaver wrote: Rich is using Slackware and I am pretty sure it marches to a different drummer. Adrian, And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL is not part of the base distribution. But

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:06 PM, Rich Shepard wrote: On Tue, 15 Nov 2016, Adrian Klaver wrote: Assuming the bindirs are in your $PATH: aklaver@panda:~> whereis -f pg_ctl Adrian, In my case: $ whereis -f pg_ctl pg_ctl: /bin/pg_ctl /usr/bin/pg_ctl /usr/X11R6/bin/pg_ctl /usr/bin/X11/pg_ctl /usr/X11/

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On Tue, 15 Nov 2016, Adrian Klaver wrote: Rich is using Slackware and I am pretty sure it marches to a different drummer. Adrian, And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL is not part of the base distribution. But, SlackBuilds.org provides a build script tha

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:01 PM, John R Pierce wrote: On 11/15/2016 4:55 PM, Adrian Klaver wrote: where do I look for the two bindirs? Assuming the bindirs are in your $PATH: aklaver@panda:~> whereis -f pg_ctl pg_ctl: /usr/local/pgsql/bin/pg_ctl /usr/local/pgsql94/bin/pg_ctl Even if only one is the $

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On Tue, 15 Nov 2016, Adrian Klaver wrote: Assuming the bindirs are in your $PATH: aklaver@panda:~> whereis -f pg_ctl Adrian, In my case: $ whereis -f pg_ctl pg_ctl: /bin/pg_ctl /usr/bin/pg_ctl /usr/X11R6/bin/pg_ctl /usr/bin/X11/pg_ctl /usr/X11/bin/pg_ctl /usr/man/man1/pg_ctl.1 /usr/man/ma

Re: [GENERAL] dumping table contents in a sensible order

On 11/15/2016 02:56 PM, Chris Withers wrote: Hi All, I have a database that I want to dump three tables from, for use in development. They form a subset of the data, so I was dumping like this: pg_dump thedatabase --inserts -t table_one -t depends_on_table_one -t depends_on_previous_two > dump.

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 4:55 PM, Adrian Klaver wrote: where do I look for the two bindirs? Assuming the bindirs are in your $PATH: aklaver@panda:~> whereis -f pg_ctl pg_ctl: /usr/local/pgsql/bin/pg_ctl /usr/local/pgsql94/bin/pg_ctl Even if only one is the $PATH: aklaver@panda:~> whereis -f pg_ctl pg_c

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On Tue, 15 Nov 2016, John R Pierce wrote: 9.5 is considered a major version, 9.5.4 is a minor.this will change when 10 is released, from 10 on, major versions will be 10, 11, 12, ... John, So the upgrade from 9.5.4 to 9.6.1 is as I assumed: major. based on the data paths you gave, I'm

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 02:37 PM, Rich Shepard wrote: All my previous version upgrades were performed by running pg_dumpall in the older version followed by running 'pgsql -f ...' to install the dumped .sql file, usually because the upgrade jumped several versions. Now I'd like to try the available postg

Re: [GENERAL] Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 2:37 PM, Rich Shepard wrote: All my previous version upgrades were performed by running pg_dumpall in the older version followed by running 'pgsql -f ...' to install the dumped .sql file, usually because the upgrade jumped several versions. Now I'd like to try the available pos

Re: [GENERAL] dumping table contents in a sensible order

- Original Message - > From: "Chris Withers" > Sent: Tuesday, November 15, 2016 5:56:11 PM > > I have a database that I want to dump three tables from, for use in > development. They form a subset of the data, so I was dumping like this: > > pg_dump thedatabase --inserts -t table_one -

Re: [GENERAL] dumping table contents in a sensible order

Chris Withers writes: > Hi All, > > I have a database that I want to dump three tables from, for use in > development. They form a subset of the data, so I was dumping like > this: > > pg_dump thedatabase --inserts -t table_one -t depends_on_table_one -t > depends_on_previous_two > dump.sql > >

[GENERAL] dumping table contents in a sensible order

Hi All, I have a database that I want to dump three tables from, for use in development. They form a subset of the data, so I was dumping like this: pg_dump thedatabase --inserts -t table_one -t depends_on_table_one -t depends_on_previous_two > dump.sql However, when I try to load this usin

[GENERAL] Upgrade from 9.5.4 to 9.6.1

All my previous version upgrades were performed by running pg_dumpall in the older version followed by running 'pgsql -f ...' to install the dumped .sql file, usually because the upgrade jumped several versions. Now I'd like to try the available postgres commands. The older version is install

Re: [GENERAL] Best practices to manage custom statistics

On 11/15/2016 07:39 AM, Moreno Andreo wrote: Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo wrote: [...] In your experience, would this approach help me lower server load? Are there any other approa

Re: [GENERAL] Converting a TimestampTz into a C# DateTime

Awesome. Thanks everybody for your help -- View this message in context: http://postgresql.nabble.com/Converting-a-TimestampTz-into-a-C-DateTime-tp5930221p5930465.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] pg_restore --clean failing due to dependancies

On 11/15/2016 08:09 AM, Arnaud L. wrote: Le 15/11/2016 à 16:44, Tom Lane a écrit : You'd have to provide a lot more detail before anyone could tell if there was a fixable bug here, but I rather doubt it. There are at least two ways this scenario might lose: 1. There are additional objects in t

Re: [GENERAL] pg_restore --clean failing due to dependancies

On 11/15/2016 07:55 AM, Arnaud L. wrote: Le 15/11/2016 à 16:21, Adrian Klaver a écrit : The restore fails on a lot of statements, complaining about dependencies. For instance, "cannot drop rule _RETURN on view myview1 because view myview1requires it". Or "cannot drop constraint mypkey on table m

Re: [GENERAL] pg_restore --clean failing due to dependancies

"Arnaud L." writes: > The target databased was restored from the dump in an empty database. > So what I do is : > dropdb -U postgres -h localhost db1 > createdb -U postgres -h localhost db1 > psql -U postgres -h localhost -c "CREATE EXTENSION postgis" db1 > pg_dump -h pgsql1 -U postgres -b -Fc -E

Re: [GENERAL] pg_restore --clean failing due to dependancies

Le 15/11/2016 à 16:44, Tom Lane a écrit : You'd have to provide a lot more detail before anyone could tell if there was a fixable bug here, but I rather doubt it. There are at least two ways this scenario might lose: 1. There are additional objects in the target database that have dependencies

Re: [GENERAL] pg_restore --clean failing due to dependancies

Le 15/11/2016 à 16:21, Adrian Klaver a écrit : The restore fails on a lot of statements, complaining about dependencies. For instance, "cannot drop rule _RETURN on view myview1 because view myview1requires it". Or "cannot drop constraint mypkey on table my table because other objects depend on it

Re: [GENERAL] pg_restore --clean failing due to dependancies

"Arnaud L." writes: > Hi am making daily backups of a database and omitting two schemas from > the dump (and the public schema). Those schemas are read-only and have > no dependancy with the rest of the database. > My command is : > pg_dump -h pgsql1 -U postgres -b -Fc -E UTF8 -N public -N osm -

Re: [GENERAL] Best practices to manage custom statistics

Sorry for late reply... i'm in some quite rough days Il 08/11/2016 21:28, Adrian Klaver ha scritto: On 11/08/2016 12:13 PM, Moreno Andreo wrote: [...] In your experience, would this approach help me lower server load? Are there any other approach I can try? Instead of pushing why not pul

Re: [GENERAL] pg_restore --clean failing due to dependancies

On 11/15/2016 07:11 AM, Arnaud L. wrote: Hi all Postgresql 9.3.14 on Windows. Hi am making daily backups of a database and omitting two schemas from the dump (and the public schema). Those schemas are read-only and have no dependancy with the rest of the database. My command is : pg_dump -h pgsq

[GENERAL] Change column type from int to bigint - quickest way

Hi, we have a pretty big table with an integer-type primary key. I'm looking for the quickest way to change the column type to bigint to avoid hitting the integer limit. We're trying to avoid prolonged lock situations and full table rewrites. I know I can hack this with an UPDATE on pg_attribu

[GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

Hello Everyone, I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture on site (offline) and my column is of type BLOB. Now I want to sync these templates into Postgres (to the server), so I created a column of type bytea bu

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

On 11/15/2016 03:23 AM, kaustubh kelkar wrote: Hi Venkata, Thanks for prompt reply. OS user is administrator user. So, I don't know why there are issues. Can anyone suggest me steps to do the same? Because you installed as the user 'administrator' not as the OS user running as Administrator.

[GENERAL] pg_restore --clean failing due to dependancies

Hi all Postgresql 9.3.14 on Windows. Hi am making daily backups of a database and omitting two schemas from the dump (and the public schema). Those schemas are read-only and have no dependancy with the rest of the database. My command is : pg_dump -h pgsql1 -U postgres -b -Fc -E UTF8 -N public

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

On 11/14/2016 09:15 PM, kaustubh kelkar wrote: Hi, Trying to create multiple database instances of PostgreSQL 9.6 In this case , trying to create 2^nd instance with port 5434/5435. _1^st attempt:_ *Create new database cluster : * C:\Program Files\PostgreSQL\9.6\installer\server>initclu

Re: [GENERAL] Converting a TimestampTz into a C# DateTime

valeriof wrote: > BTW, a comment says this about the floating point representation: "A > deprecated compile-time option of PostgreSQL switches to a floating-point > representation of some date/time > fields. Npgsql (currently) does not support this mode." Is it safe to say > that the floating point

Re: [GENERAL] Fwd: Creating multiple instances of postresql on Windows environment

>>> The issue is not with server , it is running fine . >>>Issue is not with port either , for local machine, >> The issue is with: >>I guess [...] >I have no idea what you're saying ... I figured the firewall might be an issue. Or it might not. But guessing won't tell. Regards, Karsten -- S

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

Hi Venkata, Thanks for prompt reply. OS user is administrator user. So, I don't know why there are issues. Can anyone suggest me steps to do the same? On 15-Nov-2016 2:26 pm, "Venkata B Nagothi" wrote: > > On Tue, Nov 15, 2016 at 4:15 PM, kaustubh kelkar > wrote: > >> >> Hi, >> >> >> >> Trying

Re: [GENERAL] Converting a TimestampTz into a C# DateTime

I was able to make it work by reusing the code in TimeStampHandler.cs (in my application I cannot directly reference Npgsql): long datetime = GetInt64(buffer, ref pos); // 8 bytes: datetime if (datetime == long.MaxValue) return

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

On Tue, Nov 15, 2016 at 4:15 PM, kaustubh kelkar wrote: > > Hi, > > > > Trying to create multiple database instances of PostgreSQL 9.6 > In this case , trying to create 2nd instance with port 5434/5435. > > > > *1st attempt:* > > > > > *Create new database cluster : * > > C:\Program Files\Postgre

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Thanks for your response. But that planning for a query execution in GPU is different from planning a query execution in CPU right? Even considering cost calculation, cost for executing a query in GPU is different from cost for executing a query in CPU. How this cost calculation for GPU occurs?

Re: [GENERAL] Fwd: Creating multiple instances of postresql on Windows environment

On 11/15/2016 12:31 AM, Karsten Hilbert wrote: On Tue, Nov 15, 2016 at 10:49:42AM +0530, kaustubh kelkar wrote: >The issue is not with server , it is running fine . >Issue is not with port either , for local machine, The issue is with: >I guess [...] Regards, Karsten I have no idea wha

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Yeah I think Kouhei Kaigai is one of the Contributors. So expecting his reply. And thanks for your kind responses -- View this message in context: http://postgresql.nabble.com/How-the-Planner-in-PGStrom-differs-from-PostgreSQL-tp5929724p5930373.html Sent from the PostgreSQL - general mailing l

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

Mark Anns wrote: > How the planning factors of PGStrom differs from planning factos of > PostgreSQL? I don't know what exactly you mean by a "planning factor". What PGStrom does is estimate the cost of the GPU operations and attach these costs to a custom scan node which is part of a query plan.

Re: [GENERAL] Fwd: Creating multiple instances of postresql on Windows environment

On Tue, Nov 15, 2016 at 10:49:42AM +0530, kaustubh kelkar wrote: > The issue is not with server , it is running fine . > Issue is not with port either , for local machine, The issue is with: > I guess [...] Regards, Karsten > firewall won't affect. > > > On Tue, Nov 8, 2016 at 8:14 PM, Adr

Re: [GENERAL] Incorrect information about GIN-index in RUM's docs

On 15.11.2016 11:12, Andreas Joseph Krogh wrote: På tirsdag 15. november 2016 kl. 08:48:37, skrev Oleg Bartunov mailto:obartu...@gmail.com>>: On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: This item isn't valid, is it? * T

Re: [GENERAL] Incorrect information about GIN-index in RUM's docs

På tirsdag 15. november 2016 kl. 08:48:37, skrev Oleg Bartunov < obartu...@gmail.com >:     On Tue, Nov 15, 2016 at 10:37 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: This item isn't valid, is it?   * There isn't phrase search with GIN index. This proble

Re: [GENERAL] How the Planner in PGStrom differs from PostgreSQL?

On 11/14/2016 9:43 PM, Mark Anns wrote: Thank you so much for your references. How the planning factors of PGStrom differs from planning factos of PostgreSQL? you should probably ask the pgStrom folks this, before your queries, I'd never even heard of it. pgsql-general is primarily for dis