[ADMIN] How to drop a template1 owner user

2000-08-16 Thread Roberto Nakai
pgsql-admin, I don't know if this is the right place to ask for your help. If it's not, sorry... I've been using PostgreSQL 7.0 for a few months. Suddenly, every database belongs to two users: "postgres" and "enhydra". This may be due to some bad export/import operation... The form

Re: [ADMIN] Suffering

2000-08-16 Thread Stephan Szabo
Umm, did you have a previous 6.5 installation on the machine? Usually messages like that are caused by mixing 6.5 utilities and 7.0 ones. IIRC, oidvector is new in 7.0, was something else before. Usually this happens if the 6.5 utilities or libs didn't get uninstalled and are earlier in the sea

[ADMIN] error message

2000-08-16 Thread root
Hello there... I've compile postgreSQL 7.0.2 but I got an error message...Below is the error... gcc: Internal compiler error: program cc1 got fatal signal 11 gmake[3]: *** [hio.o] Error 1 gmake[3]: Leaving directory `/tmp/postgresql-7.0.2/src/backend/access/heap' gmake[2]: *** [submake] Error 2

[ADMIN] Multiples databases

2000-08-16 Thread Meibell Contreras
hello...   Has anyone try to have multiple databases... How postgres works distributing the jobs between more than one server???   Thanks..   Meibell   pd: Do you see the article about postgres in http://www.slashdot.org/

[ADMIN] Problem with multibyte encoding and locale support

2000-08-16 Thread Natalya Pyalling
Hello, all! I want to configure postgresql as server with encoding on the fly (Postgres 7.0.2). I have few databases with KOI8 encoding and few ones with WIN encoding. I ran ./configure --enable-locale --enable-multibyte=KOI8, made and installed it. Then I ran initdb -E KOI8 and loaded my databas

[ADMIN] Suffering

2000-08-16 Thread Rob Stoddard
Got this problem: [rob@bloodyaxes bin]# su postgres -c "initdb --pgdata=/var/db --pglib=/usr/local/pgsql/lib"   We are initializing the database system with username postgres (uid=100).This user will own all the files and must also own the server process.   Creating template database in /var