Re: [GENERAL] [ADMIN] Active/Active clustering in postgres
It look's like you're searching for Postgres equivalent of Oracle RAC. I don't know if there is any solution to do this right now in the postgres On Wed, Nov 26, 2014 at 8:36 AM, Postgres India wrote: > Hi All, > > I am looking for PostgreSQL active/active clustering and whether PostgreSQL > support any form of shared-storage clustering . Is there any methods or > tools for implementing active/active clustering on Postgres supported by > community or any third party tools. > > > > Regards > > Manmohan >
Re: [GENERAL] upgrading from V8.3.4 to V9.2.4
Beside all notes, i recommend you to use pg_upgrade, to avoid a complete backup/restore in your transition. http://www.postgresql.org/docs/9.2/static/pgupgrade.html On Fri, Apr 5, 2013 at 1:30 PM, Kevin Grittner wrote: > Robert Treat wrote: > > > Yeah, there were also some subtle breakage around keywords used > > as variable naming when plpgsql was port to use the core lexer. > > One more: from a Java client access to bytea columns will break if > you don't also use the latest JDBC driver jar. > > -- > Kevin Grittner > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Re: [GENERAL] Is it advisable to pg_upgrade directly from 9.0 to 9.3?
I don't think that there will be too much trouble, as long as you follow every changelog tip (9.0->9.1, 9.1->9.2 and 9.2->9.3) On Wed, Nov 6, 2013 at 7:06 AM, Greg Burek wrote: > Hello, > How advisable or well known is it to take a 9.0 era db directly to 9.3 > using the latest pg_upgrade binary? > > I imagine that the upgrade path between adjacent major versions is more > battle tested, but we have several dbs that we would like to bring up to > date without meandering through ever major version along the way. > > Cheers, > Greg >
Re: [GENERAL] Is it advisable to pg_upgrade directly from 9.0 to 9.3?
Yeah, the things that matters are always on top of the changelog, so it's not much trouble to look after then. On Thu, Nov 7, 2013 at 9:00 PM, Adrian Klaver wrote: > On 11/07/2013 11:07 AM, Greg Burek wrote: > >> On Wed, Nov 6, 2013 at 4:36 AM, Leonardo Carneiro >> mailto:chesterma...@gmail.com>> wrote: >> >> I don't think that there will be too much trouble, as long as you >> follow every changelog tip (9.0->9.1, 9.1->9.2 and 9.2->9.3) >> >> >> What if we don't follow the changelog tip? In this case, we have only >> the 9.0 and 9.3 binaries installed and pg_upgrade directly to 9.3. Does >> that cause fear? >> > > Not so much fear as concern. One of my rules is that the good will take > care of itself it is the bad you have to plan for. In this case it is not > the nine changes that do not impact your code but the one that does. When > going through the change logs the incompatibilities are listed at the top > under the Migration to Version 9.* header. It does not take to long to > double check. If you want to save time just look at the major version > changes, i.e 9.X versus 9.X.x as incompatibilities are allowed in major > version changes. Not that they do not happen in minor releases, but that is > generally done to fix a security/major bug and I do not recall any in the > range you are looking at. > > -- > Adrian Klaver > adrian.kla...@gmail.com > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Re: [GENERAL] Has Pg 9.1.0 been released today?
On Tue, Sep 13, 2011 at 8:12 AM, Venkat Balaji wrote: > Yes. I would be excited to know if there is a possibility of multi-master > replication system on Postgres. > > We will be soon using 9.1 Streaming replication. > > Thanks > Venkat > > > On Tue, Sep 13, 2011 at 1:31 AM, Aleksey Tsalolikhin < > atsaloli.t...@gmail.com> wrote: > >> Congratulations on the release of 9.1.0! >> >> Lots of great features, I for one can't wait to try out unlogged >> tables, that should help a lot in our environment. >> >> Now that you have streaming replication both async and sync, are you >> working on multi-master replication? *excited* Or what's the >> roadmap? >> >> Thanks again and keep up the great work! >> >> Aleksey >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > There is any doc about this feature: - Add protocol support for sending file system backups to standby servers using the streaming replication network connection (Magnus Hagander, Heikki Linnakangas) This avoids the requirement of manually transferring a file system backup when setting up a standby server. ? It's a very, VERY welcome feature. Tks to all developers, testers and other people involved in the great software.
[GENERAL] postgresql.org.br site and email offline
Hi everyone, Is there any admin here of the brazillian postgresql site and mailing list? Already have some days that is offline. Any news? tks in advance.
[GENERAL] Is *.projects.postgresql.org offline?
Hello everyone, Is the pages hosted at http://projects.postgresql.org/ offline? I can't access any of them. Tks in advance.
