Re: [ADMIN] Is that a bug?

2000-12-29 Thread Tomaz Borstnar

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

2005-05-14 Thread Tomaz Borstnar
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

2006-01-03 Thread Tomaz Borstnar

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

2006-01-04 Thread Tomaz Borstnar

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?

2005-02-28 Thread Tomaz Borstnar
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?

2002-02-02 Thread Tomaz Borstnar

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!!!

2002-05-16 Thread Tomaz Borstnar

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

2002-11-24 Thread Tomaz Borstnar
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