473,382 Members | 1,615 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

PostgreSQL 7.4.2 initdb problem

Hello All,

I installed postgresql 7.3.4 on HPUX PA in /usr/local/pgsql and put the libraries in
/usr/local/pgsql/lib/LIB_new. During the initialization( initdb), it loads libraries (language) from
/usr/local/pgsql/lib. In postgresql version 7.3.1, libraries are not loaded and no such problem during initdb.

I had the following problem:

$ initdb -D /var/pgsql
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /var/pgsql... ok
creating directory /var/pgsql/base... ok
creating directory /var/pgsql/global... ok
creating directory /var/pgsql/pg_xlog... ok
creating directory /var/pgsql/pg_clog... ok
selecting default max_connections... 100
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /var/pgsql/base/1... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ERROR: could not access file "$libdir/utf8_and_win874": No such file or directory

initdb: failed
$

When I have the libraries in /usr/local/pgsql/lib, there is no problem.

Is there any way to avoid like this?
I wants to install in /usr/local/pgsql and libraries in /usr/local/pgsql/lib/LIB_new directory. How to do this one?

Thanks,
raj.

Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
2 1896
On Sun, Apr 25, 2004 at 04:18:22AM +0000, tech tech wrote:
Is there any way to avoid like this?
I wants to install in /usr/local/pgsql and libraries in /usr/local/pgsql/lib/LIB_new directory. How to do this one?


Did you give the --libdir switch to configure?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2
On Sun, Apr 25, 2004 at 04:18:22AM +0000, tech tech wrote:
Is there any way to avoid like this?
I wants to install in /usr/local/pgsql and libraries in /usr/local/pgsql/lib/LIB_new directory. How to do this one?


Did you give the --libdir switch to configure?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"¿Cómo puedes confiar en algo que pagas y que no ves,
y no confiar en algo que te dan y te lo muestran?" (Germán Poo)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Sander Smeenk | last post by:
Hi, After a very recent postgresql update, the postmaster failed to start because of this: | PANIC: The database cluster was initialized with LC_CTYPE | 'nl_NL@euro.UTF-8', which is...
4
by: KG | last post by:
I'm getting the following error message when I try to create a user or database on postgresql 7.2.2 on Freebsd 4.7, I installed it from the ports directory but I'm stumped when I got the following...
59
by: Jeff Bowden | last post by:
For ease of configuration and other reasons, I would like for my single-user GUI app to be able to use postgresql in-process as a library accessing a database created in the users home directory. ...
9
by: Wei Wang | last post by:
hi, I just took over a project done by somebody else of some C extension of Postgresql 7.1.3. And now I have to port it to pl/pgsql. The guy who developed it said he didn't get it running under...
1
by: phil campaigne | last post by:
On Mon, 1 Mar 2004, phil campaigne wrote: >> Nigel J. Andrews wrote: >> > > >>> >On Mon, 1 Mar 2004, Phil Campaigne wrote: >>> > >>> >
0
by: tech tech | last post by:
Hello All, I installed postgresql 7.3.4 on HPUX PA in /usr/local/pgsql and put the libraries in /usr/local/pgsql/lib/LIB_new. During the initialization( initdb), it loads libraries (language)...
1
by: Nilabhra Banerjee | last post by:
Hi friends, I am loading Potsgresql in shared hard disks. The Disk cluster is shared by two nodes. The nodes can access the disks asynchronously, i.e, the node coming up first gets disk. I have...
2
by: Oleg | last post by:
Dear All, I have upgraded Postgresql from 7.3 to 7.4. Starting pg brings error: The database is in an older format that cannot be read by version 7.4 of PostgreSQL dpkg-upgrade postgresql...
0
by: vkpradeep | last post by:
Hi I am trying to reinstall postgresql on windows.During the installtion it is showing the following error. The files belonging to this database system will be owned by user "postgres". This...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.