n (Slony-I?) could be a viable option, assuming that the
different locale for the data dir of the two database servers does not
influence the results. Using a slave DBMS could limit the down-time.
Thank you for your attention.
Cheers,
Gabriele
--
Gabriele Bartolini - Istruttore Informatico -
coli di integrità referenziale
"requests_id_referer_fkey" FOREIGN KEY (id_referer) REFERENCES
oltp.urls(id_url) ON UPDATE CASCADE ON DELETE CASCADE
"requests_id_session_fkey" FOREIGN KEY (id_session) REFERENCES
oltp.sessions(id_session) ON UPDATE CASCADE ON DELETE CASCAD
0 | 9178 | RowExclusiveLock| t
relation |16415 | 199384 | | | | |
| |64899160 | 9178 | AccessExclusiveLock | t
It should be alright. I am waiting for the results. Thank you for your nice
answers.
Ciao,
Gabriele
--
Gabriele Bartolini - Istruttore Informatico - Comune di Prato
Siste
(either on the server
side or the client side).
However, before I go on, please answer the above questions.
Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-admin mailing
//www.postgresql.org/docs/current/static/app-psql.html
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
isn't it?
Otherwise, you should think of 8.4.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make chan
ich specifies on which interfaces/IP addresses
PostgreSQL is listening for incoming requests
(http://www.postgresql.org/docs/current/static/runtime-config-connection.html).
I hope this helps.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Su
Hi Maria,
Il 18/10/10 16:38, Maria L. Wilson ha scritto:
Anybody out there using Postgres table partition with a
Jboss/Hibernate backend??
We do, but could you please provide us with more detailed information
regarding your specific issues?
Thank you.
Regards,
Gabriele
--
Gabriele
lation. Before that,
yes, you need to re-init your data dir.
initdb /path/to/data/dir --lc_ctype=C --lc_collation=C
--lc_message=en_US.UTF8 --lc_monetary=en_US.UTF8 --lc_numeric=en_US.UTF8
--lc_time=en_US.UTF8 -E UTF8
Maybe you meant --lc_collate ?
Cheers,
Gabriele
--
Gabriele Bar
you
upgrade any of those?
How Can I solve it?
I suspect you are from Italy. So it may be a good idea to try and come
to PGDay Italia next week in Rome (www.pgday.it) to start with. :)
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
command:
http://www.postgresql.org/docs/9.0/interactive/sql-createdatabase.html
Hope this helps.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
-postgresql-90-clusters.html).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
etc...)
If you are looking for table level replication, I suggest also too look
at Londiste and Skytools.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
heers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
w can i export it for see it for example
with paint?
You still have to think in terms of binary information, sequences of
bytes. Your application might return it via the web (typical case) or
save it locally in a temporary folder for display.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadr
server is 8.4.
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ients under a
different name, probably the most practical solution would be to add a
PgBouncer layer in front of the clients which maps the old database name
to the new one.
http://wiki.postgresql.org/wiki/PgBouncer
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Tra
nvironment.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.post
your ways, and my thoughts than your thoughts."
Isaiah 55:8,9
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Gabriele Bartolini - 2ndQua
Hi,
On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde
wrote:
Is this corruption of the database? Or are there ways to 'fix' this
oddity?
Try VACUUM ANALYSE and repeat the operation.
Thanks,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services a
took it for granted that the two servers are in the same LAN.
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes t
... :)
I am not 100% sure it is ... Under normal circumstances (once the
standby has been cloned), repmgr simply controls the status of a standby
server communicating with a master through the streaming replication
protocol. As any other standby would do.
Cheers,
Gabriele
--
Gabriele
ions,
but not the other way around. Sorry. :(
Just for the record and to understand if this is due to PostgreSQL
limitations, are you in a position to give us technical/product reasons
for this decision?
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Se
Il 25/10/12 15:29, jo ha scritto:
Is there any interesting linux script to do this more easily?
something like the ora2pg script.
Have you tried searching for pg2ora on Google?
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
riele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
hrough hot standby),
rsync/tar from the standby, then pg_stop_backup() on the master. If you
think of following this path yourself, please make sure you test it
accurately (especially for production environment).
Sorry Andrew about misunderstanding the original question.
Cheers,
Gabriele
--
. PgPooler + routing, sort of.
With pgbouncer you can create virtual databases and map them on
different hosts. It is very light and open source:
http://wiki.postgresql.org/wiki/PgBouncer
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabri
Hi German,
Il 09/05/13 17:45, German Becker ha scritto:
> Do I need to get a new copy of the primary to continue the replication?
Yes. At that point, it is a completely different server with its own new
life. :)
Ciao,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Train
tremely well. ;)
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.post
through the "root" user using sudo/su or
public SSH key authentication. Just leave it as is, with no password.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via p
30 matches
Mail list logo