[ADMIN] 6.5 hung

Hi! I found a strange hunging of postgres 6.5. In a few days working child process dumped to core but postmaster was runned it looks like 16890 p5 S0:00 (postmaster) i.e. daed and lying in swap. After ~8 such daed parent postmaster becomes refusing connections... I tried to simulate this s

[ADMIN] FW: BOUNCE pgsql-admin@postgreSQL.org: Non-member submission

Hi! On 07-Jul-99 Vadim Mikheev wrote: >> I found a strange hunging of postgres 6.5. >> In a few days working child process dumped to core but postmaster was runned >> it > > What does gdb say about this core? Core was generated by `/usr/comset/dbase/bin/postmaster -i -D/usr/comset/dbase/data'.

[ADMIN] cyrillic

Hi! Please explain me: Can user choose its locale while fetching data from postgresql (6.5)? What I mean: I have PGSQL in multiuser environment. As ususal in russia some users prefer KOI8-R but other prefer CP-1251 code pages... :-( Sounds good to make SET CODEPAGE='...' operator to change PGSQ

Re: [ADMIN] cyrillic

Hi! On 08-Jul-99 Oleg Broytmann wrote: > Hi! > > On Thu, 8 Jul 1999 [EMAIL PROTECTED] wrote: >> Can user choose its locale while fetching data from postgresql (6.5)? > >Sure! Not only locale, but KOI8<=>CP12521 converting on th fly!!! >> What I mean: >> >> I have PGSQL in multiuser environ

Re: [ADMIN] cyrillic

Hi! On 08-Jul-99 Oleg Broytmann wrote: > Hi! > > On Thu, 8 Jul 1999 [EMAIL PROTECTED] wrote: >> Can user choose its locale while fetching data from postgresql (6.5)? > >Sure! Not only locale, but KOI8<=>CP12521 converting on th fly!!! > >> What I mean: >> >> I have PGSQL in multiuser envi

[ADMIN] recurring in function

Hi! I have interesting in 2 problems: 1. I have xxx.so written in C for postgres countaining function yyy(). May yyy() refers to postgres with other requests? yyy() { ... PQexec("... any request ..."); ... } application: select * from aaa where yyy()='bbb'; 2. I make module xxx.so contaning fu

[ADMIN] dead postmasters... 8-()

Hi! This is a strange: 2314 ? SW 0:00 (postmaster) 2535 ? S0:00 (postmaster) 2653 ? SW 0:00 (postmaster) 3028 ? SW 0:00 (postmaster) 3776 ? S1:40 /usr/comset/dbase/bin/postmaster -i -D/usr/comset/dbase/dat 30334 ? SW 0:00 (postmaster) 31904 ? SW 0:00 (postmas

RE: [ADMIN] replication

Hi! On 26-Aug-99 Safa Pilavcý wrote: > Hello, > Is it possible to do replication through postgresql on Solaris 2.6..? > Can you show me any adress that tells replication on postrgres..? Hmmm.. And I'm interestind in postgres-topostgres replication program. Which replicate database from one host

[ADMIN] logo

Hi! Where can I find nice PostgreSQL logos (gifs ~88x31 or like this) to add on my 'Tech' www-page? SKiller -- Sergei Keler WebMaster of "ComSet" E-Mail: [EMAIL PROTECTED] http://www.comset.net --

[ADMIN] When postgres will be faster?

Hi! When postgres will use posix threads or support pool of backends (like apache)? I guess it will increase speed very fast. Using posix threads may increase data base engine using own internal locking system againgst system locks. Postgres is good database, but its too slow... SKiller --

Re: [ADMIN] When postgres will be faster?

Hi! On 29-Nov-99 Oleg Broytmann wrote: > On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: >> Its wrong solution to fork/exec backend each time. Especially for >> www-oriented >> software which need many short-time connection/work/desconnection. Using >> persistent connection is not always possible...

Re: [ADMIN] When postgres will be faster?

Hi! On 29-Nov-99 Peter Eisentraut wrote: > On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: > >> When postgres will use posix threads or support pool of backends (like >> apache)? >> I guess it will increase speed very fast. > > Actually, the current model greatly benefits multiprocessor machines o

Re: [ADMIN] When postgres will be faster?

Hi! On 29-Nov-99 The Hermit Hacker wrote: >> Yes! But I recommend backend pool too. What is it? The postmaster task >> runs now backend for each query. Good. But After query backend >> finished. I recommend to stay backend running within a some timeout. >> If the next query occured the postmaster

Re: [ADMIN] When postgres will be faster?

Hi! On 29-Nov-99 Bruce Momjian wrote: >> On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote: >> >> > Yes! But I recommend backend pool too. What is it? The postmaster task >> > runs now backend for each query. Good. But After query backend >> > finished. I recommend to stay backend running within a som

Re: [ADMIN] When postgres will be faster?

Hi! On 29-Nov-99 Marcin Mazurek - Multinet SA - Poznan wrote: > Somebody advised me to do such thing with servlets, holding pool of > connections in one srvlet and give them as they are needed, but frankly > speaking i have no idea how to do it. Does anybodyhas such examples with > Connection poo

Re: [ADMIN] When postgres will be faster?

Hi! On 29-Nov-99 Oleg Bartunov wrote: > I'm not concern very much about speed of Postgres but mostly > about its connection schema. Every new connect to database postgres > forks another children. It's impossible to work with different fork and fork/exec are some different. postmaster forks and

Re: [ADMIN] When postgres will be faster?

Hi! On 30-Nov-99 Bruce Momjian wrote: > [Charset KOI8-R unsupported, filtering to ASCII...] >> Hi! >> >> On 29-Nov-99 Oleg Bartunov wrote: >> > I'm not concern very much about speed of Postgres but mostly >> > about its connection schema. Every new connect to database postgres >> > forks another

Re: [ADMIN] When postgres will be faster?

Hi! On 30-Nov-99 Oleg Bartunov wrote: > I suggest postgres experts comment this topic. We really need to work > with different databases using one connection. Postgres is rather good > scalable DB engine and IMO it's worth to have such feature like > DB pooling. Once postgres support db pooling

Re: [ADMIN] When postgres will be faster?

Hi! On 01-Dec-99 Bruce Momjian wrote: >> > postmaster forks() and does not do an exec(). >> >> >From postmaster log: >> >> FindExec: found "/usr/comset/dbase/bin/postgres" using argv[0] >> >> ps ax|grep pos >> >> 10665 ? R0:01 /usr/comset/dbase/bin/postgres main.comset.com polithit >> p

[ADMIN] user access to db restriction

Hi! Please explain me how to restrict user access to database? I mean to permit user to connect some db and prohibit to connect another. By default each user can connect any db and read scheme as minimum... Its not good in multiuser envirinment... SKiller -- Sergei Keler

[ADMIN] Encoding fails

Hi! I have pgsql 6.5.3 with multibyte support and PHP 3.0.5 linked to pgsql libraries dynamically. Sometimes php program receives strange data looks like "(digits)(digits)..." as query result. What is it??? ;-) SKiller -- Sergei Keler WebMaster of "ComSet" E-Mail: [EMAIL