Re: [base] Anyone using BASE with PostgreSQL?

2011-09-30 Thread Pawel Sztromwasser
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?

2011-09-30 Thread Nicklas Nordborg
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?

2011-09-29 Thread Pawel Sztromwasser
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


Re: [base] Anyone using BASE with PostgreSQL?

2011-09-29 Thread Nicklas Nordborg
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