> -Original Message-
> How can I create a role and some reestrictions on it?
> The case is that I have many databases and thousands of
> users, I need to
> create users and these users can only connect to only one
> database and no
> more.
>
> Please help me.
>
Hello Sidar!
Perhaps
How can I create a role and some reestrictions on it?
The case is that I have many databases and thousands of users, I need to
create users and these users can only connect to only one database and no
more.
Please help me.
_
Char
Bummer, it looks like there isn't any good solution for the case of
identical user and group names. You might want to search through the
archives to see if this scenario was discussed when roles were being
designed, but it looks like your best bet is to rename either the user
or the group before du
[EMAIL PROTECTED] wrote:
> Which version of pg_dump did you use to dump the old database? The
> recommended procedure is to use the newer version of pg_dump (ie:
> pg_dump from 8.1.1) to dump the old database. It's possible that the
> newer version of pg_dump has facilities in place to deal with th
Which version of pg_dump did you use to dump the old database? The
recommended procedure is to use the newer version of pg_dump (ie:
pg_dump from 8.1.1) to dump the old database. It's possible that the
newer version of pg_dump has facilities in place to deal with this.
Those facilities would obviou
I loaded a 7.4.x dump into a new 8.1.1 database and found out what happens
if you had the same name as both a user and a group. You can get users with
more rights than they had before. I guess it is too late, but perhaps a
mention in the release text would have been a good idea. Advise people to
r
Try :
./psql -d template1
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 5:25 AM
To: Michael Long
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Users and multiple server environment
Michael Long <[EMAIL PROTECTED]> writes:
> ./psql
Obviously not :-(. This should be pointing to /usr/local/pgsql_8.0b3/lib/
so it seems you didn't do the rpath enabling correctly; or maybe your
system is configured in a way that overrides rpath (do you have
LD_LIBRARY_PATH set in your environment?).
Yay!! When I set LD_LIBRARY_PATH then thing
Michael Long <[EMAIL PROTECTED]> writes:
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
> Is psql linked to the proper libraries?
> ldd /usr/local/pgsql_8.0b3/bin/psql
> libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)
Obviously not :-(. This
Quoting Michael Long <[EMAIL PROTECTED]>:
>
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
>
> Is psql linked to the proper libraries?
>
> --This is version 7.3.2
Below looks okay.
> ldd /usr/bin/psql
> libpq.so.3 => /usr/lib/libpq.so.3 (0x40
I would recommend "make distclean", reconfigure, rebuild whenever you
change configure arguments. That's the only way to be really sure the
changes propagate to everywhere they need to.
Tom, I followed your recommendation and rebuilt postgres after doing
"make distclean". I still get the foll
Michael Long <[EMAIL PROTECTED]> writes:
> The when configuring 8.0b3 I thought that I had specified to use the
> rpath style link, although now that I look at the string again, maybe not :)
> ./configure --prefix=/usr/local/pgsql_8.0b3 --disable-rpath
Looks like not ...
> How do I go about so
This looks like a 7.4 psql trying to use a pre-7.4 libpq.so. You need
to take a close look at where you've installed the different libpq
generations and how this matches up to the ldconfig search path.
Personally I like to use rpath-style link specifications to ensure that
a particular psql gener
Michael Long <[EMAIL PROTECTED]> writes:
> Further investigation shows that I was not using the newly built psql
> binary. When attempting to use the newly built binary I get an error.
> Did I miss something during the configure/make dance. Here is what I get.
> ./psql -U proporg
> ./psql: relo
Michael Long wrote:
You're missing something. Check which port you are actually talking to.
I do this all the time --- my development machine standardly has half a
dozen postmasters running on it, one for each major release 7.0-current.
They do not impinge on each other at all. It helps to build
Michael Long <[EMAIL PROTECTED]> writes:
> I had just discovered that I need to specify the port when creating a
> database. I had thought that I had read in the documentation that if I
> built the server from source and specified the port to use that the
> client would be bound to that by defau
You're missing something. Check which port you are actually talking to.
I do this all the time --- my development machine standardly has half a
dozen postmasters running on it, one for each major release 7.0-current.
They do not impinge on each other at all. It helps to build each
release from s
Michael Long <[EMAIL PROTECTED]> writes:
> I now have 2 versions of postgres running on one box (7.3.2 and 8.0b3)
> each listening on a different port. When creating a database, user or
> schema in 8.0 that exists in 7.3.2 I get an error saying it already
> exists. Can I have only one of each o
Hi all,
I now have 2 versions of postgres running on one box (7.3.2 and 8.0b3)
each listening on a different port. When creating a database, user or
schema in 8.0 that exists in 7.3.2 I get an error saying it already
exists. Can I have only one of each of these per server or am I missing
somet
Cardoso Patrick wrote:
Hi,
Is it possible to know the number of users connected to a database ?
select * from pg_stat_activity.
I'm not sure about permissions you need for it, try.
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 9: the plan
On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
> Hi,
>
> Is it possible to know the number of users connected to a
> database ?
>
> Regards
>
>
select * from pg_stat_activity;
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---
Hi,
Is it possible to know the number of users connected
to a database ?
Regards
On Tue, Jun 10, 2003 at 10:53:50 -0300,
Julian <[EMAIL PROTECTED]> wrote:
> Hi all, i'm new in postgres and this question may be very easy, but i need
> to do this so here it goes.
> I have one user in my database, and i need to create 10 more users to
> connect to de database but they must use
Hi all, i'm new in postgres and this question may be very easy, but i need
to do this so here it goes.
I have one user in my database, and i need to create 10 more users to
connect to de database but they must use the tables defined in the first
user but i can not use user.table. how can i do th
How can i list the users of a group?
Thanks.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> ... However, the complementary process, determining all the
>> users in group administrators, isn't so clean.
Tom> Doesn't select grolist from pg_group where groname =
Tom> 'adm
Raj Mathur <[EMAIL PROTECTED]> writes:
> ... However, the complementary process, determining
> all the users in group administrators, isn't so clean.
Doesn't
select grolist from pg_group where groname = 'administrators'
do it for you? I suppose you might want the thing to map sysids
back
Hi,
Using PostgreSQL 7.2.3 on a Linux box and facing some minor issues
with determining which groups users belong to.
I have created a PgSQL group called `administrators'. Now when I need
to check whether user X is a member of that group, I use the
contrib/array_iterator operator to do something
ber 06, 2002 8:36 AM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [ADMIN] USERS
> >
> >
> > Thank you very much.
> >
> > I have follow the instruction.
> > I start postmaster like that:
> > pg_ctl start -D /var/lib/pgsql
to try the pgsql-php mailing list.
>
> -Nick
>
> > -Original Message-
> > From: fred [mailto:fred@;skyturn.net]
> > Sent: Wednesday, November 06, 2002 8:36 AM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [ADMIN] USERS
>
to try the pgsql-php mailing list.
-Nick
> -Original Message-
> From: fred [mailto:fred@;skyturn.net]
> Sent: Wednesday, November 06, 2002 8:36 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] USERS
>
>
> Thank you very much.
>
>
-Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of fred
> > Sent: Wednesday, November 06, 2002 4:41 AM
> > To: [EMAIL PROTECTED]
> > Subject: [ADMIN] USERS
> >
> >
> > Hello,
> >
&g
EMAIL PROTECTED]
> Subject: [ADMIN] USERS
>
>
> Hello,
>
> I'm new on the list.
> I have to use the sgbdr postgres for my work.
> Everything is ok 'localy' but I have permissions trouble by tcp.
> Is someone now good docs about the users man
Hello,
I'm new on the list.
I have to use the sgbdr postgres for my work.
Everything is ok 'localy' but I have permissions trouble by tcp.
Is someone now good docs about the users management whith postgres ?
Thank's a lot for your support.
---(end of broadcast)---
Hi,
Can I know how many session I have?
Ex: mysql
SHOW PROCESSLIST;
oracle
select from v$_sessons;
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Luis Sousa writes:
> Is it possible to see what users are logged into the database using
> version 7.1 ??
The ps command gives you an idea. You can also look into the logs to see
who connected when. Neither of these is ideal, admittedly.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkt
Is it possible to see what users are logged into the database using
version 7.1 ??
Luis Sousa
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On 13-Dec-00 Peter Eisentraut wrote:
> Michael B. Babakov writes:
>
>>
>> On 12-Dec-00 Ross J. Reedstrom wrote:
>> > It's encoded in the process environment, so the 'ps' command will
>> > give you what you want:
>>
>> Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't write
>> u
Michael B. Babakov writes:
>
> On 12-Dec-00 Ross J. Reedstrom wrote:
> > It's encoded in the process environment, so the 'ps' command will
> > give you what you want:
>
> Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't write user
> in 'ps' command.
> I'm use FreeBSD 4.2.
Does
On 12-Dec-00 Bruce Momjian wrote:
>> On Tue, Dec 12, 2000 at 10:25:43PM +0300, Michael B. Babakov wrote:
>> >
>> > Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't write user
>> > in 'ps' command.
>> > I'm use FreeBSD 4.2.
>>
>
> It should be working. There is a configure f
> On Tue, Dec 12, 2000 at 10:25:43PM +0300, Michael B. Babakov wrote:
> >
> > On 12-Dec-00 Ross J. Reedstrom wrote:
> > > It's encoded in the process environment, so the 'ps' command will
> > > give you what you want:
> >
> > Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't wri
On 12-Dec-00 Ross J. Reedstrom wrote:
> It's encoded in the process environment, so the 'ps' command will
> give you what you want:
Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't write user
in 'ps' command.
I'm use FreeBSD 4.2.
I'm make:
1. In src/include/config.h:
#defi
On Tue, Dec 12, 2000 at 10:25:43PM +0300, Michael B. Babakov wrote:
>
> On 12-Dec-00 Ross J. Reedstrom wrote:
> > It's encoded in the process environment, so the 'ps' command will
> > give you what you want:
>
> Yes! For version < 7.0.2 it's right. After 7.0.2 postgresql don't write user
> in '
It's encoded in the process environment, so the 'ps' command will
give you what you want:
On my Debian linux box, I do something like:
reedstrm@cooker:~$ ps ax | grep '[/]postgres '
18737 ?S 0:02 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D /var/
Good day!
How to look what users work now with PostgreSQL?
--
Good luck,
Michael
---
e-mail: [EMAIL PROTECTED]
http://sochi.net.ru/~mike
Good day!
How to look what users work now with PostgreSQL?
Good luck,
Michael
---
e-mail: [EMAIL PROTECTED]
http://sochi.net.ru/~mike
Good day!
How to look what users work now with PostgreSQL?
Good luck,
Michael
---
e-mail: [EMAIL PROTECTED]
http://sochi.net.ru/~mike
--- Denis Pugnere <[EMAIL PROTECTED]> wrote:
>
> PG 7.0.2, RH Linux 6.2
>
> I'm trying to secure access to pgsql databases.
> the politic I use is to only allow access databases
> with passwords.
>
> for this, I use in pg_hba.conf :
> local all password
> host
- Original Message -
From: Anthony E. Greene <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 13, 2000 4:06 PM
Subject: Re: [ADMIN] users and passwords problem
> Denis Pugnere wrote:
> >
> > PG 7.0.2, RH Linux 6.2
> >
> > I'
Denis Pugnere wrote:
>
> PG 7.0.2, RH Linux 6.2
>
> I'm trying to secure access to pgsql databases.
> the politic I use is to only allow access databases with passwords.
>
> for this, I use in pg_hba.conf :
> local all password
> hostall 127.0.0.1
PG 7.0.2, RH Linux 6.2
I'm trying to secure access to pgsql databases.
the politic I use is to only allow access databases with passwords.
for this, I use in pg_hba.conf :
local all password
hostall 127.0.0.1 255.255.255.255 password
I don't
Hello.
I need some advice about users in postgress. I study man pages, howto and
web but I can not find how to create good privileges for users. I need to
create user with all rights to one database - where he could create and
drop tables, update and select from tables... In mysql it's easy
[EMAIL PROTECTED] said:
> I think we're pondering removing the secondary password file feature
> sometime;
The current system allows a particular user (in my case http) to connect to
the database olny from the unix domain socket and no where else. What ever system
is going to replace the secon
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> On Mon, 19 Jun 2000, R D wrote:
>
> > Hi,I need a secondary passwd files because I do
> not
> > know another way to manage user access to DBs.
>
> That's what I thought.
>
> > If there was a pg_shadow in every DB replacing
> external passwd fil
On Mon, 19 Jun 2000, R D wrote:
> Hi,I need a secondary passwd files because I do not
> know another way to manage user access to DBs.
That's what I thought.
> If there was a pg_shadow in every DB replacing external passwd file,
Hmm, that would be in semi-violation of SQL, since users are supp
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> R D writes:
>
> > 1. If I'm using different password files for
> each
> > database can I grant or revoke privileges to this
> > users without creating the same users in pg_user
> > table?
>
> No, you always have to use CREATE USER. Btw., I
> t
R D writes:
> 1. If I'm using different password files for each
> database can I grant or revoke privileges to this
> users without creating the same users in pg_user
> table?
No, you always have to use CREATE USER. Btw., I think we're pondering
removing the secondary password file feature som
Hi there,
i have few questions in users and droups in pgSQL that
i can't check in the next few days and this is
inportant in my choice of database:
1. If I'm using different password files for each
database can I grant or revoke privileges to this
users without creating the same users in pg_user
58 matches
Mail list logo