Hi ,
Look at pg_hba.conf file usually under /usr/local/pgsql/data .
regards
Omid Omoomi
>From: "Lau NH" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: [ADMIN] Database access right
>Date: Fri, 25 Jan 2002 13:39:14 +0800
>
>Hi all,
>Is there anyway to restrict the
Hi ,
Look at pg_hba.conf file usually under /usr/local/pgsql/data .
regards
Omid Omoomi
>From: "Lau NH" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: [ADMIN] Database access right
>Date: Fri, 25 Jan 2002 13:39:14 +0800
>
>Hi all,
>Is there anyway to restrict the
Hi all,
Is there anyway to restrict the
database owner to access only to his/her database? because if I assign the
dba right to the database owner, he/she will be able to access other databases
in the same server. Is there anyway to restrict that?
Regards,Lau NH
Chris Ruprecht <[EMAIL PROTECTED]> writes:
> I can not ask my SA, I AM the SA ;-). And there are no recognizable
> files in or around the /etc directory, I can modify. MacOS X has the
> sysctl command, but there is no kern.shmmax parameter to read or set.
> This is a MacOS X SPECIFIC question,
At 14:21 -0500 01/24/2002, Zhang, Anna wrote:
>You need to increase SHMMAX. For solaris, it's in /etc/system file; Linux:
>/etc/sysctl.conf. You should know corresponding file for your system or
>check with your SA to figure out.
I have this well under control on my production server (Linux) with
On Friday, January 25, 2002, at 06:47 PM, Chris Pesko wrote:
> Looking for a ERD tool that support pgsql. Anyone know of any?
There is one in pgaccess. You need tcl/tk.
Someone also mentioned a dia plugin as well, but I have never used it.
http://www.zort.ca/postgresql/
--
Best Regards
Da
Related question regarding this config file and some other suggestions in this
thread. I have a similar configuration that I'm constantly tuning based on my
experience and comments I read in various places. So far, based on what I
"learned" these parameters would seem way to high for 1GB configura
|On 020124 11:53
|Chris Pesko ([EMAIL PROTECTED]) wrote the following...
|
|Looking for a ERD tool that support pgsql. Anyone know of any?
http://techdocs.postgresql.org/oresources.php has some links to a few,
check out the Database Design section.
--
BOFH Reason of the day: We've picked COBOL
Looking for a ERD tool that support pgsql. Anyone know of any?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Luis Amigo wrote:
> I would keep an eye on backend's mem usage, don't let them get out of memory
> nor go to swap.
> I would consider increasing wal_files, i think postmaster is telling you every
> minute
Actually, checkpoint_segments is the critical parameter when you have
lots of activity and a
You need to increase SHMMAX. For solaris, it's in /etc/system file; Linux:
/etc/sysctl.conf. You should know corresponding file for your system or
check with your SA to figure out.
Anna Zhang
-Original Message-
From: Chris Ruprecht [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2
Hi guys,
does anybody know how I can increase the shared memory under MacOS X?
I have tried but gotten an error message, telling me that it's too
much. (PostgreSQL 7.2RC1).
Best regards,
Chris
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre
That helps a great deal! I am learning about the 'run-fast' option in
postgres: Increasing the shared_buffers is critical. Here is a copy of my
postgresql.conf file. I'll make the increases you suggested, but is there
anything else you can recomend?
Thanks again,
Peter
postgresql.conf:
#
I would keep an eye on backend's mem usage, don't let them get out of memory
nor go to swap.
I would consider increasing wal_files, i think postmaster is telling you every
minute
hope it helps
Regards
begin:vcard
n:Amigo Navarro;Luis Alberto
tel;cell:609581857
x-mozilla-html:FALSE
org:Universid
"Peter T. Brown" <[EMAIL PROTECTED]> writes:
> But how can Postgres be 'forced' to keep a table in memory? I've noticed
> that on our Dual Pentium4, 1GB RAM machine, the size of the individual
> postgres threads is very small. Top reports it as like 5K or 20K (I believe
> that's what it means). Sh
"Peter T. Brown" wrote:
> But how can Postgres be 'forced' to keep a table in memory? I've noticed
> that on our Dual Pentium4, 1GB RAM machine, the size of the individual
> postgres threads is very small. Top reports it as like 5K or 20K (I believe
> that's what it means). Shouldn't this number
But how can Postgres be 'forced' to keep a table in memory? I've noticed
that on our Dual Pentium4, 1GB RAM machine, the size of the individual
postgres threads is very small. Top reports it as like 5K or 20K (I believe
that's what it means). Shouldn't this number be 100's of MB if postgres is
pro
I think you have experienced data/index block corruption. First drop indexes
(if you have) and recreate them. if only index corrupts, you are lucky, this
will fix your problem. but if this won't work, it means that data block
corrupted, you may need to recovery your database using backup.
Above s
Hi,
Anyone have thoughts on how I might handle replication with 1 master and 2
slave databases (minimum)?
I am switching our political database from mysql to postgres and need a
solid way to replicate data from our internal server to our webserver. We
currently use 2 databases per server, o
Jean,
We are using a quad pentium xeon machine with 6 GB ram RH 7.1 enterprise
kernel. Postgres uses everything that is available. Actually, its only
idling with the hardware we have and we have tables with over 2M rows.
Your disk subsystem is very important as well as it can easily become a
bottl
Manuel Trujillo wrote:
> El jue, 24-01-2002 a las 09:27, Luis Amigo escribió:
> > On my own experience I will tell you that if you're able to force postgres
> > to keep all database in memory it will be very fast, so memory only depends
> > on your
> > database size.
> > Each backend may run on a
Sorry for inconvenience, but search engine is not working so maybe I'm
talking about this kind of error again.
I can't explain exactly what happenend but at certain point one of my
PostgreSQL database tables had stopped working.
The error is :
ERROR: cannot read block 3 from rel__modelo
Can it
On Thu, 2002-01-24 at 11:00, Manuel Trujillo wrote:
> El jue, 24-01-2002 a las 09:27, Luis Amigo escribió:
> > On my own experience I will tell you that if you're able to force postgres
> > to keep all database in memory it will be very fast, so memory only depends
> > on your
> > database size.
>
On Thu, 2002-01-24 at 10:02, Jean Huveneers wrote:
> Hi,
>
> Within an couple of weeks we will start using PostgreSQL on Mandrake 8.1
> in real business (we have been testing, for over a half year).
>
Not that i have anything against Mandrake, but it is a desktop
distribution. I've heard several
Hello !
This is a problem for the gurus, or maybe it's not even a problem...
Here goes :
I have a PostgreSql 7.2.b4 on a PIII with 128MB of ram, running RedHat
7.2 with a 2.4.9-13 kernel.
The system is running postgresql, Apache/PHP server, sshd, nfs and
cvspserver (CVS password-server).
I've set
El jue, 24-01-2002 a las 09:27, Luis Amigo escribió:
> On my own experience I will tell you that if you're able to force postgres
> to keep all database in memory it will be very fast, so memory only depends
> on your
> database size.
> Each backend may run on a different processor, so the more pr
Hi.
You can try something like this:
time psql template1 postgres -c "select usename from pg_user"
Cheers,
Florian
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Zhang, Anna
> Sent: Wednesday, January 23, 2002 10:25 PM
> To: [EMAIL PROTECTED]
Jean Huveneers wrote:
> Hi,
>
> Within an couple of weeks we will start using PostgreSQL on Mandrake 8.1
> in real business (we have been testing, for over a half year).
>
> In future we will have some tables with 100.000+ records an the system
> has te work very fast.
>
> I know that speed of qu
28 matches
Mail list logo
