I second Bruce. I massively use asciidoc. I guess adding both asciidoc and
md would not be too hard.
Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
2014-02-12 6:02 GMT+01:00 Pavel
will be included in the recovered server.
For further information, I suggest you look at:
http://www.postgresql.org/docs/9.2/static/recovery-target-settings.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol
it is worth evaluating it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
,
Paolo
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
the commitfest.postgresql.org website. For now, I have
updated that for you and the patch now reports you as a reviewer and
links the message to the patch. Here it is:
https://commitfest.postgresql.org/action/patch_view?id=900
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services
appreciated.
Cheers,
Gabriel
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Array-ELEMENT-foreign-key-v1-refreshed.patch.bz2 | patch -p1
Then regular configure and make procedures
(http://www.postgresql.org/docs/current/interactive/install-procedure.html)
Useful link too: http://wiki.postgresql.org/wiki/Developer_FAQ
Hope this helps.
Thanks,
Gabriele
--
Gabriele
you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
,
Gabriele
Tip/Note: by default, search_path is set to search in the $user and
public schemas. Therefore, if you connect using the system_data user,
you do not need to force searching in that schema.
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
flexibility and allows you to
change a tool for a specific component in the future without changing
the whole architecture.
Of course, I take it for granted that you have already thought about
the data warehouse layer (in case you have one).
Cheers,
Gabriele
--
Gabriele Bartolini
to manage very large data sets.
What you are looking for is called 'partitioning' (horizontal
partitioning). I suggest that you read this chapter:
http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training
a list of objects for pg_dump.
It may sound unrelated at first, but if you have PostgreSQL 9.1 this use
case matches very well with the new EXTENSION framework. Please look at
the CREATE EXTENSION command and evaluate it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL
it as admin function (I will have a think about it and possibly
come up with a patch).
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql
Hi Toby,
Il 29/03/12 10:46, Gabriele Bartolini ha scritto:
Currently, there's no such a function. In general we simply check if a
'backup_label' file exists in PGDATA. However, it could be a good idea
to add it as admin function (I will have a think about it and possibly
come up with a patch
suggest that you look at the -l and -L options in pg_restore, which
allow you to select which dump entries to restore (selective restore).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
'
maintenance database in there or something else?
If the user carlos in your database has replication privileges, you can
try and execute the commands by connecting to the postgres database (if
your pg_hba.conf file allows you to do that, but that's another issue).
Ciao,
Gabriele
--
Gabriele Bartolini
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
the day mainly in terms of
inserts/updates/deletes.
I would gradually try and increase checkpoint_segments by 32 and
monitor the effects.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
and Replication conference.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
writing
(http://projects.2ndquadrant.com/repmgr) which should make this kind of
things much easier for you.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql
that much, given that
we have a fairly good storage? Just trying to get some
ideas before starting testing
(table will be 5M rows, where some of the group by
select could return 3-400K groups)
Leonardo
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
/support/professional_support) and let them do
the job for you. Probably cheaper and safer.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql
afraid I have not understood your request. Thanks.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
a look on the documentation about this kind of issues, which has
been improved from version 9
(http://www.postgresql.org/docs/9.0/interactive/plpgsql-implementation.html#PLPGSQL-VAR-SUBST).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
Performance (which you can find from here:
http://www.postgresql.org/docs/books/)
Merry Christmas to you too!
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general
-td3288085.html
[1]
http://archives.postgresql.org/pgsql-hackers/2010-12/msg00087.php [2]
I totally missed this. Thanks for posting it.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent
,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
environment variable.
I can rebuild from sources, if needed.
I believe there is no need to do that.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list
and host (or Unix socket) to
psql.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Il 30/10/10 10:52, RP Khare ha scritto:
I want pgsql to take automatic scheduled backup of the database every
30 minutes. How to do this?
On Unix like systems, you can set a crontab that executes pg_dump every
30 minutes.
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training
replied to that.
Next time, please post the version you are using and possibly the
operating system.
It's incredible, DB don't change dimension even after 1 million insert
and
update.
CPUs average load drastically is fallen down!
Glad you fixed it.
Ciao,
Gabriele
--
Gabriele Bartolini
).
It seems a bug
It is definitely not a bug, but a desired behaviour deriving from the
MVCC architecture.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-general
Hi,
Il 26/10/10 23:01, Hfe80 ha scritto:
Some one know how to solve the problem of db that became huge from 700 Mbyte
to 16 Gbyte in 10 days and grow...
Which version of PostgreSQL are you using?
Some one Know this problem?
Yes. Welcome to the Bloating club. :)
Ciao,
Gabriele
--
Gabriele
Hi Alex,
Of course select ... into doesn't work, but how should I do it?
Can't find in http://www.postgresql.org/docs/8.1/static/
You might want to look at the CREATE TABLE AS command. You might even
use the temporary definer.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
: there is the possibility to
build a sync between a 32 and a 64 bit (on linux)?
As stated in the documentation
(http://www.postgresql.org/docs/9.0/static/warm-standby.html), the
hardware architecture must be the same.
Hope this helps.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training
Hi guys,
just a quick and probably stupid question. When I make a cluster
based on an index on a table, how can I remove it later? Should I
'create' a new one by using the primary key index?
Also, can I have more than 1 cluster on my table? Let me explain ...
can I put for instance the
37 matches
Mail list logo