else which is also very neat
and good, but needs other tools around the infrastructure.
> >>
> > >
> > > File system snapshot on a robust system like ZFS. Rollback to any
> snapshot
> > > almost trivially, and view any snapshot trivially.
> > >
&
On Wed, Mar 6, 2019 at 1:41 PM Mark Fletcher wrote:
> Thank you for responding to my email.
>
> On Tue, Mar 5, 2019 at 9:20 PM Andreas Kretschmer
> wrote:
>
>>
>> have you set ```max_standby_streaming_delay``? The default is 30
>> seconds, which means that this will be the maximum time allowed f
On Thu, Mar 7, 2019 at 5:16 AM Mark Fletcher wrote:
> Andreas, Sameer,
>
> Thank you for replying. I did not understand the purpose of
> hot_standby_feedback, and your explanations helped. I turned it on, and the
> pausing stopped.
>
Great!
But do bear in mind that this is also not without its o
Regards,
> > > Sonam
> >
> >
> > --
> > Adrian Klaver
> > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
> --
--
Best Regards,
*Sameer Kumar | Senior Solution Architect*
*ASHNIK PTE. LTD.*
36 Robinson Road, #14-04 City House, Singapore 068877
T: +65 6438 3504 | www.ashnik.com
Skype: sameer.ashnik | M: +65 8110 0350
On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <
sridhar@gmail.com> wrote:
> Hi PG-General and Pgsql-Admin
>
> Can we achieve CASE INSENSITIVE in PostgreSQL?
>
You are perhaps migrating from another RDBMS where this kind of feature is
considered a feature.
> I mean, need below way
On Thu, 28 Mar, 2019, 4:28 PM Andreas Kretschmer,
wrote:
>
>
> Am 28.03.19 um 09:20 schrieb Sridhar N Bamandlapally:
> > Hi PG-General and Pgsql-Admin
> >
> > Can we achieve CASE INSENSITIVE in PostgreSQL?
>
> test=# create extension citext;
> CREATE EXTENSION
> test=*# create table emp (eid int,
On Thu, 28 Mar, 2019, 4:33 PM Steve Atkins, wrote:
>
>
> > On Mar 28, 2019, at 8:29 AM, Ron wrote:
> >
> > On 3/28/19 3:23 AM, Sameer Kumar wrote:
> > [snip]
> >> You can write a query with upper function:
> >>
> >> select * from emp whe
ackup as a 'full' backup, and the wal logs in the
> archive as incrementals.one such approach might be a weekly
> basebackup, where you keep the last 4 weeks, and keep all wal files
> since the start of oldest basebackup. yes, this will take quite a bit
> of space
&g
