basic questions: Postgres with yum on CentOS 5.1

Поиск
Список
Период
Сортировка
Искать
От
Chuck
Тема
basic questions: Postgres with yum on CentOS 5.1
Дата
Msg-id
p0623093ec39f040e7c3f@[192.168.1.50]
Список
Дерево обсуждения
basic questions: Postgres with yum on CentOS 5.1 Chuck <chuckr@velofish.com>
Re: basic questions: Postgres with yum on CentOS 5.1 Tomasz Ostrowski <tometzky@batory.org.pl>
Re: basic questions: Postgres with yum on CentOS 5.1 Andrew Sullivan <ajs@crankycanuck.ca>
Re: basic questions: Postgres with yum on CentOS 5.1 Chuck <chuckr@velofish.com>
Re: basic questions: Postgres with yum on CentOS 5.1 "Joshua D. Drake" <jd@commandprompt.com>
Re: basic questions: Postgres with yum on CentOS 5.1 Andrew Sullivan <ajs@crankycanuck.ca>
Re: basic questions: Postgres with yum on CentOS 5.1 Tomasz Ostrowski <tometzky@batory.org.pl>
Re: basic questions: Postgres with yum on CentOS 5.1 Chuck <chuckr@velofish.com>
Re: basic questions: Postgres with yum on CentOS 5.1 Tomasz Ostrowski <tometzky@batory.org.pl>
Re: basic questions: Postgres with yum on CentOS 5.1 Greg Smith <gsmith@gregsmith.com>
Re: basic questions: Postgres with yum on CentOS 5.1 Tom Lane <tgl@sss.pgh.pa.us>
Re: basic questions: Postgres with yum on CentOS 5.1 Andrew Sullivan <ajs@crankycanuck.ca>
Hello,

About a week ago I got a VPS from a web host. The VPS is running 
CentOS 5.1. I'm a software developer, new to Postgres and only have 
basic Unix admin skills.

I asked the web host to make sure that Postgres is installed. They 
did this by running the following command:
yum -y install postgre postgre-server postgre-devel

They told that the command downloads and installs the RPMs from the 
CentOS 5.1 repo. And they believe it would have added a postgre 
user without login capabilities. When I attempted to 'adduser 
postgre' I discovered that the user already exists. I have confirmed 
that postgres is indeed available:
[chuck@vs191 ~]$ postgres --version
postgres (PostgreSQL) 8.1.9

Upgrade to PostgreSQL 8.2.5?
Before I start creating databases, it seems like I should up consider 
upgrading to PostgreSQL 8.2.5. I do not know of specific features I 
need in version 8.2.5, I just thought I should be using the latest 
stable version. Is this a good idea or should I just use version 
8.1.9? If 8.2.5 is recommended, could someone suggest the best 
approach for upgrading? If this isn't fairly quick and easy, I may 
need to do it later.

Start server and create three databases:
My top priority to start the database server and create three 
databases (with UTF-8) for my rails app. I expect that this should be 
straightforward. I have read parts of Chapters 1 and 16 in the 
Postgres manual, but I still have a few questions.

Questions:
1. Using root, should I change the password for the postgre user with 
'passwd postgre' (so that I know the password)? Do I need to know the 
password?

2. Do I need to manually create the data directory with postgre as 
the owner before running initdb? Such as:
sudo mkdir /usr/local/pgdata
sudo chown postgres /usr/local/pgdata
su - postgres

3. To ensure that the databases I create use UTF-8 do I merely use 
the '-E UTF8' option with initdb? Do I need to be concerned with 
locale settings such as lc-collate? My server appears to have a 
default locale setting:
[chuck@vs191 ~]$ locale
LANG=
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

I have more questions about environment variables and starting the 
database server at reboot, but for the time being I just need to 
create three databases. I'll read the manual more before asking those 
questions.

Thanks and happy new year,
Chuck
В списке pgsql-general по дате отправления
От: Reece Hart
Дата:
Сообщение: Re: double free corruption?
От: dvanatta
Дата:
Сообщение: CREATE TYPE and pgAdmin III
FAQ