On Jan 7, 2008 1:28 AM, Chuck <[EMAIL PROTECTED]> wrote:
> Since I had sent this email, I contacted my web host for help. They
> said that I could '-E UTF8 --no-locale' to the initdb call within
> /etc/init.db/postgresql. I stopped postgres, deleted the data
> directory and restarted postgres. My c
On Sun, 06 Jan 2008, Chuck wrote:
> Sort order, and specifically setting LC_COLLATE and LC_CTYPE was less of a
> concern. (I still need to read and learn more.)
It should be, as it is not only sort order. Try for example this:
select upper('ąŧäɣ');
- these are
polish a_ogonek, t stroke, g
I'm sorry for my delayed response. Tomasz, thanks for your email.
At 2:38 PM +0100 1/3/08, Tomasz Ostrowski wrote:
On Tue, 01 Jan 2008, Chuck wrote:
I'm not sure how to "make sure automatic updates are turned on" as
Tometzky recommended. Is that a yum setting?
You need to install and confi
On Tue, 01 Jan 2008, Chuck wrote:
> I'm not sure how to "make sure automatic updates are turned on" as
> Tometzky recommended. Is that a yum setting?
You need to install and configure "yum-updatesd" to perform automatic
updates for you. I don't use it so I don't know exactly how to do
this, but I
Along with the other good remarks people have made, I want to point
something out.
On Tue, Jan 01, 2008 at 06:49:40PM -0800, Chuck wrote:
>
> I created a test database and confirmed that it's created with
> 'SQL_ASCII' encoding.
> [EMAIL PROTECTED] ~]# sudo -u postgres createdb myTest
> could no
Greg Smith <[EMAIL PROTECTED]> writes:
> On Tue, 1 Jan 2008, Chuck wrote:
>> Since I have a packaged installation, I don't believe that I will call
>> initdb directly.
> There is actually another command I don't think you've noticed yet:
> service postgresql initdb
Actually, that was only added
On Tue, 1 Jan 2008, Chuck wrote:
Since I have a packaged installation, I don't believe that I will call
initdb directly.
There is actually another command I don't think you've noticed yet:
service postgresql initdb
That runs initdb with the user and permissions properly to get you
something
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 1 Jan 2008 18:49:40 -0800
Chuck <[EMAIL PROTECTED]> wrote:
> ### main question:
> I think that need to figure where initdb is being called from to
> modify its parameters. Or, I need to determine how to set the default
> encoding to be UTF8.
Thanks for Tomasz and Andrew's responses (as well as one person's
response off the list). There was a lot of valuable information. I've
done some further reading in the postgres manual and I've exchanged a
few emails from my web host.
My web host recommends sticking with the CentOS repo packag
On Tue, Jan 01, 2008 at 06:05:32PM +0100, Tomasz Ostrowski wrote:
> > LC_CTYPE="POSIX"
> > LC_COLLATE="POSIX"
>
> This is bad. Make sure you have
> LANG="en_US.UTF-8"
> set in a file "/etc/sysconfig/i18n" and reboot.
If you do it that way, be _very sure_ you understand the interactions of
l
On Mon, Dec 31, 2007 at 02:39:02PM -0800, Chuck wrote:
> yum -y install postgre postgre-server postgre-devel
I assume that's all spelled "postgres". But otherwise, ok.
> Upgrade to PostgreSQL 8.2.5?
> Before I start creating databases, it seems like I should up consider
> upgrading to PostgreSQ
On Mon, 31 Dec 2007, Chuck wrote:
> 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
I think the proper command was:
yum -y install postgresql postgresql-server postgresql-devel
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 p
13 matches
Mail list logo
