[ADMIN] Advice on migration without down-time

?) 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 - Comune di

[ADMIN] VACUUM FULL ANALYSE hanging

CASCADE ON DELETE CASCADE Tablespace: htminer_oltp Should I drop the indexes and re-create them? Thanks, Gabriele -- Gabriele Bartolini - Istruttore Informatico - Comune di Prato Sistema Informativo - Servizi di E-Government e Open-Source [EMAIL PROTECTED] - www.comune.prato.it http

R: [ADMIN] VACUUM FULL ANALYSE hanging

| 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 Sistema Informativo - Servizi di E-Government e Open-Source [EMAIL PROTECTED] - www.comune.prato.it

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?

/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 to your subscription

Re: [ADMIN] upgrade postgres 8.1.21 to version 8.3.6

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 changes to your

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!

. 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 Bartolini - 2ndQuadrant

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

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?

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

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 - 2ndQuadrant Italia PostgreSQL

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

Re: [ADMIN] Database alias

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

Re: [ADMIN] Password when logging into postgres

. 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.postgresql.org

Re: [ADMIN] Problem restoring a dump

than 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 - 2ndQuadrant Italia

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

Hi, On Wed, 14 Sep 2011 04:03:45 -0700, Rob Audenaerde rob.audenae...@valuecare.nl 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

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

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

-- 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] Migration from Postgresql 9 to Oracle 10g

PLSQL functions, 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

Re: [ADMIN] base backup requirements for PITR

-- 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] pooler/router?

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

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 Training

Re: [ADMIN] Concurrent Users

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

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

) and access to it 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