On 03/07/2015 12:23, Bill Moran wrote:
On Fri, 03 Jul 2015 13:16:02 +0200
Jan Lentfer wrote:
Am 2015-07-03 13:00, schrieb howardn...@selestial.com:
On 03/07/2015 11:39, Guillaume Lelarge wrote:
In that case is there any recommendation for how often to make
base backups in relation to the
On 03/07/2015 11:39, Guillaume Lelarge wrote:
> In that case is there any recommendation for how often to make base
backups in relation to the size of the cluster and the size of the WAL?
>
Nope, not really. That depends on a lot of things. Our customers
usually do one per day.
--
Guilla
On 03/07/2015 11:15, Guillaume Lelarge wrote:
pg_dumpall is not more efficient than pg_dump. As far as I can tell,
you're looking for PITR backups.
Thanks Guillame.
In that case is there any recommendation for how often to make base
backups in relation to the size of the cluster and the
Hi everyone,
I am reaching the point with my database backups where the backups are
taking too long, and starting to interfere with running of the system
during the day. So I am looking for a bit of sage advice as to how to
proceed.
For a typical server, I have a single database cluster with
On 07/04/2014 11:58, Albe Laurenz wrote:
http://www.postgresql.org/docs/current/static/collation.html#AEN33298
The ordering depends on the collation. Which collations are available
and how they order depends on your operating system. What is your OS
and what do you get for SHOW lc_collate; Your
Hi,
just as I thought I had postgres mastered :) the ordering of strings is
causing me some confusion.
Can someone explain how the database orders strings in the ORDER BY command.
My example:
My database is encoding is UTF-8, and default language is english,
If I have a text column in a ta
Just spotted an earlier discussion between Christoph Berg and Joshua
Drake which resolved the problem.
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I am trying to install postgresql-9.2 using the instructions in the apt
wiki. I already have 9.1 installed - and would like to keep both for the
moment - but the install of 9.2 fails as below...
sudo apt-get install postgresql-9.2
Reading package lists... Done
Building dependency tree
Re
Happy new year everyone!
I am trying to create a column to extract the file extension from a
column in a table and set another column to this value. E.g. foo.doc -> doc
I am using the regex E'\\.([[:alnum:]])*$', but I cannot seem to find
the correct update combination.
My best attempt to d
