Re: [GENERAL] Community account

[Magnus Hagander]

Rainer Bauer wrote:
> Hello,
> 
> I signed up a couple of months ago but never received the confirmation email.
> 
> If I try to create a new account with the same email address, but a different
> handle it is denied with this error message: "A user with that email already
> exists".
> 
> When I click on the 'lost password' link and enter my email address nothing
> happens, i.e. no email arrives. In fact I never received *any* email from the
> community registration.
> 
> How should I proceed? Is there someone I can contact directly regarding this
> matter?

Hi!

This belongs on pgslq-www, not -general - let's move it over there.



I've looked through our logs and it seems we are the victims of your
antispam system. I assume you are trying to register as
inqu...@munnin.com? That's the only email I see us trying to deliver to
in that domain. What I have for that one is:

Apr 18 09:34:30 wwwmaster sendmail[68907]: n3I9YOYN068904:
to=, ctladdr= (80/80),
delay=00:00:06, xdelay=00:00:06, mailer=esmtp, pri=30647,
relay=mailin.dcpserver.de. [80.252.97.204], dsn=4.3.0, stat=Deferred:
451-AF-Greylist: Sender Domain has no MX

repeated a couple of times, up to:

Apr 19 03:06:56 wwwmaster sendmail[4515]: n3I9YOYN068904:
to=, ctladdr= (80/80),
delay=17:32:32, xdelay=00:00:12, mailer=esmtp, pri=120647,
relay=mailin3.dcpserver.de. [80.252.97.102], dsn=4.3.0, stat=Deferred:
451-AF-Greylist: Sender Domain has no MX



So we are trying to deliver this to your domain, but appear to be
repeatedly graylisted by the different MX machines. And when we try
again, we're put back on the graylist again.

We are trying to send from @wwwmaster.postgresql.org, which doesn't have
an MX record, that's true. This is because it's an A record, which means
it doesn't *need* an MX. So it appears your mailserver is misconfigured
in this regard.

You need to have the email system give us at least a chance to get off
the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org
domain.

//Magnus


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Community account

[Rainer Bauer]

Hello Magnus,

Sunday, April 19, 2009, 11:05:49 AM, you wrote:

MH> I assume you are trying to register as inqu...@munnin.com?

Yep.

MH> So we are trying to deliver this to your domain, but appear to be
MH> repeatedly graylisted by the different MX machines. And when we try
MH> again, we're put back on the graylist again.

MH> We are trying to send from @wwwmaster.postgresql.org, which doesn't have
MH> an MX record, that's true. This is because it's an A record, which means
MH> it doesn't *need* an MX. So it appears your mailserver is misconfigured
MH> in this regard.

MH> You need to have the email system give us at least a chance to get off
MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org
MH> domain.

Thanks for the info. I have contacted my provider regarding this issue.

Rainer


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Community account

[Rainer Bauer]

Hello Magnus,

Sunday, April 19, 2009, 11:05:49 AM, you wrote:

MH> You need to have the email system give us at least a chance to get off
MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org
MH> domain.

It was whitelisted and works now like a charm. Thanks, Magnus!

I suppose there is no way to display an error message to the user if
the email cannot be delivered?

Rainer


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Community account

[Roderick A. Anderson]

Scott Marlowe wrote:

On Sat, Apr 18, 2009 at 8:27 AM, Rainer Bauer  wrote:

Hello Scott,

Saturday, April 18, 2009, 4:21:29 PM, you wrote:

SM> On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer  wrote:

Hello,

I signed up a couple of months ago but never received the confirmation email.

If I try to create a new account with the same email address, but a different
handle it is denied with this error message: "A user with that email already
exists".

SM> The mailing lists don't support user names, just email addresses.

Yes, I know. I was talking about a community account.

SM> Where exactly are you signing up?

Here: 


Ahh, ok.  I'd guess that you got an email and anti-spam software ate
it?  Just guessing.


FYI, I tried to sign up yesterday and saw the message get caught by 
Postgrey at 09:18 then delivered at 20:06 when a second try to deliver 
was made.


Most other servers greylisted get back within a few minutes.  The 
Postgrey delay/backoff is set for 60 seconds.



\\||/
Rod
--


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] number of relations reported by vacuumdb -av

[Irene Barg]

System: MacOS XServer, 4GB RAM
PostgreSQL-8.1.9: the MCAT database 7.6GB big has 525 relations

Hi Martin

The current setting is:

max_fsm_pages = 20  # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 2000# min 100, ~70 bytes each


I reset it yesterday and bounced the postmaster, but value needed for 
'max_fsm_pages' continues go grow, note result from vacuumdb on Apr 18 15:15



[arcs...@dsan3 data]$ cat /tmp/dovacuumdb-pm.log
start vacuumdb -z MCAT
2009-04-18 15:00:00
NOTICE:  number of page slots needed (270944) exceeds max_fsm_pages (20)
HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a 
value over 270944.
VACUUM
vacuumdb completed
2009-04-18 15:15:07


The activity on this database is almost exclusively INSERTS averaging 
between 2500-3500 INSERTS daily. I am vacuuming twice a day at 9AM and 
again at 3PM, and the number of page_slots needed increase with each 
vacuum.


The postmaster contains two other active databases:

JBoss db (mostly message queues) 1.5GB, 208 relations
dsmixed 82 MB 214 relations

The last vacuumdb log for Jboss also showed max_fsm_pages was exceeded:

[arcs...@dsan3 data]$ cat /tmp/dovacuumdb_jboss.log
start vacuumdb -z jboss
2009-04-18 11:45:00
NOTICE:  number of page slots needed (271856) exceeds max_fsm_pages (20)
HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a 
value over 271856.
VACUUM
vacuumdb completed
2009-04-18 11:45:35


But the vacuumdb log for 'dsmixed' was ok.

What type of statistics do I need to collect to set these two parameters 
  to a level I do not have to bounce the postmaster daily? Or is it 
safe to just double the max_fsm_page value to 50 or possibly 100?


--irene


Martin Gainty wrote:

Good Morning Irene

could you verify the requirement to set
max_fsm_pages (integer) to 16 times new value of 'max_fsm_relations'

Thanks!
Martin Gainty 
__ 
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confidentialité 
This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents.

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger 
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung 
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem 
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. 
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung 
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le 
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez 
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est 
interdite. Ce message sert à l'information seulement et n'aura pas n'importe 
quel effet légalement obligatoire. Étant donné que les email peuvent facilement 
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité 
pour le contenu fourni.







Date: Sat, 18 Apr 2009 03:23:49 -0700
From: ib...@noao.edu
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] number of relations reported by vacuumdb -av

never mindI found the answer in the archives.postgresql.org. The 
answer is 'yes' I use the sum of relations from all of the databases. So 
I have reset 'max_fsm_relations' from 1000 to 2000.


Irene Barg wrote:

Hi,

I have a PostgreSQL installation with 8 databases (counting postgres, 
template0, and template1). I run 'vacuumdb -z' daily on 3 of the largest 
user databases. The vacuumdb logs show the 'max_fsm_pages' need to be 
increased with almost each vacuum. So I did a 'vacuumdb -av' on all the 
db's:

INFO:  free space map contains 81016 pages in 100 relations
DETAIL:  A total of 8 page slots are in use (including overhead).
187792 page slots are required to track all free space.
Current limits are:  8 page slots, 1000 relations, using 534 KB.
NOTICE:  number of page slots needed (187792) exceeds max_fsm_pages 
(8)
HINT:  Consider increasing the configuration parameter "max_fsm_pages" 
to a value over 187792.

VACUUM

I have a couple questions.

1) I can increase 'max_fsm_pages' from 80K to 200K, but why does it keep 
growing?


The main database sees on average 2500-5000 rows inserted per day, and 
deletes are relatively small (although I don't have stats on deletes).


2) How is '100 relations' getting calculated?

If I connect to each one of my 8 db's and do:

select count(*) from pg_class;

The total number of relations is 1725. So shouldn't I increase 
'max_fsm_relations' from 1000 to 1725?


Thank 

Re: [GENERAL] Community account

[Magnus Hagander]

Rainer Bauer wrote:
> Hello Magnus,
> 
> Sunday, April 19, 2009, 11:05:49 AM, you wrote:
> 
> MH> You need to have the email system give us at least a chance to get off
> MH> the graylist :-) Or you need to whitelist the wwwmaster.postgresql.org
> MH> domain.
> 
> It was whitelisted and works now like a charm. Thanks, Magnus!
> 
> I suppose there is no way to display an error message to the user if
> the email cannot be delivered?

Not really. We deliver the email to the mailserver - at that point it
leaves the control of the application. It *can* be done, but that would
take a lot of more work - we'd basically have to implement our own
mailserver functionality...

//Magnus


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] One command to rule them all?

[Raymond O'Donnell]

Hi all, just wondering...

I remember some time back there was a discussion about implementing a
single catch-all command for PostgreSQL, to replace (or perhaps rather
encompass) the various other utilities we currently use (psql, pg_dump,
createdb, etc etc).

Did that idea die a death, or is it still on the radar somewhere?

Ray.

--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r...@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Partitioned table and trigger/insert result horribleness

[Henry]

Quoting "Simon Riggs" :

Use Rules is the current answer, though that has other issues also.


Hi Simon - as you say, Rules have issues.  From my understanding,  
partitioning with rules is impractical.


Anyway, thanks for clarifying.

Cheers
Henry


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Full text search strategy for names

[Tom Lane]

Rick Schumeyer  writes:
> I also noticed that the directions for indexing multiple columns don't seem
> to be quite right.

> In section 12.2.2:

> UPDATE pgweb SET textsearchable_index_col =
>  to_tsvector('english', coalesce(title,'') || coalesce(body,''));

Yeah, this would be better done with a space in the middle.  I've
corrected the documentation --- thanks for the comment!

(Note that you could do it in other ways that don't require this,
ie feed the columns to to_tsvector() separately; but in the terms of
this particular example, you do want a space to avoid running words
together.)

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] DISTINCT ON without ORDER BY

[Martijn van Oosterhout]

Hi,

I was going through the queries of an SQL application and came across
queries like:

SELECT * FROM foo
WHERE id in (SELECT max(id) FROM foo GROUP BY bar);

I thought, here's a case where this could be better written using
DISTINCT ON, since then you avoid the self-join:

SELECT DISTINCT ON (bar) * FROM
ORDER BY bar, id DESC;

However, this was slower because the original query could use a hash
aggregate whereas the new query needed to do a sort. The way DISTINCT
ON is defined it requires an ORDER BY whereas semantically the ordering
on the first attribute is just a by product of the old implementation.

Is there a way to acheive the above result without a sort and without a
self-join?

Have a nice day,
-- 
Martijn van Oosterhout  http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

[Robson Fidalgo]

>
> Hello,
> I am using postgresql 8.3X and I created a table (see example below) that
> has an attribute that is an Array of a Composite Type (ROW). However, I do
> not know how can I insert a record in this table.
>
> Well, I've searched the mailing lists and have found little said about the
> OR features. In postgres 8.3X on-line documentation (
> http://www.postgresql.org/docs/8.3/static/arrays.html) I found "Arrays of
> any built-in or user-defined base type, enum type, or composite type can be
> created", however there is no example that explains how can I do an insert
> into an attribute that is an Array of Composite Type. Considering the
> example below, "persons have N phones" I create (with success) the Person
> table with an array of phones, but I have not success with Insert values.
> There is some one that can help me?
>
> Thanks in advances,
>
> Robson
>
> Example:
>
> CREATE table phone (
>   cod varchar,
>   num varchar);
>
> CREATE TABLE person (
>   name varchar,
>   telephone phone[]);
>
> Until here is everything ok, but I have not success with insert values,
> then I tried:
>
> 1)insert into person values ('Joe', '{("1",""),("2","") }');
> 2)insert into person values ('Joe', array[('1',''),('2','')]);
> 3)insert into person values ('Joe',
> array[row('1',''),row('2','')]);
> 4)insert into person values ('Joe',
> _phone[phone('1',''),phone('2','')]);**
> ** considering _phone = name of array type (automatically created by
> postgres) and phone = name of composite type (also automatically created by
> postgres)
>

[GENERAL] Problem with pgpool-II tool

[aravind chandu]

Hello,

  I have encountered a problem while configuring pgpool-II,I 
encountered a problem while executing the following command.

 pgpool -n &
[1] 2796
[achand...@localhost ~]$ pool_config: could not open configuration file 
(pgpool.conf)
pool_config: using default values...
pid file found but it seems bogus. Trying to start pgpool anyway...
2009-04-19 12:39:24 ERROR: pid 2796: could not open pid file as 
/var/run/pgpool/pgpool.pid. reason: Permission denied

 Following were the default paths in  pgpool.conf file 

# Logging directory
logdir = '/tmp'

# pid file name
pid_file_name = '/var/run/pgpool/pgpool.pid'

since there is no pgpool/pgpool.pid file in run folder i created pgpool 
directory and pgpool.pid file in that directory and gave a value 2678 in 
pgpool.pid file then i got the above message.Can you guys please help me in 
this?

Thanks,
Aravind.


  

[GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

[Robson Fidalgo]

Hello,
I am using postgresql 8.3X and I created a table (see example below) that
has an attribute that is an Array of a Composite Type (ROW). However, I do
not know how can I insert a record in this table.

Well, I've searched the mailing lists and have found little said about the
OR features. In postgres 8.3X on-line documentation (
http://www.postgresql.org/docs/8.3/static/arrays.html) I found "Arrays of
any built-in or user-defined base type, enum type, or composite type can be
created", however there is no example that explains how can I do an insert
into an attribute that is an Array of Composite Type. Considering the
example below, "persons have N phones" I create (with success) the Person
table with an array of phones, but I have not success with Insert values.
There is some one that can help me?

Thanks in advances,

Robson

Example:

CREATE table phone (
  cod varchar,
  num varchar);

CREATE TABLE person (
  name varchar,
  telephone phone[]);

Until here is everything ok, but I have not success with insert values, then
I tried:

1)insert into person values ('Joe', '{("1",""),("2","") }');
2)insert into person values ('Joe', array[('1',''),('2','')]);
3)insert into person values ('Joe', array[row('1',''),row('2','')]);
4)insert into person values ('Joe',
_phone[phone('1',''),phone('2','')]);**
** considering _phone = name of array type (automatically created by
postgres) and phone = name of composite type (also automatically created by
postgres)

Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

[Tom Lane]

Robson Fidalgo  writes:
> I am using postgresql 8.3X and I created a table (see example below) that
> has an attribute that is an Array of a Composite Type (ROW). However, I do
> not know how can I insert a record in this table.

You need some explicit casts so that the array[] construct is seen to
have the right type, eg

insert into person values ('Joe', array[row('1','')::phone, 
row('2','')::phone]);

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

[David Fetter]

On Sun, Apr 19, 2009 at 06:03:26PM -0300, Robson Fidalgo wrote:
> Hello,
> I am using postgresql 8.3X and I created a table (see example below)
> that has an attribute that is an Array of a Composite Type (ROW).
> However, I do not know how can I insert a record in this table.

You want a normalized table anyhow.  If you want something
denormalized, use a view.

> Example:
> 
> CREATE table phone (
>   cod varchar,
>   num varchar);
> 
> CREATE TABLE person (
>   name varchar,
>   telephone phone[]);

This is better as:

CREATE TABLE phone (
cod VARCHAR,
num VARCHAR,
PRIMARY KEY(cod, num)
);

CREATE TABLE person (
name varchar,
PRIMARY KEY(name)
)

CREATE TABLE person_phone (
name VARCHAR NOT NULL REFERENCES person(name),
cod VARCHAR,
num VARCHAR,
FOREIGN KEY(cod, num) REFERENCES phone(cod, num),
PRIMARY KEY(name, cod, num)
);

Cheers,
David.
-- 
David Fetter  http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter  XMPP: david.fet...@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Frequently unable connecting to db "server doesn't listen"

[Net Tree Inc.]

If this e-mail address is not intend use for asking questions using e-mail
suscription, please ignore it.  I could not find any official PostgreSQL
support forum for me to post ask questions. Appreciated if you could you
refer me a few good PostgreSQL support forum for me to ask questions.

Problem:

The problem I am having has happened a few times within in a week. I am
repeatly not able to connect to the db and having "server doesn't listen"
message without touch anything, it just happen. First time it happen after I
restarting my computer that has not been restart for almost a month. After
restarting and trying to connect to DB and it failed, also I notice my
computer can not be restart nor shutdown under the normal way by click on
"start menu" and "shutdown or restart". I can only shut it down use the hard
way by pressing the power button, I don't know why, but its another story.
Therefore for DB, I only can fix it by uninstall and reinstall PostgreSQL.
But it happening repeatly.

Any one experience it? or to guide me to where I can find help?

Re: [GENERAL] Frequently unable connecting to db "server doesn't listen"

[Scott Marlowe]

On Sun, Apr 19, 2009 at 8:10 PM, Net Tree Inc.  wrote:
>
> If this e-mail address is not intend use for asking questions using e-mail
> suscription, please ignore it.  I could not find any official PostgreSQL
> support forum for me to post ask questions. Appreciated if you could you
> refer me a few good PostgreSQL support forum for me to ask questions.

This is a mailing list, so you're here!  No need to look for web
forums or anything.

> The problem I am having has happened a few times within in a week. I am
> repeatly not able to connect to the db and having "server doesn't listen"
> message without touch anything, it just happen. First time it happen after I
> restarting my computer that has not been restart for almost a month. After
> restarting and trying to connect to DB and it failed, also I notice my
> computer can not be restart nor shutdown under the normal way by click on
> "start menu" and "shutdown or restart". I can only shut it down use the hard
> way by pressing the power button, I don't know why, but its another story.
> Therefore for DB, I only can fix it by uninstall and reinstall PostgreSQL.
> But it happening repeatly.
>
> Any one experience it? or to guide me to where I can find help?

Several possibilities.  What's your max_connections set to?  What does
the postgresql log have to say (if anything) about these failed
connections?  How many postgres processes are running when this
happens?  What OS is this on? Are you using some kind of persistent
php client?  Or some other kind of pooling client that might be using
up all the connections?

Any other info you can give us will help.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general