Re: Upgrade from PostgreSQL 9.6 to 11

On 10/6/19 9:52 π.μ., Pawan Sharma wrote: Thanks all, Is pg_upgrade is the best method if I am doing upgrade on same server or different server. Same server means: source and Target on same server Different: source and Target are different server. A traditional upgrade by definition is on th

Re: Connection refused (0x0000274D/10061)

Hello, Thanks for your quick response. I am new to pgsql, didnot configured it , can you please give a guidance for that? I will be highly oblised if you can assist me. I am using windows 8.1, 64 bit. ruby 2.3.3p222 (2016-11-21 revision 56859) [i386-mingw32] Rails 5.2.3 Trying to setup ruby on rail

Re: Upgrade from PostgreSQL 9.6 to 11

On 6/9/19 11:36 PM, Pawan Sharma wrote: Hello All. What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11 instead of pg_upgrade. - Less downtime. - Approx database size are 1-3TB. If you really don't want to do pg_upgrade, then a possibility is multi-threaded pg_dump using d

Re: Inserting into the blob

On 6/9/19 10:06 AM, Igor Korot wrote: Hi, Adrian, On Sun, Jun 9, 2019 at 11:14 PM Adrian Klaver wrote: On 6/9/19 8:28 AM, Igor Korot wrote: Hi, ALL, How do I insert the png file (content, not a name) into the BLOB field in the table i PostgreSQL DB? Are you talking about this data type?:

found xmin * from before relfrozenxid *

Hello PostgresSQL users and admins, I need some help with my problem. I looked at postgresql logs and it is littered with error messages like: ERROR:  found xmin 3875696185 from before relfrozenxid 1599104090 CONTEXT:  automatic vacuum of table "FMS.pg_catalog.pg_database" ERROR:  found xmin 38

Re: Inserting into the blob

Hi, Adrian, On Mon, Jun 10, 2019 at 8:38 AM Adrian Klaver wrote: > > On 6/9/19 10:06 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Sun, Jun 9, 2019 at 11:14 PM Adrian Klaver > > wrote: > >> > >> On 6/9/19 8:28 AM, Igor Korot wrote: > >>> Hi, ALL, > >>> How do I insert the png file (content,

Drive Architecture for new PostgreSQL Environment

Hello, We're in the process of building a new PostgreSQL environment on Scientific Linux release 7.6. The new environment will have a Primary & 2 Standby servers & have asynchronous replication. It will use repmgr to manage failover/switchover events. In the past, we've always had separate

Re: Drive Architecture for new PostgreSQL Environment

Am 10.06.19 um 18:35 schrieb Hilbert, Karin: We did this as a precaution against disk failure.  If we lose one, we would still have the other two to recover from. Is that really necessary anymore, with having a repmgr cluster? Repmgr is for HA, not for Backup/Recovery. Regards, Andrea

Re: Inserting into the blob

El día Monday, June 10, 2019 a las 11:30:42AM -0500, Igor Korot escribió: > > According to > https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserting-files-into-bytea, > the file needs to be on the server inside PGDATA directory. > It is not a problem in general,

Re: Inserting into the blob

Igor Korot wrote: > It is not a problem in general, but just curious - is there a more > generic solution (to get the file from the client)? With psql: \lo_import /path/to/file It creates a large object with the contents of the file from the client file system and returns its unique ID

Re: found xmin * from before relfrozenxid *

Evaldas Užpalis writes: > Hello PostgresSQL users and admins, > > I need some help with my problem. > > I looked at postgresql logs and it is littered with error messages like: > > ERROR:  found xmin 3875696185 from before relfrozenxid 1599104090 > CONTEXT:  automatic vacuum of table "FMS.pg_cata

Re: Inserting into the blob

On 6/10/19 9:30 AM, Igor Korot wrote: According to https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserting-files-into-bytea, the file needs to be on the server inside PGDATA directory. It is not a problem in general, but just curious - is there a more generic

Re: Inserting into the blob

Hi, Adrian, On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver wrote: > > On 6/10/19 9:30 AM, Igor Korot wrote: > > > > > According to > > https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserting-files-into-bytea, > > the file needs to be on the server inside PGDATA d

Re: Inserting into the blob

> On Jun 10, 2019, at 6:40 AM, Igor Korot wrote: > > Hi, Adrian, > >> On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver >> wrote: >> >>> On 6/10/19 9:30 AM, Igor Korot wrote: >>> >>> >>> According to >>> https://stackoverflow.com/questions/16048649/postgresql-9-x-pg-read-binary-file-inserti

Re: Inserting into the blob

On Mon, Jun 10, 2019 at 8:32 PM Rob Sargent wrote: > > On Jun 10, 2019, at 6:40 AM, Igor Korot wrote: > > > > Hi, Adrian, > > > >> On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver < > adrian.kla...@aklaver.com> wrote: > >> > >>> On 6/10/19 9:30 AM, Igor Korot wrote: > >>> > >>> According to > https

Re: Inserting into the blob

> > >> 1) Are you really wanting to insert a file at a time at the psql command > >> line? > > > > Yes. > Gnarly. I suppose you could open the pdf in emacs and tell emacs to NOT > render it. Cut the entire buffer and paste it, properly quoted, into your > psql command line. But \lo stuff see

Re: Inserting into the blob

Hi, David, On Mon, Jun 10, 2019 at 10:45 PM David G. Johnston wrote: > > On Mon, Jun 10, 2019 at 8:32 PM Rob Sargent wrote: >> >> > On Jun 10, 2019, at 6:40 AM, Igor Korot wrote: >> > >> > Hi, Adrian, >> > >> >> On Mon, Jun 10, 2019 at 7:03 PM Adrian Klaver >> >> wrote: >> >> >> >>> On 6/10/1