Hi Wolf,
Wolf Rogner [2008-01-24 20:46 -]:
Tried to understand what I did wrong (I administer my machine using
webmin. So setting all locales during the installation process was
not required. webmin covers most locale handling). Hope I did.
If you changed the locales in webmin, then
Wolf Rogner [2008-01-23 19:38 -]:
I get the feeling that you prefer spending time discussing instead
of fixing.
No, I don't. I spent a hell of a lot of time to make the locale
handling in Postgresql work right. Without working locales, collation
and string comparisons will fail, and the
Don't know what FUD is.
I can create databases using different character sets manually.
However your argument about collation sequences and string handling got
me thinking again.
Tried to repeat the sequence you suggested step by step (without thinking this
time).
Sure enough, postgresql
How do I have to put it:
create_db works fine. The database gets created
pg_createcluster works fine and even starts (magically as I have not read the
code) the database server
it is the init script that checks for a nonexistent directory
only postgresql_common is created.
If you insist that
[EMAIL PROTECTED]:/etc/init.d# apt-get remove --purge postgresql-8.2
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
postgresql-common postgresql-client-8.2
Finally:
doing a
pg_createcluster 8.2 main --start
started the database !!!
So it can be done, but not with the init script in /etc/init.d
Please fix it
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug notification because you are a member of Ubuntu
If I replace your init script with mine it works quite fine.
[EMAIL PROTECTED]:/etc/init.d# ./postgresql-8.2 status
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_TIME = de_AT.utf8,
Hi,
Wolf Rogner [2008-01-22 20:23 -]:
Selecting previously deselected package postgresql-8.2.
(Reading database ... 59446 files and directories currently installed.)
Unpacking postgresql-8.2 (from
.../postgresql-8.2_8.2.6-0ubuntu0.7.10.1_amd64.deb) ...
Setting up postgresql-8.2
I think we are back to square one and it leads us nowhere.
Sorry that you wont take the lead.
My conclusion: Problem is not related to locales and problem occures
because of crippled package (missing installation files).
Close the incident and thanks for your efforts.
Wolf
--
postgresql does
Wolf, I am willing to get to the cause of the problem, but I need the
copypaste of the command outputs:
sudo apt-get remove --purge postgresql-8.2
sudo rm -r /etc/postgresql /var/lib/postgresql
sudo apt-get install postgresql-8.2
(Please do backups before if you have something
The startup scripts are fine. /etc/init.d/postgresql-8.2 exists, and it
duefully will start all 8.2 instances that you created with
pg_createcluster. The script you mention is from upstream; you can use
and customize it if you don't want to use the Debian/Ubuntu packaging,
but if you do that then
Oh, Wolf, and please fix your locales first. Seems that en_US.UTF-8 is
still invalid. Please do
sudo locale-gen en_US.UTF-8
Otherwise it will fail again.
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug notification because you are a member of Ubuntu
How can we procede if I try the things you suggest and the startup
script is still missing.
I went back to locale en_US.UTF-8 (this cripples my Thunderbird and OpenOffice
time display)
I removed and purged postgres (well I moved the files to a save place) and
reinstalled.
I would be happy if
I went back to locale en_US.UTF-8 (this cripples my Thunderbird and
OpenOffice time display)
That would be weird, since we only support UTF-8 locales, and everyone
else is using OO.o and Thunderbird with Unicode, too. Anyway, if you
prefer to use ISO-8859, you can create that as well (sudo
Martin, I appreciate your effort to help me but I am afraid you are
missing the point here. Locales have nothing to do with startup scripts.
I analyzed the deb package and especially the installation files. I did
the same with the standard installation files from postgres.org.
There is one file
Apparently you set a default locale in /etc/environment or somewhere
else which does not exist. Please create it (with sudo locale-gen
en_US.UTF-8) and then reinstall postgresql or use pg_createcluster.
Please note that directories manually created with initdb cannot be
handled through the
I downloaded the required files from postgresql.org. Take the source
tar, extract the startup file and edit it to your needs. Here is mine
#! /bin/sh
# chkconfig: 2345 98 02
# description: PostgreSQL RDBMS
# This is an example of a start/stop script for SysV-style init, such
# as is used on
This is an excerpt from /usr/share/postgresql-common/init.d-functions:
do_ctl_all() {
[ $1 ] || { echo Error: invalid command '$1' 2; exit 1; }
[ $2 ] || { echo Error: invalid version '$2' 2; exit 1; }
[ -d /etc/postgresql/$2 ] || return 0
[ $(ls /etc/postgresql/$2) ] || return 0
[EMAIL PROTECTED]:~# dpkg-reconfigure locales
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_TIME = de_AT.utf8,
LANG = en_US.UTF-8
are supported and installed on your system.
First: Thanks for the hints. I could start postgres and get webmin to show
databases.
Re. your questions:
1. Yes there are symlinks in the rc?.d directories. They point to
/etc/init.d/postgresql-8.2 (which exists)
2. Initially I have tried to remove and reinstall postgresql
3. I am going on
Is there a symlink in the default runlevel?
# ls -l /etc/rc*.d/*postgres*
Have you also tried to remove and purge all postgresql packages and to
install it again?
# apt-get remove --purge libpq5 postgresql postgresql-8.2 postgresql-client-8.2
postgresql-client-common postgresql-common
I cannot confirm this bug, so more informations are needed.
** Changed in: postgresql-8.2 (Ubuntu)
Status: New = Incomplete
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug
1. Are there also symlinks beginning with the letter S? What makes you sure,
that postgresql is not being started after boot?
2. Did you use remove with --purge and have you installed postgresql again?
To your Question: After installing postgresql the database should
automatically get
[EMAIL PROTECTED]:~# apt-get install postgresql postgresql-doc
postgresql-plpython-8.2 Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
postgresql-8.2 postgresql-client-8.2 postgresql-client-common
Please run as root:
# dpkg-reconfigure locales
Did you do a fresh install or an upgrade of your Ubuntu?
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
sudo dpkg -l | grep postgres:
ii postgresql 8.2.5-1.1
object-relational SQL database (latest versi
ii postgresql-8.2 8.2.5-1.1
object-relational SQL database, version 8.2
ii
Please notice that purging the postgresql packages all postgresql
related configuration files and I think databases too will be deleted.
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug notification because you are a member of Ubuntu
Bugs, which is the
S19post in run level 2 .. 5 and K19post... in run level 1, 6
I did use purge when removing it.
What makes me sure postgres is not running?
If I launch postgres manually (su -c '/usr/lib/postgresql/8.2/bin/postgres -D
/home/db' postgres) I see 3 databases up in webmin.
If I restart, or try
After purging all postgresql packages you have installed postgresql
again. What happens then? Does it work directly with the default
configuration? If not, could you please post the output of the total
installation process from apt-get?
Unfortunately I have no Ubuntu x64 installation at this
I am running Ubuntu 7.10 (i386) and postgresql-8.2 starts fine after
installation.
Could you post the output of the installation process? And what packages
are installed?
# sudo dpkg -l|grep postgres
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug
Maybe you need to run initdb.
--
postgresql does not start
https://bugs.launchpad.net/bugs/162517
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
31 matches
Mail list logo
