Re: Error message restarting a database

Thank, I'll have a look Sent from Galaxy S7 From: Adrian Klaver Sent: Sunday, January 27, 2019 8:18:08 PM To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 2:45 PM, Begin Daniel wrote: >> If you go to PGDATA.pg_tblsp

Re: Implementing an expanded object in C

> "Michel" == Michel Pelletier writes: Michel> Replying to my own problem here, I guess this was a situation Michel> where explaining it in detail revealed the problem to me. By Michel> specifying my type is 'passedbyvalue' That cannot possibly be appropriate. Michel> CREATE TYPE matrix

[ANN] pg2arrow

Hello, I made a utility program to dump PostgreSQL database in Apache Arrow format. Apache Arrow is a kind of data format for columnar-based structured data; actively developed by Spark and comprehensive communities. It is suitable data representation for static and read-only but large number of

Re: Error message restarting a database

On 1/27/19 2:45 PM, Begin Daniel wrote: If you go to PGDATA.pg_tblspc do you have links to the tablespaces? I only installed one instance of Postgres on my PC, which I use to manage two databases (postgres and osmdump). osmdump is the database that complains. Regarding the links to the table

Re: Query help

On Sun, Jan 27, 2019 at 5:27 PM Chuck Martin wrote: > On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote: > >> On 2019-01-26 18:04:23 -0500, Chuck Martin wrote: >> [snip] >> > The idea should be obvious, but to explain, insdatetime is set when a >> new >> > record is created in any table. All

Re: Does creating readOnly connections, when possible, free up resources in Postgres?

Hi David, > I saw that when you create a JDBC connection, you can specify > readOnly=true. Would doing so somehow help Postgres manage its other > connections? if you know that a certain connection will be ready-only, you could use a more aggressive pooling strategy. Usually, a connection p

RE: Error message restarting a database

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 17:38 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 2:22 PM, Begin Daniel wrote: > -Original Message- > From: Adrian Klaver [ma

Re: Error message restarting a database

On 1/27/19 2:22 PM, Begin Daniel wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 16:52 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 1:38 PM, Begin Daniel wrote: -Origina

RE: Error message restarting a database

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 16:52 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 1:38 PM, Begin Daniel wrote: > -Original Message- > From: Adrian Klaver [ma

Re: Query help

On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote: > On 2019-01-26 18:04:23 -0500, Chuck Martin wrote: > [snip] > > The idea should be obvious, but to explain, insdatetime is set when a new > > record is created in any table. All records in ombcase have a foreign > key to > > status that can'

Re: Implementing an expanded object in C

Replying to my own problem here, I guess this was a situation where explaining it in detail revealed the problem to me. By specifying my type is 'passedbyvalue' and 'alignment = double' it now works! CREATE TYPE matrix ( internallength = 8, input = matrix_in, output = matrix_out,

RE: Error message restarting a database

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 16:52 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 1:38 PM, Begin Daniel wrote: > -Original Message- > From: Adrian Klaver [ma

Re: Query help

On 1/27/19 1:50 PM, Chuck Martin wrote: Chuck Martin Avondale Software On Sun, Jan 27, 2019 at 2:55 PM Adrian Klaver > wrote: On 1/26/19 3:04 PM, Chuck Martin wrote: [snip] Outline form: 1) If a record is in ombcase it has a status('in a sta

Re: Error message restarting a database

On 1/27/19 1:38 PM, Begin Daniel wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 16:15 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 12:56 PM, Begin Daniel wrote: Not a good

Re: Query help

Chuck Martin Avondale Software On Sun, Jan 27, 2019 at 2:55 PM Adrian Klaver wrote: > On 1/26/19 3:04 PM, Chuck Martin wrote: > [snip] > Outline form: > > 1) If a record is in ombcase it has a status('in a status') by definition. > > From query below you are not looking for just records in omb

RE: Error message restarting a database

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 16:15 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 12:56 PM, Begin Daniel wrote: Not a good day, forgot to actually Cc list last time

Re: Error message restarting a database

On 1/27/19 12:56 PM, Begin Daniel wrote: Not a good day, forgot to actually Cc list last time. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Sunday, January 27, 2019 15:43 To: Begin Daniel Subject: Re: Error message restarting a database On 1/27/19 12:

Re: Error message restarting a database

On 1/27/19 12:23 PM, Begin Daniel wrote: I worked with a PostgreSQL database (9.3) for a couple of years on my PC. I shut down the PostgreSQL server about a year ago and I obviously did not access the database since. Now I am trying to access again to the database but I get the following error

Error message restarting a database

I worked with a PostgreSQL database (9.3) for a couple of years on my PC. I shut down the PostgreSQL server about a year ago and I obviously did not access the database since. Now I am trying to access again to the database but I get the following error message... FATAL: *"pg_tblspc/113608/PG.

Re: Query help

On 1/26/19 3:04 PM, Chuck Martin wrote: I'm having trouble formulating a query. This is a simplified version of the tables: ombcase case_pkey integer, primary key casename varchar insdatetime timestamp w/o time zone status_fkey integer, foreign key status status_pkey inte

Re: Does creating readOnly connections, when possible, free up resources in Postgres?

"David Kremer" writes: > I saw that when you create a JDBC connection, you can specify readOnly=true. > Would doing so somehow help Postgres manage its other connections? Perhaps > Postgres, knowing that a connection is readOnly and will never even attempt > to do an update, will free up some i

Does creating readOnly connections, when possible, free up resources in Postgres?

(resending to remove HTML formatting) I have an API server and I'm trying to be conscientious managing Postgres's resources carefully. On the client side, I have a Hikari Pool. Usually when I need a connection, I simply create a default read/write connection, even if I don't plan to make any up

Does creating readOnly connections, when possible, free up resources in Postgres?

I have an API server and I'm trying to be conscientious managing Postgres's resources carefully. On the client side, I have a Hikari Pool. Usually when I need a connection, I simply create a default read/write connection, even if I don't plan to make any updates or inserts or hold any locks. But

Implementing an expanded object in C

Hello, Apologies in advance for the long question. I've made a lot of progress on my GraphBLAS extension and getting close to having most of the API usefully exposed to postgres, but I'm been struggling with an issue related to when i switched to using an expanded representation of matrix types.

Re: Query help

On 2019-01-26 18:04:23 -0500, Chuck Martin wrote: > I'm having trouble formulating a query. This is a simplified version of the > tables: > > ombcase > > case_pkey integer, primary key > casename varchar > insdatetime timestamp w/o time zone > status_fkey integer, foreign key > > sta