Re: [ADMIN] Problem: PostgreSQL 6.5.1 backend crashing.

1999-08-03 Thread Anto Prijosoesilo
On Wed, 4 Aug 1999, Vadim Mikheev wrote: > Anto Prijosoesilo wrote: > > > > #0 0x16f62 in _bt_isortcmpinit () > > #0 0x16f62 in _bt_isortcmpinit () > > #1 0x13c3c in btgettuple () > > _bt_isortcmpinit couldn't be called from btgettuple!!! > This's static func in nbtsort.c used for index crea

Re: [ADMIN] Problem: PostgreSQL 6.5.1 backend crashing.

1999-08-03 Thread Vadim Mikheev
Anto Prijosoesilo wrote: > > #0 0x16f62 in _bt_isortcmpinit () > #0 0x16f62 in _bt_isortcmpinit () > #1 0x13c3c in btgettuple () _bt_isortcmpinit couldn't be called from btgettuple!!! This's static func in nbtsort.c used for index creation, not for querying. > Has anyone seen this problem? I

Re: [ADMIN] How to set up users etc for Web access?

1999-08-03 Thread Aaron Seigo
hi... >AOLserver uses a tcl API -- those files (*.tcl and *.adp) are also >chmod'd 600, as AOLserver does its own interpreting -- php may need >execute permission; I don't know. no, no special priveleges are needed for php, as long as they are readable by the web server, as all the interp happen

Re: [ADMIN] How to set up users etc for Web access?

1999-08-03 Thread Lamar Owen
> Gary Robertson wrote: [snip] > We are setting up a Web site using pgsql. I am unsure of which users I > should set up, & who should own the html & php3 files in our directory > etc. [snip] While I use AOLserver and not apache+php3, the concepts are similar: 1.) The httpd run user (which

[ADMIN] How to set up users etc for Web access?

1999-08-03 Thread Gary Robertson
We are setting up a Web site using pgsql. I am unsure of which users I should set up, & who should own the html & php3 files in our directory etc. The steps I have done so far:   I created a linux user for admin on this particular DB, called dbuser As user postgres, I ran "createuser dbuser"

[ADMIN] Problem: PostgreSQL 6.5.1 backend crashing.

1999-08-03 Thread Anto Prijosoesilo
Hi, I manage several databases on FreeBSD 2.2.8-STABLE and after upgrading to PostgreSQL 6.5.1 (from ports collection) I'm getting quite a few backend crashes. The applications running on the databases are real-time RADIUS authentication and accounting. There are 2 databases involved with one of

[ADMIN] damaged pg_log

1999-08-03 Thread Thomas Metz
Hi, while running a nohup & my disk filled up due to an unexpected amount of output in nohup.out. The job included lots of simple SELECT queries, but no changes in the data. Now the pg_log file seems to be damaged. If I try to vacuum the database I get the error: ERROR: cannot read b

Re: [ADMIN] Password protected databases and automated backups

1999-08-03 Thread Dmitry Morozovsky
On Tue, 3 Aug 1999, Herouth Maoz wrote: HM> > Yes, surely, I meant precisely this situation. I have looked through HM> > sources of pg_dump, but have no time to patch it to achieve desired HM> > effect :) HM> HM> I have a feeling your question is really "How do I have the password HM> entered if

Re: [ADMIN] Password protected databases and automated backups

1999-08-03 Thread Herouth Maoz
At 16:09 +0300 on 03/08/1999, Dmitry Morozovsky wrote: > This is not very useful solution, as the script shoud be readable at least > for owner -- but we can make simple C program, compile it and make > executable only (0100). I'm not sure how bad readability to the owner would be. Anyway, I wa

Re: [ADMIN] Password protected databases and automated backups

1999-08-03 Thread Herouth Maoz
At 00:53 +0300 on 03/08/1999, Dmitry Morozovsky wrote: > Yes, surely, I meant precisely this situation. I have looked through > sources of pg_dump, but have no time to patch it to achieve desired > effect :) I have a feeling your question is really "How do I have the password entered if there i