Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > duplicate prima...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 17 Topic 4908 of 5124
Post > Topic >>

duplicate primary index in bayes db from SpamAssassin

by michael.monnerie@[EMAIL PROTECTED] (Michael Monnerie) Apr 14, 2008 at 05:57 PM

--nextPart4983835.7u2eeIJzQp
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Dear list, I don't know whether pgsql-admin or the SA list is the=20
correct one to ask, so I start here. I have a bayes Postgres database=20
for SpamAssassin, which I use shared from 2 servers to have the same=20
content. I think this could be a locking issue or whatever, I don't=20
care. BUT: I have lots of "duplicate index" elements now, preventing a=20
restore or cleanup. Here's the dump and diff if anyone cares:
http://zmi.at/x/bayes_dup_idx.dump.bz2
(upload currently running)
http://zmi.at/x/bayes_dup_idx.diff.bz2

Could the problem be caused by any settings to the DB, or because of
the=20
stored procedures? Normally there should be no way this can happen, so=20
what can cause this?

mfg zmi
=2D-=20
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc
| gpg --im****t"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

--nextPart4983835.7u2eeIJzQp
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQBIA37hzhSR9xwSCbQRAosAAJ9ssydP1DfhJf5JcYtnN2PLVVcA9gCfTpbU
t0WewrClcT7p/3jq/8wBXsk=
=ghrp
-----END PGP SIGNATURE-----

--nextPart4983835.7u2eeIJzQp--
 




 17 Posts in Topic:
duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-14 17:57:11 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-14 12:00:01 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-14 21:31:10 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-15 08:26:31 
Re: duplicate primary index in bayes db from SpamAssassin
alvherre@[EMAIL PROTECTED  2008-04-14 12:03:25 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-14 22:10:42 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-15 20:27:30 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-16 01:56:39 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-17 09:45:50 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-17 11:41:31 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-18 01:20:24 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-17 20:15:23 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-04-18 01:28:14 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-04-30 16:25:49 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-05-07 11:03:53 
Re: duplicate primary index in bayes db from SpamAssassin
tgl@[EMAIL PROTECTED] (T  2008-05-07 10:32:54 
Re: duplicate primary index in bayes db from SpamAssassin
michael.monnerie@[EMAIL P  2008-05-07 16:42:38 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:46:21 CDT 2008.