[ADMIN] Logifle analysis

2003-09-08 Thread Daniel Seichter
Hello, is there a tool like webalizer for postgreSQL to get a nice overview over all logfiles? Thank you Daniel ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to

Re: [ADMIN] Installation problem with libreadline

2003-08-14 Thread Daniel Seichter
Hello, How do I go about resolving the undefined ncurses references in libreadline? I have Mandrake Linux. Did you install the readline-devel? Daniel ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

2003-08-14 Thread Daniel Seichter
Deacitvate the HyperThreading and it should run like a young cat *g* -- postgreSQL on Netware - the red elephanthttp://postgresql.dseichter.org "Wilson A. Galafassi Jr." [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]... Hello. I have this problem:i'm runningthe

Re: [ADMIN] Help with privilege or pg_hba.conf

2003-07-20 Thread Daniel Seichter
is right (never needed restrict the access to only one database) Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [ADMIN] No such file or directory: ./configure

2003-07-05 Thread Daniel Seichter
Good morning, Unfortunately, I encounter error even in the first step of the installation procedure. I'm not able to find the 'configure' file/command in my directories, any idea what could be the error? Try a look into the root of your pgsql source directory or try to 'find ~/postgresql-7.3.3

Re: [ADMIN] Advantages and disadvantages of more than one dbserver

2003-07-04 Thread Daniel Seichter
Hello Sam and Scott We'll be looking at more performance boosts once the system is mature. We already have the DB on a dedicated drive, on a dedicated controller. Moving to a RAID 1 config with another 120GB drive would be good. The DB on disk currently takes up about 35GB with only 1 quarters

Re: [ADMIN] Advantages and disadvantages of more than one dbserver on one server

2003-07-03 Thread Daniel Seichter
The result of compiling, testing and let postgreSQL crash: Now I know, that I only have advantages if I will let run each database with its own session of pgsql. I can stop/start/restart(/kill) one session and the other works as long as the server is not shutting down or something like the worst

[ADMIN] Advantages and disadvantages of more than one dbserver on one server

2003-07-02 Thread Daniel Seichter
Hello, I want to discuss a little bit about the following situation: I only have one server for my databases.I had to develope on this server and also had to manage several databases, so I can expect problems if I had to restart postgreSQL, if I changed the logging. What do you think about

Re: [ADMIN] Advantages and disadvantages of more than one dbserver

2003-07-02 Thread Daniel Seichter
Hello Scott, Note that even if you ARE going to run each cluster under a different user (I recommend running each cluster under a different user so you can do 'insane' things like let each person have C as an untrusted language and be their own superuser in a mostly sane way) you still only

Re: [ADMIN] postgreSQL users = LDAP users?

2003-07-01 Thread Daniel Seichter
Hello, thank you for you links, I will take a look to it. Daniel -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org -- you wrote --- Look at this http://www.mandrakesecure.net/en/docs/samba-ldap-advanced.php http://www.mandrakesecure.net/en/docs/ldap-auth2.php if you

[ADMIN] postgreSQL users = LDAP users?

2003-06-29 Thread Daniel Seichter
Hello, is it possible, to create all users of the databaseserver through LDAP? An schema extension is maybe required, but is it possible, yes or no?! If yes, where to find more information? Thank you Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org

[ADMIN] Backup up Users and grants

2003-06-16 Thread Daniel Seichter
Hello, is it possible, to backup all users with their grants to the tables or the database? Thank you Daniel Seichter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-16 Thread Daniel Seichter
on my server and wait 15 minuten until postgreSQL is compiled..*g* Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--- TIP 7: don't forget to increase

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-16 Thread Daniel Seichter
I sit on my server and wait 15 minuten until postgreSQL is compiled..*g* Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--- TIP 5: Have you

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-15 Thread Daniel Seichter
on my server and wait 15 minuten until postgreSQL is compiled..*g* Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--- TIP 9: the planner will ignore your

Re: [ADMIN] Run 4 postgresql session on ONE server?

2003-06-14 Thread Daniel Seichter
Good morning, Yes, you can do it. All you have to do is create four seperate accounts for it to run under (pgsql1, pgsql2, pgsql3, pgsql4) and then in each of those accounts, set up a different PGDATA value and initdb as that user. Then edit each account's postgresql.conf to have a different

[ADMIN] Run 4 postgresql session on ONE server?

2003-06-12 Thread Daniel Seichter
as the second database is ready. Thank you in advance for your answers Daniel Seichter -- postgreSQL on Netware - the red elephant http://postgresql.dseichter.org Last update: 26th May 2003 ---(end of broadcast)--- TIP 6: Have you searched our list