[ADMIN] Advice on migration without down-time

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 -

[ADMIN] VACUUM FULL ANALYSE hanging

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

R: [ADMIN] VACUUM FULL ANALYSE hanging

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

Re: [ADMIN] Bad encoded chars in being inserted into database

(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

Re: [ADMIN] What is field separator?

//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

Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

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

Re: [ADMIN] virtual ip's for Pg host

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

Re: [ADMIN] Postgres 8.4 large table partitioning

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

Re: [ADMIN] locales and encodings Oh MY!

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

Re: [ADMIN] restore dump sun solaris to linux

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

Re: [ADMIN] Cluster with LATIN1 and UTF-8

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

Re: [ADMIN] Postgres Replication Options

-postgresql-90-clusters.html). Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it

Re: [ADMIN] Postgres Replication Options

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

Re: [ADMIN] what is a serial_fkey data type?

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

Re: [ADMIN] Import image into postgresql database

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

Re: R: Re: [ADMIN] adminpack installation problem

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

Re: [ADMIN] Database alias

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

Re: [ADMIN] Password when logging into postgres

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

Re: [ADMIN] Problem restoring a dump

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

Re: [ADMIN] database size much bigger than tablespaces on filesystem

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

Re: [ADMIN] Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup

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

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

... :) 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

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

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

Re: [ADMIN] migrate from PostgreSQL to Oracle

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

Re: [ADMIN] base backup requirements for PITR

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

Re: [ADMIN] base backup requirements for PITR

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 --

Re: [ADMIN] pooler/router?

. 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

Re: [ADMIN] Point in time recovery + replication

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

Re: [ADMIN] Concurrent Users

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

Re: [ADMIN] Does postgres user on linux need login permission?

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