Re: [base] Anyone using BASE with PostgreSQL?
On 2011-09-30 12:09, Pawel Sztromwasser wrote: > Hi Nicklas, > > Our backup procedure is from before-WAL-times so it does not use WAL. > Currently we make daily dumps which are stored if different from the > previous one (based on md5). Not much help for the things that you asked > for, sorry. Ok. Thanks anyway. /Nicklas -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 ___ 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
Re: [base] Anyone using BASE with PostgreSQL?
Hi Nicklas, Our backup procedure is from before-WAL-times so it does not use WAL. Currently we make daily dumps which are stored if different from the previous one (based on md5). Not much help for the things that you asked for, sorry. Pawel On 29/09/11 13:59, Nicklas Nordborg wrote: > On 2011-09-29 12:29, Pawel Sztromwasser wrote: >> 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. > Thanks for the reply. It's good to hear that you are happy with > PostgreSQL. It's actually quite hard to find someone that isn't... > > In any case, if it's not too much trouble it would be nice to hear what > your "techs" have to say. > > /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 of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 ___ 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
Re: [base] Anyone using BASE with PostgreSQL?
On 2011-09-29 12:29, Pawel Sztromwasser wrote: > 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. Thanks for the reply. It's good to hear that you are happy with PostgreSQL. It's actually quite hard to find someone that isn't... In any case, if it's not too much trouble it would be nice to hear what your "techs" have to say. /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
Re: [base] Anyone using BASE with PostgreSQL?
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
[base] Anyone using BASE with PostgreSQL?
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