[SOLVED] Upgrade from v4 to v5: Greylisting database?

[sherminator]

Hi,

when I do a migration like the one described in your video tutorial, will the greylisting database be included?
If not: Is there a way to migrate the greylisting database?

Thanks and greets
Stephan

 

[dietmar]

No, that is not possible.

 

[sherminator]

Hi Dietmar,

thanks for your fast answer!
That's a pity. Is there at least a way to take a look into this database?

Thanks and greets
Stephan

 

[dietmar]

What the problem? - this database is build dynamically, so there is no need to backup/restore that.

 

[sherminator]

When we started with PMG our employees often asked why incoming mails are delayed. We explained how greylisting works and that it's a "learning system" and that the delays will "go away" after a while. They understood and as expected the delays "went away".
Upgrading to v5 means starting greylisting from zero and bringing all this back. That would disturb our employees again.
So I like to know whether there is a chance to avoid this.

Greets
Stephan

 

[sherminator]

Hi Dietmar,

is my point of view comprehensible for you?
And aside from this I would just like to know whether there is a way to take a look into the greylisting database - for example in order to debug a user problem.

Thanks a lot and greets
Stephan

 

[dietmar]

is my point of view comprehensible for you?

Yes, but I think a short amount of delay is acceptable.

And aside from this I would just like to know whether there is a way to take a look into the greylisting database - for example in order to debug a user problem.

Sure, it is just a postgres database table.

 

[sherminator]

Hi Dietmar,

I think you're right. Maybe sometimes we are "too" nice to our users.
Thanks for your hint - I will take a look.

Greets
Stephan

 

[dietmar]

I think you're right. Maybe sometimes we are "too" nice to our users.

I think it would even be possible to dump/restore that single database table. But I never done
this, it is a manual task, and deserves some further testing. But If you have some time you can try to go that way.

 

[sherminator]

I think it would even be possible to dump/restore that single database table. But I never done
this, it is a manual task, and deserves some further testing. But If you have some time you can try to go that way.

Thanks for encouraging me doing this - I will give it a try and report the results.

Greets
Stephan