[ADMIN] CREATE TABLE (allow/deny)

2001-05-11 Thread R D
Hi, I'have been waiting for a long time for control on who can and who can not create tables. I'm plannig to migrate all my DBs from MySQL to PostgreSQL (I have already done this where possible) but it's inpossibe now since now it's inpossible to deny table creation to some users. I hoped that 7.

[ADMIN] psql produces core dump

2001-05-11 Thread Reiner Dassing
Hello Tom! By accident I gave in psql the command \@ and \db. In both cases a core dump was produced. This is just a note for your TODO List. Basis: PostgreSQL V7.1.1 on Tru64 V 5.1 -- Mit freundlichen Gruessen / With best regards Reiner Dassing ---(end of broadcast

Re: [ADMIN] psql produces core dump

2001-05-11 Thread Oliver Vecernik
Reiner Dassing wrote: > > Hello Tom! > > By accident I gave in psql the command \@ and \db. > In both cases a core dump was produced. > > This is just a note for your TODO List. > > Basis: > PostgreSQL V7.1.1 on Tru64 V 5.1 But not on: version

[ADMIN] Benchmark results

2001-05-11 Thread Rebi Varghese
Hello, I am doing research, for our software company, on which database would be best to use. We are comparing your software to that of mysql. We would like to have your Benchmark data for the software if you have any, and if not, can you direct me where to go. I thank you for your time and look

[ADMIN] Re: 7.1 ... wtf?

2001-05-11 Thread August Zajonc
I'm assuming you've read the manual carefully. Please make doubley sure you configured PostrgreSQL and your system properly. Server runtime enviroment comes to mind. Check the error logs, its hard to beleive you are getting such blow ups with absolutly nothing in any of the logs. Have you turne

[ADMIN] Books

2001-05-11 Thread Mauricio de Castro
I will be buying computer science books to bring up to date our library. What it recommend to me of good books. Regards Mauricio ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Re: 7.1 ... wtf?

2001-05-11 Thread Thomas Heller
Hi, hmm I don't know if I'm right but I think when I run the postmaster with default values configured it should run at least in a acceptable manner. But it does not. Also it does not respond to any minor tweaks like increasing wal-buffers, wal-files, sort-mem, etc. ... Its just doing his weird a

[ADMIN] How to start PostgreSQL under NT

2001-05-11 Thread Klaus Burkart
Hello, how to startup PostgreSQL on NT? Using the postmaster command doesn't work since I get an error message "postmaster does not know where to find the database system data" What can I do? Klaus __ Do You Yahoo!? Gesendet von

[ADMIN] Pg.pm Install RedHat7.0 Help

2001-05-11 Thread Allan C Huffman
Hello Everyone, I'd like to say first of all that PostgreSQL is a terrific database. Been using it under Solaris with Perl and Java and it runs great! I have a little problem with Linux RedHat 7.0. I can't seem to get Pg.pm to compile. As the README says I'm making it under the postgres super

[ADMIN] 7.1 ... wtf?

2001-05-11 Thread Thomas Heller
Hi again, sometime ago i had a post on 7.1 performance .. this is still up-to-date cause the performance is bad like hell but i have a little bit bigger problem now. I have a dual p3-1ghz + 1gig ram. The hardware is new (asus dual board + registered ecc sdram) and is quite nice but postgres7.1 se

Re: [ADMIN] initdb fails at initializing pg_shadow

2001-05-11 Thread Joerg Brandt
> Joerg Brandt <[EMAIL PROTECTED]> writes: > > Is the following a bug or my mistake -- any hints? > > Looks like a problem all right ... which PG version is this exactly? Sorry, i forgot. postgresql version is 7.1.1, configure options are: --prefix=/opt/pgsql --with-tcl --with-openssl=/usr/lib/ss

RE: [ADMIN] Books

2001-05-11 Thread Pruner Jan
Eh, "My friend - PC" ? Oops JP > -Original Message- > From: Mauricio de Castro [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 09, 2001 4:25 PM > To: PGSQL > Subject: [ADMIN] Books > > > I will be buying computer science books to bring up to date our > library. What it recommend to

Re: [ADMIN] logs file

2001-05-11 Thread Lamar Owen
On Tuesday 08 May 2001 12:23, [EMAIL PROTECTED] wrote: > I have installed postgresql 7.x on red hat 7.0 and I have created a > database and users. I would like now to see in a log file history of > operations on the database, different connexions of users to the > database... > Can you give me th

Re: [ADMIN] initdb fails at initializing pg_shadow

2001-05-11 Thread Tom Lane
Joerg Brandt <[EMAIL PROTECTED]> writes: > FATAL 1: cannot open pg_class: No such file or directory Curious. Looking back at your previous trace, I realize that the first invocation of postgres -boot (which should have created pg_class) produced no debugging output except for the XLOG startup m

[ADMIN] RE : Logs

2001-05-11 Thread [EMAIL PROTECTED]
Lamar Owen wrote >How did you install -- from source, or from RPM? I use postgresql 7.1 and I have installed it from RPM __ Voila vous propose une boite aux lettres gratuite sur Voila Mail: http://mail.voila.fr ---(end