Hello,
I'm going to create two factor authentication for pgadmin server...
I'm using postgresql 9.4 with pgadmin III on Linux Mint 17.2 32bit...
I already have 1 password authentication but For better security, I just
want to force 2 of them. The authentication factors could be any
things(what peop
On 08/26/2015 08:29 AM, Kaushal Shriyan wrote:
Hi,
Can somebody please explain about Point-In-Time-Recovery (PITR) in
context to http://www.pgbarman.org/about/?
From Postgres end:
http://www.postgresql.org/docs/9.4/static/continuous-archiving.html
From Barman end:
http://docs.pgbarman.org/#
On 2015-08-26 17:09:26 -0500, Merlin Moncure wrote:
> On Tue, Aug 25, 2015 at 7:04 PM, Edson Richter wrote:
> > Any chance to get those amazing wonderful features backported to 9.4?
>
> you might have some luck merging in the feature yourself if you're so
> inclined.
It's imo too large a featur
On Tue, Aug 25, 2015 at 7:04 PM, Edson Richter wrote:
> Any chance to get those amazing wonderful features backported to 9.4?
you might have some luck merging in the feature yourself if you're so inclined.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
On 08/26/2015 02:34 PM, Alan Hodgson wrote:
On Wednesday, August 26, 2015 08:25:02 PM Cory Tucker wrote:
What settings would you recommend? Also, it just occurred to me that I
should try to disable/drop all indexes (especially since they will be
recreated) later so that those are not updated in
On Wednesday, August 26, 2015 08:25:02 PM Cory Tucker wrote:
> What settings would you recommend? Also, it just occurred to me that I
> should try to disable/drop all indexes (especially since they will be
> recreated) later so that those are not updated in the process.
Don't drop the indexes you
Hi, I am using postgres 9.3 and am preparing to migrate to 9.4. As part of
the migration, I was hoping to also delete a bunch of data that is no
longer needed (100M+ rows across several tables).
I can fairly trivially delete the data by doing a simple statement like
this:
DELETE FROM account WHE
On 27/08/15 06:59, Raymond O'Donnell wrote:
On 26/08/2015 19:54, Gavin Flower wrote:
On 27/08/15 00:03, Vincent de Phily wrote:
On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
Actually I would suggest standardising on singular names, not JUST
because that this the standard I prefer!
On 26/08/15 12:17, Melvin Davidson wrote:
[...]
So for the sake of argument, a natural key is something that in itself
is unique and the possibility of a duplicate does not exist.
Before ANYONE continues to insist that a serial id column is good,
consider the case where the number of tuples will
- Original Message -
From: Gavin Flower
On 27/08/15 00:03, Vincent de Phily wrote:
On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
Actually I would suggest standardising on singular names, not JUST
because that this the standard I prefer! :-)
But (also) because:
1. Si
On 26/08/2015 19:54, Gavin Flower wrote:
> On 27/08/15 00:03, Vincent de Phily wrote:
>> On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
>>> Actually I would suggest standardising on singular names, not JUST
>>> because that this the standard I prefer! :-)
>>>
>>> But (also) because:
>>>
On 27/08/15 00:03, Vincent de Phily wrote:
On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
Actually I would suggest standardising on singular names, not JUST
because that this the standard I prefer! :-)
But (also) because:
1. Singular words tend to be shorter
2. plurals are more
Melvin Davidson wrote:
> Before ANYONE continues to insist that a serial id column is good, consider
> the case where the number of tuples will exceed a bigint.
> Don't say it cannot happen, because it can.
In practice, it cannot happen.
A tuple with a bigint column weighs at least 32 by
On 08/25/2015 05:28 PM, Adrian Klaver wrote:
On 08/25/2015 05:17 PM, Melvin Davidson wrote:
I think a lot of people here are missing the point. I was trying to give
examples of natural keys, but a lot of people are taking great delight
in pointing out exceptions to examples, rather than understa
On Wed, Aug 26, 2015 at 9:45 AM, Igor Neyman wrote:
> *From:* pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] *On Behalf Of *Melvin Davidson
> *Sent:* Tuesday, August 25, 2015 8:18 PM
> *To:* Adrian Klaver
> *Cc:* Jerry Sievers ; John R Pierce <
> pie...@hogranc
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson
Sent: Tuesday, August 25, 2015 8:18 PM
To: Adrian Klaver
Cc: Jerry Sievers ; John R Pierce
; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL Developer Best Practices
Hi,
Can somebody please explain about Point-In-Time-Recovery (PITR) in context
to http://www.pgbarman.org/about/?
Regards,
Kaushal
On Wed, Aug 26, 2015 at 09:04:08AM -0400, John Turner wrote:
> >>>In most cases developers don’t care about index, unique, foreign key,
> >>>or primary key names (from a coding standpoint)
> >>
> >>Until the day they’d like to write a reliable database change script.
> >
> >Not sure I understand.
On 08/26/2015 03:46 AM, Kaushal Shriyan wrote:
Hi,
Are there scripts which takes backup of postgresql database and archive
data older than 6 months and push it to a remote server using scp or
rsync method and purge/clean the local data on the hard disk at the same
time meaning at any given time
On Tue, 25 Aug 2015 18:57:28 -0400, Neil Tiffin
wrote:
On Aug 25, 2015, at 1:38 PM, Karsten Hilbert
wrote:
In most cases developers don’t care about index, unique, foreign key,
or primary key names (from a coding standpoint)
Until the day they’d like to write a reliable database cha
On Wed, 26 Aug 2015 10:46:53 +
Kaushal Shriyan wrote:
> Hi,
>
> Are there scripts which takes backup of postgresql database and archive
> data older than 6 months and push it to a remote server using scp or rsync
> method and purge/clean the local data on the hard disk at the same time
> mea
On 26-08-2015 10:13, Allan Kamau wrote:
On Wed, Aug 26, 2015 at 5:23 AM, rob stone
wrote:
On Tue, 2015-08-25 at 20:17 -0400, Melvin Davidson wrote:
I think a lot of people here are missing the point. I was trying
to
give examples of natural keys, but a lot of people are taking
great
delig
On Wed, Aug 26, 2015 at 7:03 AM, Vincent de Phily <
vincent.deph...@mobile-devices.fr> wrote:
> On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
> > Actually I would suggest standardising on singular names, not JUST
> > because that this the standard I prefer! :-)
> >
> > But (also) becau
On Wednesday 26 August 2015 10:27:04 Gavin Flower wrote:
> Actually I would suggest standardising on singular names, not JUST
> because that this the standard I prefer! :-)
>
> But (also) because:
>
> 1. Singular words tend to be shorter
>
> 2. plurals are more ambiguous wrt spelling
>
> 3.
On 15/08/26 19:46, Kaushal Shriyan wrote:
> Hi,
>
> Are there scripts which takes backup of postgresql database and archive data
> older than 6 months and push it to a remote server using scp or rsync method
> and purge/clean the local data on the hard disk at the same time meaning at
> any given
Hi,
Are there scripts which takes backup of postgresql database and archive
data older than 6 months and push it to a remote server using scp or rsync
method and purge/clean the local data on the hard disk at the same time
meaning at any given time we have only six months of postgresql data on the
On Wed, Aug 26, 2015 at 5:23 AM, rob stone wrote:
> On Tue, 2015-08-25 at 20:17 -0400, Melvin Davidson wrote:
> > I think a lot of people here are missing the point. I was trying to
> > give examples of natural keys, but a lot of people are taking great
> > delight
> > in pointing out exceptions
27 matches
Mail list logo
