Re: [ADMIN] User permissions
On Thu, 16 Mar 2000, Mike Edwards wrote: > I am using PostgreSQL with PHP/Apache. PHP connects to Postgres as > Linux user "nobody" (the user running the Apache daemon) unless a > username and password is explicitly supplied. But I would like to let > user "nobody" connect to a database not owned by "nobody". Connection to databases is not governed by the ownership of the database but rather by the file pg_hba.conf in your data directory. The file is sufficiently self-explanatory so I suggest you take a look. (You'll see what I mean with that.) > can I restrict access with read-write vs. read-only privledges? Read and write privileges are done on a per table basis via grant and revoke. See manual entries. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden
Re: [ADMIN] postgres ate my server
> Hi! > > I've been running postgres for an online sports service for some > months now. Everything has worked quite smoothly, but this morning > something strange happend. > > Two postgres processess started by the webserver each reached over > 300M in size and slowed the machine down to a crawl. They had been > running for a couple of minutes, after i killed them everything > went back to normal. > > When i look into the pglog i see about 400 of these around the time of the > event: > > FATAL: pq_endmessage failed: errno=32 > pq_flush: send() failed: Broken pipe > We've had this on one of our development systems (SuSE 6.3) last week - but we do not try to look for the reason Marten
[ADMIN] lower/upper case
select * from books where titulo like '%perl%'; select * from books where titulo like '%Perl%'; in This querys, postgres return diferents registers, but i need return the same registers... what i doing? regards. jcmd
Re: [ADMIN] lower/upper case
who knows other form its a script in Perl, this script search in my db, but if the client put "Perl", the matches its diferent whit "perl". One form its substutions upper/lower in the script of perl, but i dont like very much. Anyone??? Thanks On Fri, 17 Mar 2000, Mini-Me wrote: > use > > select * from books where titulo ~* perl or Perl or PERL > > it returns a regex expression. > > angel > > At 04:35 PM 3/17/00 -0600, you wrote: > > > >select * from books where titulo like '%perl%'; > > > >select * from books where titulo like '%Perl%'; > > > > > >in This querys, postgres return diferents registers, but i need return > >the same registers... what i doing? > > > >regards. > >jcmd >
[ADMIN] HELP! Just built 6.5.3 and it bombs on initdb
Hi, Just built and installed 6.5.3 on Sparc/Linux and it bombs during an initdb with the following spew: initdb: creating template database in /local/db0/postgresql/base/template1 Running: postgres -boot -C -F -D/local/db0/postgresql -Q template1 syntax error 2334 : parse error Creating global classes in /base Running: postgres -boot -C -F -D/local/db0/postgresql -Q template1 Adding template1 database to pg_database... Running: postgres -boot -C -F -D/local/db0/postgresql -Q template1 < /tmp/create.18674 ERROR: pg_atoi: error in "template1": can't parse "template1" ERROR: pg_atoi: error in "template1": can't parse "template1" initdb: could not log template database initdb: cleaning up. WTF? Did I do something wrong here? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] "Linux renders ships http://www.berghold.net NT renders ships useless"