On Fri, 2020-05-15 at 12:35 -0700, PegoraroF10 wrote:
> I understood, but the problem is that I cannot just migrate from 11 to 12, I
> have to carefully verify all code before migration.
That is always required. Owing to cour careful testing, you found an
incompatibility, and you have to adapt yo
On Sat, 2020-05-16 at 12:19 -0500, Don Seiler wrote:
> PG 9.6 (9.6.8). Got an alert today when template0 and template1 were both
> over 50%
> towards TXID wraparound. I could vacuum template1 but couldn't vacuum
> template0
> without first allowing connections. This is what it looked like before:
On Sun, 2020-05-17 at 17:41 +0300, Andrus wrote:
> How to implement hot standby and PITR recovery possibility in same backup
> server.
>
> Plan is:
>
> 1. Create base backup using
>
> pg_basebackup --checkpoint=fast --verbose --progress --write-recovery-conf -D
> /var/lib/postgresql/12/standby
Thanks James... that is reassuring, will be working on it this week.
On Mon, 18 May 2020, 04:33 James Sewell, wrote:
>
>
> On Fri, 15 May 2020 at 17:09, Suhail Bamzena
> wrote:
>
>> Hello All,
>> I have very recently inherited an 18 TB DB that is running version 9.2.
>> Apparently this database
On Sat, 16 May 2020 23:18:57 +0800
Alex Magnum wrote:
> Hi,
>
> I have a string that I want to cut to 60 char and then remove the last
> field and comma.
>
> substring('Class V,Class VI,Class VII,Competitive Exam,Class
> VIII,Class X,Class XI,Class IX,Class XII',1,60);
>
> substring | Class V,
On Fri, 15 May 2020 15:08:05 +0200
Christoph Berg wrote:
> Re: Rory Campbell-Lange
> > On 15/05/20, Suhail Bamzena (suhailsa...@gmail.com) wrote:
> > > Hello All,
> > > I have very recently inherited an 18 TB DB that is running
> > > version 9.2.
>
> Push hard to get that upgraded to a suppo
On Fri, 15 May 2020 at 17:09, Suhail Bamzena wrote:
> Hello All,
> I have very recently inherited an 18 TB DB that is running version 9.2.
> Apparently this database has never been backed up and I have been tasked to
> set in a periodic backup routine (weekly full & daily incremental) and dump
>
On 17/05/2020 at 04:22, Tom Lane wrote:> Note that you're not really
getting the same plan that way: it's not
a left join anymore, because you put a strict constraint on the join's
inner relation, so the planner realizes it doesn't have to produce any
null-extended rows. You could make it work w
When setting up an NFS mount for archive WAL logs as described in
https://www.postgresql.org/docs/12/continuous-archiving.html, is NFS v3 or NFS
v4 preferred?
--
Gerard Weatherby | Application Architect
NMRbox | Department of Molecular Biology and Biophysics | UConn Health
263 Farmington Avenue,
Hi!
How to implement hot standby and PITR recovery possibility in same backup
server.
Plan is:
1. Create base backup using
pg_basebackup --checkpoint=fast --verbose --progress --write-recovery-conf -D
/var/lib/postgresql/12/standby
2. Create backup copy of /var/lib/postgresql/12/standby
On 2020-05-17 03:32:59 +, Jessie Nava wrote:
> Hello, I have lost my username and password. I’ve tried reinstalling but that
> doesn’t allow me to reset my login info.
You didn't say what OS your database is running on (actually, you didn't
even say you lost the password for your database ...
Hello, I have lost my username and password. I've tried reinstalling but that
doesn't allow me to reset my login info.
Can you help here please?
Jessie
(213)393-9365
12 matches
Mail list logo
