Re: [ADMIN] pg_hba, access control for a webserver, superuser, and joe user
On Tue, Jan 28, 2003 at 15:39:03 -0800, Jerry Asher <[EMAIL PROTECTED]> wrote: > > Does the order of statements in pg_hba.conf matter? > Is there a priority and a fallback of sorts? Try this first mechanism > and if that fails, try the next mechanism? Yes the order matters. Only the first rule that matches is used to do the authentication. If it fails no other rules are tried. For your kind of set up, you want to do the user specific rules first (postgres and the web user) followed by the wildcard rule for users connecting to a matching database. Here is a sample that I use that is similar to what you are trying to do. HBA: localall postgresident postgres localarea,book,cube,template1 bruno ident sameuser localarea,book nobodyident nobody localsameuserall ident sameuser IDENT: postgresrootpostgres postgresbruno postgres postgrespostgrespostgres nobody bruno nobody nobody nobody nobody ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] Just Make Sure
Dear Master; So There's no way to put the Begin Work, Commit Work or Rollback inside Trigger's Function... Some Explanation will be better :b GOD Bless You All. Yudha Setiawan.VoIP No. : 01119311223344
Re: [ADMIN] Just Make Sure
On Wed, 2003-01-29 at 09:20, Yudha Setiawan wrote: > Dear Master; > So There's no way to put the Begin Work, Commit Work or Rollback > inside Trigger's Function... > Some Explanation will be better :b No. All triggers happen within a transaction, whether explicit or implicit and transactions cannot be nested. In addition, BEGIN has a different meaning in PL/pgSQL. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "My son, if sinners entice thee, consent thou not." Proverbs 1:10 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] What filesystem works best for PostgreSQL?
I'm in the process of adding a new filesystem to our development server for Postgres data. I have been using ext3fs and ext2fs for PG databases and I haven't been impressed with the performance. So, has anyone out there benchmarked the various Linux filesystems for PG performance? More information: RH 7.3, 3 or 6 disk RAID5 (hardware). Kernel 2.4.19. Cheers! Bob -- Robert M. Meyer Sr. Network Administrator INSTALLS inc 14 Lafayette Sq, Ste 700 Buffalo, NY 14203-1904 (716)332-1451 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] What filesystem works best for PostgreSQL?
XFS seems to work pretty well. ext3 uses journaling which is very slow, xfs uses it as well but xfs tends to be faster overall. Try adding data =writeback to the mount parameters when using ext3 or xfs. I think this turns of journaling. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] What filesystem works best for PostgreSQL?
ext3/xfs by default journal the meta-data changes. You can turn this off in ext3 by simply mounting as ext2. On Wed, 29 Jan 2003 13:38:55 -0500 [EMAIL PROTECTED] wrote: > XFS seems to work pretty well. ext3 uses journaling which is very > slow, xfs uses it as well but xfs tends to be faster overall. Try > adding data =writeback to the mount parameters when using ext3 or xfs. > I think this turns of journaling. > > ---(end of > broadcast)--- TIP 4: Don't 'kill -9' the > postmaster ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] Database Management Setup
I am a new comer in this millis. Can you help me how to configure the postgreSQL server which has some databases. I mean 5 databses is spread to different hardisk. For example a_db to hda1, b_db to hdb1, etc... TIA Best regards Aris Wendy ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] Postgres server output log
Hi Everybody, I am new to postgresql. I started my postgres using the command postmaster -D /usr/local/pgsql/data > logfile 2>&1 & Now after running it for some time I noticed that the size of this logfile has become very large. Is this logfile used to store any important information used by the database for recovery in case of crash? If no,is there any way I can specify a different log file withouting stopping the server ? Any help is appreciated. Thanks, TarunDo you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: [ADMIN] Postgres server output log
This is someones' elses' posting that i have preserved
shud be useful.
regds
mallah.
~`
Well,
the most correct way to do a logrotate is ( Redhat ):
1) Put on your postgresql.conf the following lines:
syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
2) Put on the directory /etc/logrotate.d a file called
'postgres' with the following lines:
/var/log/postgresql.log {
compress
rotate 2
size=1k
errors [EMAIL PROTECTED]
create 0664 postgres postgres
daily
postrotate
/usr/bin/killall -HUP syslogd
endscript
}
change the email address of course :-)
3) Put the following line on your /etc/syslog.conf
# Save postgresql logs
LOCAL0.*
/var/log/postgresql.log
Ciao
Gaetano
---
On Thursday 30 January 2003 10:21 am, Mintoo Lall wrote:
> Hi Everybody,
>
> I am new to postgresql. I started my postgres using the command
>
> postmaster -D /usr/local/pgsql/data > logfile 2>&1 &
>
> Now after running it for some time I noticed that the size of this logfile
> has become very large. Is this logfile used to store any important
> information used by the database for recovery in case of crash? If no,is
> there any way I can specify a different log file withouting stopping the
> server ?
>
> Any help is appreciated.
>
> Thanks,
>
> Tarun
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--
Regds Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)26152172 (221) (L) 9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
