Re: [ADMIN] Is that a bug?
At 06:59 27.12.2000, R D wrote the following message: > > > > Does dropping and recreating the index help? > >10x! It worked! Anyone have some utility to recreate the index for any given database? This way I don't have to study the database and do lots of manual work which computers can do so much faster. Tomaz Tomaz Borstnar <[EMAIL PROTECTED]> "Love is the answer to the final question you ask" - Unknown
Re: [ADMIN] IMPORTANT: two new PostgreSQL security problems found
Thomas F.O'Connell wrote: I put together a little Perl script (which assumes proper installation of both DBI and DBD::Pg and that template1 exists) that takes care of the character conversion vulnerability: dont hardcode pgsql superuser :) Tomaž ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] full data disk -- any chance of recovery
Jeff Frost pravi: Seems like you're going to have to kill -9. Yeah, this is bad :( Seems like kill -9 is needed when disk is full. Tested on *BSD jails. Tomaž ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] full data disk -- any chance of recovery
Tom Lane pravi: Tomaz Borstnar <[EMAIL PROTECTED]> writes: Jeff Frost pravi: Seems like you're going to have to kill -9. Yeah, this is bad :( Seems like kill -9 is needed when disk is full. Tested on *BSD jails. With what PG version? 8.0.x for sure. And what behavior did you see exactly? Postgresql was running inside jail. All was fine until partition filled up and at this point kill -9 was the only option to stop postgresql in jail. It said about stopping by administrative command, but it did not exit - kill -9 was the only solution without rebooting. Tomaž ---(end of broadcast)--- TIP 6: explain analyze is your friend
[ADMIN] maximum number of schemas per database?
Hello! FAQ does not cover limitations of schema support. Is there a limit of number of schemas per database? Thanks. Tomaž ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Maximum Performance -> File System?
At 07:22 26.1.2002, Jean Huveneers wrote the following message: >I'm going to run postgres on a IDE-RAID5 (hardware from 3Ware) ATA-100 Have you done any testing of RAID5 with IDE disks yet? There were reports from people that RAID0 and RAID1 are screamingly fast with 3ware, but said that their RAID5 had a lot to be desired. Tomaz ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] help me out on installation!!!
At 13:59 13.5.2002, Tom Lane wrote the following message: >Tao Wan <[EMAIL PROTECTED]> writes: > > I am installing postgresql-7.1.2 on Linux 2.4.12. > >Just out of curiosity, why aren't you installing 7.2.1? is there a way to enable/disable bug compatibility with previous versions? namely, option for pgsql not to complain when too long text is inserted. I would like to go to 7.2.x, but cant because of applications that are not ready for 7.2.x which rely on this bug/feature. Toma ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [ADMIN] Weird processes
At 10:47 14.11.2002 -0500, A.M. wrote the following message: What you're looking for is SQLRelay. one can not use sql relay as fake postgresql server? Thanks in advance. Tomaz ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster