On 11/2/07, Campbell, Lance <[EMAIL PROTECTED]> wrote:
> Is there a way to log into PostgreSQL and determine how many database
> connections are in use?
Use pg_stat_activity.
See:
http://www.postgresql.org/docs/8.2/static/monitoring-stats.html#MONITORING-STATS-VIEWS
---(e
PostgreSQL: 8.2.4
I did the following query on my database:
select * from pg_stat_all_indexes;
My hope was to see if my indexes are being used. The values I got were
all 0's for the columns: idx_scan, idx_tup_read, and idx_tup_fetch.
Is there a different query to tell me how often
"Campbell, Lance" <[EMAIL PROTECTED]> writes:
> select * from pg_stat_all_indexes;
> My hope was to see if my indexes are being used. The values I got were
> all 0's for the columns: idx_scan, idx_tup_read, and idx_tup_fetch.
You aren't collecting these stats:
> #stats_block_level = off
> #stats
dx k9 <[EMAIL PROTECTED]> writes:
> Is there any way to trick an instance into starting when you just have base,
> global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc, & pg_twophase, but no
> pg_xlog?
pg_resetxlog would probably be enough to get it to start, but the odds
of having a non-corrup
On 02/11/2007, dx k9 <[EMAIL PROTECTED]> wrote:
>
> Hi Everyone,
>
> Is there any way to trick an instance into starting when you just have
> base, global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc, & pg_twophase,
> but no pg_xlog?
>
> We weren't backing up the pg_xlog, because we didn't thin
PostgeSQL: 8.2.4
I have a database XYZ that has a user, USER1. The database XYZ has many
schemas. I have 12 different web applications that connect to the
database XYZ. My hope was to create a different "role" for each
application.
I used the command "createuser" to create USER2. When I
Instead of using drop user username, I used drop user "username" with double
quotes, then the error message told me more detail about a specific user
defined function. Then I was able to drop that function, then drop this user.
My next question,
How do I check the ownership of the functions. I
Jessica Richard <[EMAIL PROTECTED]> writes:
> I am sure in the future there will be times that I need to check the
> ownership of the functions but not allowed to drop users to see check the
> dependencies.
There's no need for a separate operation for that. Do
begin;
drop user
Hi Everyone,
Is there any way to trick an instance into starting when you just have base,
global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc, & pg_twophase, but no
pg_xlog?
We weren't backing up the pg_xlog, because we didn't think we needed it, but
the backup_label seems to need it. Ev
I found the proper way to deal with this situation. No response is
necessary.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
From: Campbell,
I have installed pgpool from ports on a FreeBSD-6_STABLE box and have
hit a roadblock (pgpooladmin can see the two nodes but they're both
shown as "down"). Pretty sure it's an authentication error, but I've
added a 'host-all-all-user-trust' to each machine and it hasn't changed
anything. Is the
Hi,
after a disk-crash some weeks ago and a successful recovery, I now
find some strange issues in postgres.
I am not sure they are related to the crash, but I figure chances
are ...
One of them is: When trying to vacuum one database I get the following
message:
"ERROR: could not open r
Jessica Richard wrote:
> Instead of using drop user username, I used drop user "username" with
> double quotes, then the error message told me more detail about a
> specific user defined function. Then I was able to drop that function,
> then drop this user.
FYI you can use the commands DROP OWNED
Hi everybody,
I just created a new schema. Like this:
create schema newschema authorization foo;
Now I want to 3 other uses besides foo to be
able to create and drop tables/views/etc.
What I want to do would be something like:
grant create on newschema to x, y, z;
But it disagrees with me
Tena Sakai написа:
> Hi everybody,
>
> I just created a new schema. Like this:
>
> create schema newschema authorization foo;
>
> Now I want to 3 other uses besides foo to be
> able to create and drop tables/views/etc.
> What I want to do would be something like:
>
> grant create on newsch
Many thanks, Milen.
Tena
-Original Message-
From: [EMAIL PROTECTED] on behalf of Milen A. Radev
Sent: Fri 11/2/2007 5:18 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] schema privilege question
Tena Sakai ??:
> Hi everybody,
>
> I just created a new schema. Like this:
>
16 matches
Mail list logo
