The INSTALL file for postgresql 8.3rc1 lists the following install
instructions:
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D
I am trying to port a MySQL db to postgres 8.3rc1.
In MySQL I have a function SHA1, which is critical for storing and
authenticating passwords.
I see some old posts on how to add this function myself. see:
http://raveica.comdurav.com/blog/programming/how-do-i-add-sha1-to-postgresql/
Has sha1 been
I am a fairly new user of postgres and am starting with the very
latest 8.3rc1.
I need to figure out the pros/cons of compiling from the source of
postgres.org or the install package from enterprisedb.
My production target is AMD64 on ubuntu 7.04.
My test and staging target is 32 bit ubuntu 7.04
California db?
3 - Would trying this on 9.2 be a better place to start? I don't think there
is any reason we couldn't migrate up at this point.
Although I've used pg for quite a few years, this is my first trip in
replication land…any advice would be appreciated.
thanks
--
Jon Hancock
