Yes, that is true if you have the autovacuum setting enabled for the
database server. You can see the last auto vacuum and last auto analyze
timestamp values from pg_stat_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/21/07, Robert James <[EMAIL PROTECTED]> wrote:
I see in
I have been using PostgreSQL 8.2.3 under Redhat Enterprise Linux AS 4, but
when I tried to install the postgresql-plperl RPM I got a sequence of
dependency failures, and remedying them got me into an apparently infinite
loop of dependencies on libpq.so versions.
Try grabbing all the PostgreSQL R
On Mon, 26 Mar 2007, Tom Lane wrote:
"Robert James" <[EMAIL PROTECTED]> writes:
I'm getting this error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for relation
pg_ts_dict
pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE
Jesse Cleary <[EMAIL PROTECTED]> writes:
> This script has been running successfully for several months (70-90 min each
> night). Out of the blue I'm now getting the following error message after
> each psql command, except the last vacuum full analyze command:
> ERROR: could not create relati
On Mon, Mar 26, 2007 at 04:37:59PM +0200, Serguei Pronkine wrote:
> How can I now retrieve column number from column name?
Query pg_attribute.
http://www.postgresql.org/docs/8.2/interactive/catalog-pg-attribute.html
Since psql can display object comments you could study the SQL that
it executes:
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
>I have to manage an application written in java which call another module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Postgres. The problem is that for large amounts of data the application
> throws an:
> org.p
"Jaro" <[EMAIL PROTECTED]> writes:
> I'd like create several users and several databases, ever user should
> be root only for own database
Anyone who is superuser in any database can certainly override any
restrictions you might think to put on him. (Hint: he can get at
the filesystem.)
If you r
"Matthijs Melissen" <[EMAIL PROTECTED]> writes:
> I am executing the following queries (id has a unique key):
> 1) begin;
> 1) delete from forum where id = 20;
> 1) insert into forum (id, name) values (20, 'test');
> 2) delete from forum where id = 20;
> 1) commit;
> The problem is that process 2
I am executing the following queries (id has a unique key):
1) begin;
1) delete from forum where id = 20;
1) insert into forum (id, name) values (20, 'test');
2) delete from forum where id = 20;
1) commit;
If you do these side by side in interactive psql sessions, you'll see that the
process
"Robert James" <[EMAIL PROTECTED]> writes:
> I'm getting this error:
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: permission denied for relation
> pg_ts_dict
> pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE
> Is there anyway I can do a pg_
On Mar 21, 11:36 am, [EMAIL PROTECTED] ("Bill Eaton") wrote:
> I want to allow some queries for my users to run for a prescribed period of
> time and kill them if they go over time. Is there a good way to do this? Or
> is this a bad idea?
>
> I've been struggling with trying to figure out the best
Hi everyone,
I'm still in the design phase of a project. I was just wondering if
anyone has any thoughts or experience on the idea of cutting the P out
of the LAMP (or in my case, WAMP for now) stack. What I mean is
having
everything encapsulated into sql (or plpgsql or plperl where needed)
func
I have been using PostgreSQL 8.2.3 under Redhat Enterprise Linux AS 4, but
when I tried to install the postgresql-plperl RPM I got a sequence of
dependency failures, and remedying them got me into an apparently infinite
loop of dependencies on libpq.so versions. I had versions 3 and 4 in
/usr/lib a
Hi everyone,
I heard Firebird has database-wide triggers, and I've seen mention of
them on this newsgroup here and there. Is that on the map for
implementation in pgsql?
Thanks,
Kev
---(end of broadcast)---
TIP 3: Have you checked our extensive F
Hello!
I have to manage an application written in java which call another module
written in java which uses Postgre DBMS in a Linux environment. I'm new to
Postgres. The problem is that for large amounts of data the application
throws an:
org.postgresql.util.PSQLException: ERROR: ou
In article <[EMAIL PROTECTED]>,
Martin Gainty <[EMAIL PROTECTED]> wrote:
% Assuming your schema will be pg_temp_1
Not a particularly reasonable assumption...
% vi InitialTableDisplayStatements.sql
% select * from pg_tables where pg_namespace = 'pg_temp1';
pmcphee=# select * from pg_tables wher
In article <[EMAIL PROTECTED]>,
Joris Dobbelsteen <[EMAIL PROTECTED]> wrote:
% Could people for once treat bugs as unacceptable instead an accepted
% thing?
It seems like you're responding to someone who's saying precisely
that he considers bugs unacceptable and doesn't want to introduce
them int
Hi community,
I'd like to retrieve comments on tables an columns by table name and
column name. The posting by Tom Lane pa ( dot ) us>
http://archives.postgresql.org/pgsql-novice/2004-01/msg00180.php?adv=1
says how to select comment on a column.
regression=# create table mytab (mycol int);
CREA
Sorry...are you asking something or sharing what works well for a
certain purpose?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
I see in all the docs to run VACUUM ANALYZE periodically. My host told me
that in Postgres 8.2 this is not needed as it is done automatically.
Is that true? How can I see the results of the automatic vacuum analyze? Or
configure them?
Hello
How create something like this:
UserName: user1 (he's root db_user1)
DatabaseName db_user1
UserName: user2 (he's root db_user2)
DatabaseName db_user2
I'd like create several users and several databases, ever user should
be root only for own database
Could anybody show my SQL example ho
On 23 Mar, 19:32, [EMAIL PROTECTED] wrote:
thanks Margaret, I didn't know window scheduler so far.
By the way I have choosen to do all management stuff on database via
command line programs, providing passowd file for administrator user.
Thanks
Filippo
---(end of broad
I am executing the following queries (id has a unique key):
1) begin;
1) delete from forum where id = 20;
1) insert into forum (id, name) values (20, 'test');
2) delete from forum where id = 20;
1) commit;
Queries marked with 1) are executed by process 1 and queries marked with 2)
are executed
I'd like to run pg_dump on a database that I have full
read/write/create/drop access to, but am not running as psql.
I'm getting this error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for relation
pg_ts_dict
pg_dump: The command was: LOCK TABLE public
On Mar 26, 2007, at 5:19 PM, Yang wrote:
On 3/26/07, A.M. agentm-at-themactionfaction.com |postgresql|
<...> wrote:
On Mar 26, 2007, at 19:29 , Yang wrote:
>
> The environments involve two small devices - one with a flash disk
> (the NFS server), and a slave which network-boots off that. Hen
"Yang" <[EMAIL PROTECTED]> writes:
> On 3/26/07, Hannes Dorbath light-at-theendofthetunnel.de |postgresql|
>>> However, I am primarily concerned with safety/recoverability (on sudden
>>> power loss);
>>
>> Well then.. forget about NFS :)
> Could you offer any explanation as to why?
Basically, t
"Ale Raza" <[EMAIL PROTECTED]> writes:
> Same results with -O0 option.
Hmmm ... I guess I should have stopped to read the code a little closer:
>> Breakpoint 1, ST_Geometry_Recv (fcinfo=0xbfffcb90) at binary.c:138
>> 138 StringInfo src_buf = (StringInfo)
> PG_DETOAST_DATUM(PG_GETARG_D
On Mar 26, 2007, at 5:24 PM, Dmitry Koterov wrote:
Hello.
I need to perform a mass operation (UPDATE) on each table row. E.g.
- modify one table column:
UPDATE tbl SET tbl_text = MD5(tbl_id);
The problem is that if this table contains a number of indices,
such UPDATE is very very slow on
On 3/26/07, A.M. agentm-at-themactionfaction.com |postgresql|
<...> wrote:
On Mar 26, 2007, at 19:29 , Yang wrote:
> On 3/26/07, Hannes Dorbath light-at-theendofthetunnel.de |postgresql|
> <...> wrote:
>> There is GFS2, OCFS, DRBD, ENBD, iSCSI, AoE and a ton of other
>> technologies. What on ea
On 3/26/07, Hannes Dorbath light-at-theendofthetunnel.de |postgresql|
<...> wrote:
There is GFS2, OCFS, DRBD, ENBD, iSCSI, AoE and a ton of other
technologies. What on earth is the point in trying to use a DBMS over
NFS? :)
In case it's just for the fun of it, maybe consider:
- davfs2
- curlftpf
Yang wrote:
> This has been discussed before (some URLs below), but the threads
> have unfortunately been rather free of (precise) information. I am
> interested in getting PG running over NFS. However, I am primarily
> concerned with safety/recoverability (on sudden power loss); I care
> very, ver
Hello.
I need to perform a mass operation (UPDATE) on each table row. E.g. - modify
one table column:
UPDATE tbl SET tbl_text = MD5(tbl_id);
The problem is that if this table contains a number of indices, such UPDATE
is very very slow on large table.
I have to drop all indices on the table, th
I want two users to execute the following queries:
1) delete from forum where id = 'A';
1) insert into forum (id, name) values ('A', 'testa');
2) delete from forum where id = 'A';
2) insert into forum (id, name) values ('A', 'testb');
id is a unique key. The numbers designate the user (1 and 2)
There is GFS2, OCFS, DRBD, ENBD, iSCSI, AoE and a ton of other
technologies. What on earth is the point in trying to use a DBMS over
NFS? :)
In case it's just for the fun of it, maybe consider:
- davfs2
- curlftpfs
However, I am primarily concerned with safety/recoverability (on sudden power
Ron-
If you're in the design phase and you're thinking about Which users should have
access to which pages/resources (and consequently DB resources)
The simplest mechnism is to implement a True Portal Management System based on
predefined acls/roles/group and users can then be created will have a
On Mon, Mar 26, 2007 at 09:38:07PM +0200, Alain Roger wrote:
> Hi,
>
> I wrote a function which should update a table field.
> However, i would like somehow to control that update was done.
> for that i was thinking to return a boolean : true is update was done, false
> if an error happened.
I be
I usually have a DBA available to me, but have to "wing it" this time...
I know what I =want=. What I don't know is ?how? to do it?
I want to set up a web app to have access privileges that allow the
app to communicate only with certain
a= pg stored procedures or
b= java servlets which then t
roger-
you need an exception block as in...
CREATE OR REPLACE FUNCTION sp_a_005("login" "varchar", pwd "varchar")
RETURNS boolean AS
$BODY$
BEGIN
UPDATE...
EXCEPTION
WHEN NO_DATA_FOUND
RETURN FALSE
WHEN PROGRAM_ERROR
RETURN FALSE
WHEN OTHERS
RETURN FALSE
RETURN TRUE
END;
-
Hi,
I wrote a function which should update a table field.
However, i would like somehow to control that update was done.
for that i was thinking to return a boolean : true is update was done, false
if an error happened.
however, i can i do that ? I mean how can i know if UPDATE has been
correctl
Hi PG Listers,
Postgres newbie here with a DB maintenance problem. I'm running a nightly
maintenance script on a PG database with ~50 tables and ~2.8 million rows
distributed rather unevenly across those tables. It is updated hourly with
7-10k new rows per hour.
Every night I run a bash scr
On Tue, Mar 06, 2007 at 11:12:12PM -0800, Saumitra Bhanage wrote:
> i have some queries about replication of data from one postgresql.. but by
> some different approch.
> as a small summry of my project,
> I am working on a project of replication of data. and I have done with
> kernel module
Hi all,
This has been discussed before (some URLs below), but the threads have
unfortunately been rather free of (precise) information. I am
interested in getting PG running over NFS. However, I am primarily
concerned with safety/recoverability (on sudden power loss); I care
very, very little abo
i have some queries about replication of data from one postgresql.. but by some
different approch.
as a small summry of my project,
I am working on a project of replication of data. and I have done with kernel
module programming in kernel 2.6 that has two machines A and B, when i update
any
Yes other than max_connections. I have a read-only user whose connections
need to be limited to a number far less than max_connections. Unfortunately,
I cannot upgrade to latest version of the portgres since the newer ones has
the support.
-Original Message-
From: Jim Nasby [mailto:[EMAIL
On Mon, Mar 26, 2007 at 01:02:46PM +0300, Peter Petrov wrote:
> Hi all,
>
> PostgreSQL version: 8.2.0 on Linux xeonito 2.6.19.3 #1 SMP Mon Feb 12
> 18:57:16 EET 2007 i686 i686 i386 GNU/Linux
> Slackware 11.0.0
>
> Memory parameters from postgresql.conf:
> shared_buffers = 512MB
> work_mem = 128M
Hi all,
PostgreSQL version: 8.2.0 on Linux xeonito 2.6.19.3 #1 SMP Mon Feb 12
18:57:16 EET 2007 i686 i686 i386 GNU/Linux
Slackware 11.0.0
Memory parameters from postgresql.conf:
shared_buffers = 512MB
work_mem = 128MB
maintenance_work_mem = 512MB
max_fsm_pages = 1638400
effective_cache_size =
am Mon, dem 26.03.2007, um 15:45:07 +0700 mailte Luki Rustianto folgendes:
> Hi All,
>
> Is there is a way to log every SQL query on potgresql server and also
> their execution time?
Yes.
log_statement = 'all'
log_min_duration_statement = 0
(postgresql.conf)
Andreas
--
Andreas Kretschmer
Ko
Hi All,
Is there is a way to log every SQL query on potgresql server and also
their execution time?
I need to find which query that eat CPU resource. Applications
connected to this server are from PHP and VB client.
Thanx.
---(end of broadcast)---
48 matches
Mail list logo
