Re: [ADMIN] user permissions and super user

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2001 December 1 04:34 am, Yuri A. Kabaenkov wrote: > How can i create user which users password authrization and can > access/modify/drop/create all these database. > > Create languages on databases and so so so. Sounds like you want a super-us

[ADMIN] apache::dbi and postgresql timeout

Hello, I am using postgreSQL as database for projects working under freebsd,apache,mod_perl and Apache::DBI module which provides persistent database connections per apache child. How can i setup postgreSQl idle/inactive timeout? I think i have many connections to

[ADMIN] zlib & readline

Hi. If I've the /usr/include/readline/*.h and /usr/include/zlib.h, and I put this into a "--with-includes=/usr/include" in the configure process, like this: ./configure * *** --with-includes=/usr/include Why don't compile with zlib and readline option?? I use Debian GNU/Linux with zlib1

[ADMIN] found alternate solution

Thanks to all those that sent messages to help with my TCPIP socket problem. I still cannot get the -i switch to work with postmaster but was able to correct the problem by placing tcpip_socket = 1 in my postgresql.conf file. Thanks Nick for sending me that link to the JDBC info (http://www.

[ADMIN] I wrote a program to migrate Interbase -> PostgreSQL

I wrote a Perl program to help my company migrate from Interbase to PostgreSQL by extracting a database's data and metadata and dumping it as a set of SQL commands (similar to pg_dump or mysqldump). I wrote the program originally to do a row-level backup of our Interbase databases. We had a few

[ADMIN]

Hi all, we are currently developping a "real time" telemetry system. We use postgresql to store each measures. This measures represents around 350 inserts each 5 minutes (this is a 24/7 system). As we saw, performance is really dependant on vacuum analyze operations and we would like to ke

[ADMIN] optimizing for fast INSERTs

After running several tests with PostgreSQL-7.1.3 versus some other opensourced SQL servers, i was very pleased by its performance when it comes to SELECTs on multiple large tables. But there's a problem: if i use PostgreSQL as a SQL backend for Snort, running Snort as a network sniffer and loggin

Re: [ADMIN] optimizing for fast INSERTs

On Wednesday, December 5, 2001, at 02:58 PM, Florin Andrei wrote: > After running several tests with PostgreSQL-7.1.3 versus some other > opensourced SQL servers, i was very pleased by its performance when it > comes to SELECTs on multiple large tables. > But there's a problem: if i use PostgreSQ