Hi Nicklas, We are using PostgreSQL as BASE's back-end and are very happy with it. I am not familiar with the details of the installation and backup setup, since it is a department-wide installation administered by our techs. I could ask about the backup though, if you were interested.
It is been some time since I played with the server last time. Three years ago when we migrated from BASE1 to BASE2, we had a few small issues connected to mysql - pgsql differences, but part of it was probably the fact that the migration code was developed for mysql. Good luck with the migration, Pawel On 29/09/11 08:06, Nicklas Nordborg wrote: > Hello, > > We are thinking about migrating our BASE production server from MySQL to > PostgreSQL. The major reason is that PostgreSQL seems to have a lot more > interesting solutions for backup. We are particularly interested in the > WAL archiving solution. Possible combined with a "warm standby" server > which can then be used for SQL dumps without disturbing the main server. > > We have a similar procedure for MySQL but it is not a "continuous" > backup in the first step and the SQL dump is taking far too long time. > > So, if anyone has any experience with PostgreSQL we would love to hear > about your experience. > > There is also a ticket related to the MySQL->PostgreSQL migration on our > website (http://base.thep.lu.se/ticket/1630). Any comments about that > are also welcome. > > Thanks, > Nicklas > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2dcopy1 > _______________________________________________ > The BASE general discussion mailing list > basedb-users@lists.sourceforge.net > unsubscribe: send a mail with subject "unsubscribe" to > basedb-users-requ...@lists.sourceforge.net ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net
