pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDefault text_serach_config
5+ messages / 2 participants
[nested] [flat]
* Default text_serach_config
@ 2009-03-06 15:27 Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Carol Walter @ 2009-03-06 15:27 UTC (permalink / raw)
To: pgsql-admin
Hello,
I am building a test instance of PosgreSQL 8.3.6 on a Solaris 10 box.
When start the server, if fails to start. In the log there are these
statements...
-bash-3.00$ more data836.log
FATAL: unrecognized configuration parameter
"default_text_search_config"
FATAL: unrecognized configuration parameter
"default_text_search_config"
-bash-3.00$
I saw no default_text_search_config in the configure file. I didn't
change the one in postgresql.conf. It still says pg_catalog.english.
Thanks,
Carol
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Default text_serach_config
@ 2009-03-06 15:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2009-03-06 15:37 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> I am building a test instance of PosgreSQL 8.3.6 on a Solaris 10 box.
> When start the server, if fails to start. In the log there are these
> statements...
> -bash-3.00$ more data836.log
> FATAL: unrecognized configuration parameter
> "default_text_search_config"
I'll bet a nickel that the postmaster you're actually starting is 8.2,
and it's spitting up on an 8.3-only configuration file entry. Check
your PATH.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Default text_serach_config
@ 2009-03-06 16:06 Carol Walter <walterc@indiana.edu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Carol Walter @ 2009-03-06 16:06 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
On Mar 6, 2009, at 10:37 AM, Tom Lane wrote:
> Carol Walter <walterc@indiana.edu> writes:
>> I am building a test instance of PosgreSQL 8.3.6 on a Solaris 10 box.
>> When start the server, if fails to start. In the log there are these
>> statements...
>
>> -bash-3.00$ more data836.log
>> FATAL: unrecognized configuration parameter
>> "default_text_search_config"
>
> I'll bet a nickel that the postmaster you're actually starting is 8.2,
> and it's spitting up on an 8.3-only configuration file entry. Check
> your PATH.
>
Well, it seems like that could happen. This is a machine that has a
instance of 8.2 running on it. My bash history says that the command
that I ran to start the 8.3.6 instance is
pg_ctl start -D /db02/postgres/data8.3.6/data -l data836.log. /db02/
postgres/data8.3.6/data is where the data is. Does pg_ctl need of
full path, because this command probably ran the 8.2 version of that.
> regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Default text_serach_config
@ 2009-03-06 16:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2009-03-06 16:10 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> Well, it seems like that could happen. This is a machine that has a
> instance of 8.2 running on it. My bash history says that the command
> that I ran to start the 8.3.6 instance is
> pg_ctl start -D /db02/postgres/data8.3.6/data -l data836.log. /db02/
> postgres/data8.3.6/data is where the data is. Does pg_ctl need of
> full path, because this command probably ran the 8.2 version of that.
I think pg_ctl tries to execute the postgres that's in the same
directory it is. So if your PATH leads to the 8.2 copy of pg_ctl,
the wrong thing will happen. You could fix your PATH, or explicitly
write out the path to the 8.3 copy.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Default text_serach_config
@ 2009-03-06 16:16 Carol Walter <walterc@indiana.edu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Carol Walter @ 2009-03-06 16:16 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
On Mar 6, 2009, at 11:10 AM, Tom Lane wrote:
> Carol Walter <walterc@indiana.edu> writes:
>> Well, it seems like that could happen. This is a machine that has a
>> instance of 8.2 running on it. My bash history says that the command
>> that I ran to start the 8.3.6 instance is
>> pg_ctl start -D /db02/postgres/data8.3.6/data -l data836.log. /db02/
>> postgres/data8.3.6/data is where the data is. Does pg_ctl need of
>> full path, because this command probably ran the 8.2 version of that.
>
> I think pg_ctl tries to execute the postgres that's in the same
> directory it is. So if your PATH leads to the 8.2 copy of pg_ctl,
> the wrong thing will happen. You could fix your PATH, or explicitly
> write out the path to the 8.3 copy.
In between our two messages, I changed to the dir where the pg_ctl
version that is part of this installation is and ran...
pg_ctl start -D /db02/postgres/data8.3.6/data -l data836.log
You were correct! Now, I have a different problem. Now, I have...
-bash-3.00$ more data836.log
[::2009-03-06 11:09:09 EST]FATAL: could not load server certificate
file "serve
r.crt": No such file or directory
-bash-3.00$
Part of this process is to get Open SSL working with postgres, so I
think I'm going to go see the person who worked on the Open SSL about
this one.
Tom, I really appreciate your help. You're always ready to help.
Thanks!
Carol
>
>
> regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2009-03-06 16:16 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-06 15:27 Default text_serach_config Carol Walter <walterc@indiana.edu>
2009-03-06 15:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-03-06 16:06 ` Carol Walter <walterc@indiana.edu>
2009-03-06 16:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2009-03-06 16:16 ` Carol Walter <walterc@indiana.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox