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
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
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
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?:
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
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,
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
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
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,
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
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
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
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
> 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
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
>
> >> 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
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
17 matches
Mail list logo