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
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
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
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
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