initdb failure with Postgres 8.4.4

Поиск
Список
Период
Сортировка
От BRUSSER Michael
Тема initdb failure with Postgres 8.4.4
Дата
Msg-id 29EA9BFEF7E7FC4F988818CA0C5C78C2059327@AG-DCC-MBX03.dsone.3ds.com
обсуждение исходный текст
Ответы Re: initdb failure with Postgres 8.4.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
<div class="WordSection1"><p class="MsoNormal">Initdb fails for me when host machine has no access to the Postgres
buildlocation.<p class="MsoNormal">  <p class="MsoNormal"><span style="font-family:"Courier New"">LOG:  could not open
directory.../install/share/timezone": No such file or directory</span><p class="MsoNormal"><span
style="font-family:"CourierNew"">LOG:  could not open directory .../install/share/timezone": No such file or
directory</span><pclass="MsoNormal"><span style="font-family:"Courier New"">WARNING:  could not open directory
.../install/share/timezonesets":No such file or directory</span><p class="MsoNormal"><span style="font-family:"Courier
New"">HINT: This may indicate an incomplete PostgreSQL installation, </span><p class="MsoNormal"><span
style="font-family:"CourierNew"">       or that the file .../bin.Linux/postgres" has been moved away from its proper
location.</span><pclass="MsoNormal"><span style="font-family:"Courier New"">FATAL:  invalid value for parameter
"timezone_abbreviations":"Default"</span><p class="MsoNormal"><span style="font-family:"Courier New"">DEBUG: 
shmem_exit(1):0 callbacks to make</span><p class="MsoNormal"><span style="font-family:"Courier New"">DEBUG: 
proc_exit(1):0 callbacks to make</span><p class="MsoNormal"><span style="font-family:"Courier New"">DEBUG: 
exit(1)</span><pclass="MsoNormal"><span style="font-family:"Courier New""> </span><p class="MsoNormal">The postgres
executableis in the proper place.<p class="MsoNormal">The truncated paths .../install/share/timezone, etc point to the
originalbuild location.<p class="MsoNormal"><span style="font-family:"Courier New""> </span><p class="MsoNormal">The
timezoneand other files  are available in the local directory:<span style="font-family:"Courier New""></span><p
class="MsoNormal"><spanstyle="font-family:"Courier New"">share % ls -1</span><p class="MsoNormal"><span
style="font-family:"CourierNew"">conversion_create.sql</span><p class="MsoNormal"><span style="font-family:"Courier
New"">information_schema.sql</span><pclass="MsoNormal"><span style="font-family:"Courier
New"">pg_hba.conf.sample</span><pclass="MsoNormal"><span style="font-family:"Courier
New"">pg_ident.conf.sample</span><pclass="MsoNormal"><span style="font-family:"Courier
New"">pg_service.conf.sample</span><pclass="MsoNormal"><span style="font-family:"Courier New"">postgres.bki</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New"">postgres.description</span><p class="MsoNormal"><span
style="font-family:"CourierNew"">postgresql.conf.sample</span><p class="MsoNormal"><span style="font-family:"Courier
New"">postgres.shdescription</span><pclass="MsoNormal"><span style="font-family:"Courier New"">psqlrc.sample</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New"">recovery.conf.sample</span><p class="MsoNormal"><span
style="font-family:"CourierNew"">snowball_create.sql</span><p class="MsoNormal"><span style="font-family:"Courier
New"">sql_features.txt</span><pclass="MsoNormal"><span style="font-family:"Courier New"">system_views.sql</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New"">timezone</span><p class="MsoNormal"><span
style="font-family:"CourierNew"">timezonesets</span><p class="MsoNormal"><span style="font-family:"Courier
New"">tsearch_data</span><pclass="MsoNormal"><span style="font-family:"Courier New""> </span><p class="MsoNormal">I
callinitdb with the –L option pointing to that directory, from initdb log I can see that it is indeed being used for
certainthings –<p class="MsoNormal"> <p class="MsoNormal"><span style="font-family:"Courier
New"">POSTGRES_BKI=.../share/postgres.bki</span><pclass="MsoNormal"><span style="font-family:"Courier
New"">POSTGRES_DESCR=.../share/postgres.description</span><pclass="MsoNormal"><span style="font-family:"Courier
New"">POSTGRES_SHDESCR=.../share/postgres.shdescription</span><pclass="MsoNormal"><span style="font-family:"Courier
New"">POSTGRESQL_CONF_SAMPLE=.../share/postgresql.conf.sample</span><pclass="MsoNormal"><span
style="font-family:"CourierNew"">PG_HBA_SAMPLE=.../share/pg_hba.conf.sample</span><p class="MsoNormal"><span
style="font-family:"CourierNew"">PG_IDENT_SAMPLE=.../share/pg_ident.conf.sample</span><p class="MsoNormal"><span
style="font-family:"CourierNew""> </span><p class="MsoNormal">I am wondering why the timezone files cannot be found
thereas well?<p class="MsoNormal">This is quite urgent and any help will be greatly appreciated.<p
class="MsoNormal">Michael.<pclass="MsoNormal">.<p class="MsoNormal"><br /><br /></div><p style="FONT-SIZE: 9pt; MARGIN:
0px0px 0px 35.4pt; COLOR: #1f497d; FONT-STYLE: italic; FONT-FAMILY: Arial, Helvetica, sans-serif">This email and any
attachmentsare intended solely for the use of the individual or entity to whom it is addressed and may be confidential
and/orprivileged.<p style="FONT-SIZE: 9pt; MARGIN: 0px 0px 0px 35.4pt; COLOR: #1f497d; FONT-STYLE: italic; FONT-FAMILY:
Arial,Helvetica, sans-serif">If you are not one of the named recipients or have received this email in error, <p
style="FONT-SIZE:9pt; MARGIN: 0px 0px 0px 35.4pt; COLOR: #1f497d; FONT-STYLE: italic; FONT-FAMILY: Arial, Helvetica,
sans-serif">(i)you should not read, disclose, or copy it,<p style="FONT-SIZE: 9pt; MARGIN: 0px 0px 0px 35.4pt; COLOR:
#1f497d;FONT-STYLE: italic; FONT-FAMILY: Arial, Helvetica, sans-serif">(ii) please notify sender of your receipt by
replyemail and delete this email and all attachments,<p style="FONT-SIZE: 9pt; MARGIN: 0px 0px 0px 35.4pt; COLOR:
#1f497d;FONT-STYLE: italic; FONT-FAMILY: Arial, Helvetica, sans-serif">(iii) Dassault Systemes does not accept or
assumeany liability or responsibility for any use of or reliance on this email.<p style="FONT-STYLE: italic; MARGIN:
0px0px 0px 35.4pt; FONT-FAMILY: Arial, Helvetica, sans-serif; COLOR: #1f497d; FONT-SIZE: 9pt"><p style="FONT-SIZE: 9pt;
MARGIN:0px 0px 0px 35.4pt; COLOR: #1f497d; FONT-STYLE: italic; FONT-FAMILY: Arial, Helvetica, sans-serif">For other
languages,<a href="http://www.3ds.com/terms/email-disclaimer">Click Here</a> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tim Bunce
Дата:
Сообщение: Re: Optimize PL/Perl function argument passing [PATCH]
Следующее
От: James Cloos
Дата:
Сообщение: Re: XLog vs SSD [Was: Re: random write in xlog?]