raghu ram-4 wrote
>>
> If you are executing the SQL statement with "postgres" user
> [Superuser],then you will see all information related to all objects
> without any restrictions of the Ownership.
>
> If you are executing the SQL Statements with "saas" user
> [Non-Superuser],then you will see th
Salvatore Barone wrote
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema |Nome| Tipo | Proprietario |
> Dimensione | Descrizione
> ++-+
2013/8/23 Salvatore Barone
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema |Nome| Tipo | Proprietario | Dimensione
> | Descrizione
>
> ++-+
2013/8/23 Salvatore Barone
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema |Nome| Tipo | Proprietario | Dimensione
> | Descrizione
>
> ++-+
This is the output of \d from psql. I logged in as "ssaa"
Lista delle relazioni
Schema |Nome| Tipo | Proprietario |
Dimensione | Descrizione
++-+--++-
publ
On Fri, Aug 23, 2013 at 8:12 AM, Salvatore Barone wrote:
> I'm not stupid,
>
No one said you were. These lists see people of a wide range of skillsets
and expertise. In this case it might not be the answer for your issue, but
David's suggestion might help someone else having a similar problem i
I'm not stupid, I added some columns before sending the query. I'm
trying to write a query that returns the name and other information
about the columns of a database. the query that is sent is the following
select * from information_schema.columns col
where col.table_schema!='pg_catalog'and
col.t
On Fri, Aug 23, 2013 at 8:02 AM, Salvatore Barone wrote:
> On 23/08/2013 16:57, bricklen wrote:
>
> select *
> from information_schema.columns
> where table_schema not in ('information_schema','pg_catalog')
>
> Both queries, whether to send as user "ssaa", ie the user that I use
> daily, return
On 23/08/2013 16:57, bricklen wrote:
> select *
> from information_schema.columns
> where table_schema not in ('information_schema','pg_catalog')
Both queries, whether to send as user "ssaa", ie the user that I use
daily, return an empty table. If sending as user "postgres" instead,
they return the
Salvatore Barone wrote
> Hi all,
> I created a database named "test" with the user "postgres" and I have
> given all privileges on database "test" to a user that I use daily,
> called "ssaa".
> By submitting, as user "ssaa", to "test" database the «select * from
> information_schema.columns with wh
On Fri, Aug 23, 2013 at 7:49 AM, Salvatore Barone wrote:
> Hi all,
> I created a database named "test" with the user "postgres" and I have
> given all privileges on database "test" to a user that I use daily, called
> "ssaa".
> By submitting, as user "ssaa", to "test" database the «select * from
Hi all,
I created a database named "test" with the user "postgres" and I have
given all privileges on database "test" to a user that I use daily,
called "ssaa".
By submitting, as user "ssaa", to "test" database the «select * from
information_schema.columns with where col.table_schema! = 'Pg_catalog
On Fri, Jul 26, 2013 at 9:01 PM, Luis wrote:
> Hi, I have a doubt about stats reset.
>
> I've been investigating some zero values in some tables tuples stats.
> By querying pg_stat_database view I can see reset times (pg_stat_database)
> that have not been performed by me (doing a SELECT pg_stat_
Hi, I have a doubt about stats reset.
I've been investigating some zero values in some tables tuples stats.
By querying pg_stat_database view I can see reset times (pg_stat_database)
that have not been performed by me (doing a SELECT pg_stat_reset())
My question is, what other actions or events m
On Wed, May 22, 2013 at 6:14 AM, Albe Laurenz wrote:
> Rodrigo Barboza wrote:
> > I have a doubt.
> > I have a 32-bit postrgesql running with 2.5gb of shared_buffer.
> > And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3.
> > How maintenance_work_mem is related to shared_buffer?
Rodrigo Barboza wrote:
> I have a doubt.
> I have a 32-bit postrgesql running with 2.5gb of shared_buffer.
> And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3.
> How maintenance_work_mem is related to shared_buffer?
> If the 3 workers uses 1gb, will the database crash?
> Or their
On Tue, May 21, 2013 at 1:03 PM, Amit Langote wrote:
> On Wed, May 22, 2013 at 12:07 AM, Rodrigo Barboza
> wrote:
> > Hi, everyone.
> > I have a doubt.
> > I have a 32-bit postrgesql running with 2.5gb of shared_buffer.
> > And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3.
> >
On Wed, May 22, 2013 at 12:07 AM, Rodrigo Barboza
wrote:
> Hi, everyone.
> I have a doubt.
> I have a 32-bit postrgesql running with 2.5gb of shared_buffer.
> And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3.
> How maintenance_work_mem is related to shared_buffer?
They are ind
Hi, everyone.
I have a doubt.
I have a 32-bit postrgesql running with 2.5gb of shared_buffer.
And I have maintenance_work_mem = 1gb and autovacuum_max_workers = 3.
How maintenance_work_mem is related to shared_buffer?
If the 3 workers uses 1gb, will the database crash?
Or their memory usage are sep
thx
Sent from my Verizon Wireless 4G LTE smartphone
Kevin Grittner wrote:
Benjamin Krajmalnik wrote:
> It is ok if I am a little bit behind. What setting do
> I need to tweak to allow it to get further behind?
The relevant settings are described here:
http://www.postgresql.org/docs/9.0/int
Benjamin Krajmalnik wrote:
> It is ok if I am a little bit behind. What setting do
> I need to tweak to allow it to get further behind?
The relevant settings are described here:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-wal.html#RUNTIME-CONFIG-REPLICATION
http://www.postgresq
It is ok if I am a little bit behind. What setting do I need to tweak to allow
it to get further behind?
-Original Message-
From: Kevin Grittner [mailto:kgri...@mail.com]
Sent: Thursday, January 17, 2013 4:32 PM
To: Benjamin Krajmalnik; pgsql-admin@postgresql.org
Subject: Re: [ADMIN
Benjamin Krajmalnik wrote:
> I have 2 servers which are using streaming replication (pg 9.0.4).
>
> The secondary server is there primarily as a disaster recovery server,
> but we are also using it for reporting, so as not to place undue load on
> the primary server.
>
> As I review the logs on
I have 2 servers which are using streaming replication (pg 9.0.4).
The secondary server is there primarily as a disaster recovery server,
but we are also using it for reporting, so as not to place undue load on
the primary server.
As I review the logs on the secondary server, I frequently see the
Good Evening,
Before tuning the hardware settings I usually execute an EXPLAIN to see the
execution path Postgres uses. A good start to understanding the EXPLAIN
functionality is here http://wiki.postgresql.org/wiki/Using_EXPLAIN .
Since you're using pgAdmin this is a better tutorial
http://www.
On Sun, Dec 9, 2012 at 7:01 AM, T.T Le wrote:
> Hello,
>
> We are running PostgresPlus 8.4AS on a linux system. I don't need to edit
> the config files or to restart the clusters (the DBA will do that for us). I
> only need access to help troubleshoot performance issues with the databases.
> My qu
On Sat, 08 Dec 2012 18:01:06 +, T.T Le wrote:
> Hello,
>
> We are running PostgresPlus 8.4AS on a linux system. I don't need to
> edit the config files or to restart the clusters (the DBA will do that
> for us).
> I only need access to help troubleshoot performance issues with the
> databases
Hello,
We are running PostgresPlus 8.4AS on a linux system. I don't need to edit
the config files or to restart the clusters (the DBA will do that for us).
I only need access to help troubleshoot performance issues with the
databases.
My question is: would pgAdmin be sufficient for what i need to
On 08/10/2012 12:20 PM, Tom Lane wrote:
Craig Ringer writes:
On 08/10/2012 10:06 AM, Tom Lane wrote:
That sure sounds like the source of your problem. It might be sane if
it killed only processes that *had been idle* for at least three
seconds, but I'm not sure there is any easy way to determ
Craig Ringer writes:
> On 08/10/2012 10:06 AM, Tom Lane wrote:
>> That sure sounds like the source of your problem. It might be sane if
>> it killed only processes that *had been idle* for at least three
>> seconds, but I'm not sure there is any easy way to determine that ...
> wouldn't:
> sele
On 08/10/2012 10:06 AM, Tom Lane wrote:
Greg Williamson writes:
Every minute on the minute there is a cronjob that kills IDLE IN CONNECTION
procs older than 3 seconds ... possibly that process killed the process I was
running, but to me the user it seemed as if the COMMIT came before the
dis
Greg Williamson writes:
> Every minute on the minute there is a cronjob that kills IDLE IN CONNECTION
> procs older than 3 seconds ... possibly that process killed the process I was
> running, but to me the user it seemed as if the COMMIT came before the
> disconnect.
That sure sounds like the
Tom, et. al.,
>
> From: Greg Williamson
>To: Tom Lane
>Cc: "pgsql-admin@postgresql.org"
>Sent: Thursday, August 9, 2012 5:35 PM
>Subject: Re: [ADMIN] Question about ALTER TABLE DROP CONSTRAINT on 9.1
Tom --
>
><...>>
>> WTF? That should certainly not happen. Have you perhaps got a script
>> that runs around sending SIGTERM to backends that it thinks are blocking
>> something? Does anything show up in the postmaster log when this
>> happens?
>
>No, we have
Greg Williamson writes:
> We have a small database (few hundred megs of data, lass than half that in
> indexes) that suffers from index bloat. Currently we handle this with an
> hourly REINDEX command. This works but causes some small issues, so I have
> been expploring other methods.
> When I
We have a small database (few hundred megs of data, lass than half that in
indexes) that suffers from index bloat. Currently we handle this with an hourly
REINDEX command. This works but causes some small issues, so I have been
expploring other methods.
When I try to to drop constraints (typica
Am 08.06.2012 05:43, schrieb sgm:
Dear admin,
I have a question about PITR backup in a single server, the method is
make a base backup, and backup the WAL archive log(eg, every day at
11:30 pm). But if the OS' harddisk is broken(eg,14:00 pm),the system
can't start, we have to recover the data
sgm wrote:
> I have a question about PITR backup in a single server, the method
> is make a base backup, and backup the WAL archive log(eg, every
> day at 11:30 pm). But if the OS' harddisk is broken(eg,14:00
> pm),the system can't start, we have to recover the database on a
> another server usi
Dear admin,
I have a question about PITR backup in a single server, the method is make a
base backup, and backup the WAL archive log(eg, every day at 11:30 pm). But if
the OS' harddisk is broken(eg,14:00 pm),the system can't start, we have to
recover the database on a another server using the ba
> -Original Message-
> From: Evan Rempel [mailto:erem...@uvic.ca]
> Sent: Wednesday, December 07, 2011 1:12 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: Chris Hoover; pgsql-admin@postgresql.org Admin
> Subject: Re: [ADMIN] Question about multiple slaves and Master
rad (Toronto, ON, CA) wrote:
*From:* pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] *On Behalf Of *Chris Hoover
*Sent:* Wednesday, December 07, 2011 12:05 PM
*To:* pgsql-admin@postgresql.org Admin
*Subject:* [ADMIN] Question about multiple slaves and Master loss.
I&#
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Chris Hoover
Sent: Wednesday, December 07, 2011 12:05 PM
To: pgsql-admin@postgresql.org Admin
Subject: [ADMIN] Question about multiple slaves and Master loss.
I'm pretty sure that the answer to
I'm pretty sure that the answer to this question is no, but I wanted to
verify.
Given the following scenario (pg 9.0):
Server A (Master), Server B (A's streaming replication Slave), Server C
(A's streaming replication Slave)
If you lose Server A, is there anyway to promote Server B to master and
I am having an issue wrapping my head around ident auth. In particular I
always run afoul of the first match wins aspect of the pg_hba.conf. To
help clarify I am using postgres 8.4 with the new ident syntax where
"sameuser" is now implied.
What I would like to do is to use "ident" auth for local
Chris,
Here is what I installed.
postgresql91-9.1.0-2PGDG.f15.x86_64
postgresql91-devel-9.1.0-2PGDG.f15.x86_64
postgresql91-contrib-9.1.0-2PGDG.f15.x86_64
postgresql91-libs-9.1.0-2PGDG.f15.x86_64
postgresql91-server-9.1.0-2PGDG.f15.x86_64
and here is the output of pg_config
[pgarner@localhost
Hi Patrick,
Which pre-built packages (i.e. OS, flavor, architecture, etc...) are you
asking about?
In most cases, you can check the output of pg_config to see if it was
built with "--with-gssapi". You may need to install the PostgresQL
development packages, depending on your environment.
Hope t
Are the pre-built binary packages built with support for GSSAPI
authentication?
Are the pre-built binary packages built with support for GSSAPI
authentication?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On 21/08/2011 11:07 PM, A J wrote:
So I assume there is no redundant information stored such as checksum
to validate the files against the stored checksums.
Nope, there are no checksums.
It's the storage subsystem's job to make sure it doesn't mangle data on
disk and reads the data as it was
: A J
Cc: PG Admin
Sent: Friday, August 19, 2011 2:40 AM
Subject: Re: [ADMIN] Question on Postgres Index internals
On 19/08/2011 5:46 AM, A J wrote:
How does Postgres detect corruption of index data files ?
If their structure doesn't make sense, they're corrupt. It doesn't acti
On 19/08/2011 5:46 AM, A J wrote:
How does Postgres detect corruption of index data files ?
If their structure doesn't make sense, they're corrupt. It doesn't
actively seek or detect corruption, because it shouldn't happen, and
cannot be reliably discovered if it has.
What is the exact mechani
How does Postgres detect corruption of index data files ? What is the exact
mechanism by which it knows that the index is corrupt ? Can it happen that part
of the index is corrupt but Postgres does not realize because those specific
rows are not accessed (but other rows from that table are acces
I would use task manager to check if PostgreSQL is actually running. If it
is I would disable the firewall, if it's not I would check if the data
directory is empty, and look at the PostgreSQL and windows logs.
It's also odd that you see [host "???"], I would expect it to be [host
"127.0.0.1"] mayb
Dear list
I face with some problem in installation PostgreSQL 8.3 on winXP , long time
before I used PostgreSQL and PostGIS for managing shape file data. Last week I
tried to install PostgreSQL 8.4, after that I removed PostgreSQL 8.3 (I only
uninstalled inside windows control panel/add and the
hello ...
read this:
ERROR: type "number" does not exist
we don't have this type.
use numeric or whatever matches.
many thanks,
hans
On May 11, 2011, at 2:46 PM, Hsien-Wen Chu wrote:
> ERROR: type "number" does not exist
--
Cybertec Schönig & Schönig GmbH
Gröhrmü
Hi Hans
Many many thanks, I have executed the SQL, how ever, it does not work,
I don't know what's wrong
tora=# select * FROM odbclink.query(1, 'SELECT * FROM test') as
result(user_name text,score number);
ERROR: type "number" does not exist
LINE 1: ...SELECT * FROM test') as result(user_name
hello ...
in SQL this "*" has to be known at parsing time ... so, it needs the number /
type of columns before doing anything else.
as you select "some" data from oracle (the postgres parser does not look into
the oracle sql) you have to tell the system which data to expect.
it is somehow like t
hello ...
oh, it seems you did not get that one:
select * FROM odbclink.query(1, 'SELECT * FROM test') as result(user_name
text,score number);
give it a try ;).
hans
On May 11, 2011, at 12:24 PM, Hsien-Wen Chu wrote:
> Hi Hans
>
> many thanks for the answer,
>
> my table structur
Hi Hans
many thanks for the answer,
my table structure on Oracle, but I still get error as following,
Please could show me the correct SQL statement?
many many thanks
Hsien-Wen
SQL> desc test;
Name Null?Type
--
Dear All
I have a question regarding to odbc link,
I had a PostgreSQL database and an Oracle database, now I have created
a dblink to Oracle database base on odbc link.
in Oracle database, I created a user named ORATEST, and create a table
named TEST as ORATEST user.
SQL> select user_name,sco
On Mar 16, 2011, at 4:37 AM, wrote:
> When I start the second cluster and log into it with psql, it tells me that
> the database is still v9.0.1 in parentheses.
This means you have used PG9.0.1 Binary to start the database.
Please update your Startup script to use 9.0.2 Binaries.
Thanks
Greetings!
We are running multiple clusters for development and test purposes. I was
experimenting, as a PostgreSQL newbie, with upgrading from v9.0.1 to v9.0.2.
I noticed that the installation of v9.0.2 did upgrade the default (original)
cluster as part of the process.
When I start the secon
anypossibility wrote:
> I am running postgres and data directory is on network volume.
Unless you are using a SAN *and* really know what you're doing,
that's not generally a good idea.
> When postgres try to recover from the crash it has no access to
> storage.
If it couldn't reach any par
I am running postgres and data directory is on network volume.
postgres version 8.3
Server Crashed: 10:00 pm
Last known up: 9:30 pm (from log)
Checkpoint_Segments setting = 3 (conf)
When postgres try to recover from the crash it has no access to storage.
Once storage volume is re-connected:
There w
> when I create a user "user1" and give this user the permissions on
> a database "db1" (including login privilage),
>
> this user can access all databases although it doesn't have the privilges
> (even after implmenting the revoke command)
>
> on the other hand, any user can access the database "
hsienwen chu wrote:
> the situation is that: I have a table, and the size is about 10M,
> I run the database on Redhat Linux platform. for OS, a IO can hand
> 1M data, the file system block is 4k, database block is 8k,
>
> my question is that: when do the full table scan on the table, how
> man
Dear all
the situation is that: I have a table, and the size is about 10M, I run the
database on Redhat Linux platform. for OS, a IO can hand 1M data, the file
system block is 4k, database block is 8k,
my question is that: when do the full table scan on the table, how many IO
will be done? 10M/1M
On Tue, Sep 28, 2010 at 5:31 PM, osman mohamad wrote:
> when I create a user "user1" and give this user the permissions on
> a database "db1" (including login privilage),
>
> this user can access all databases although it doesn't have the privilges
> (even after implmenting the revoke command)
>
when I create a user "user1" and give this user the permissions on
a database "db1" (including login privilage),
this user can access all databases although it doesn't have the privilges
(even after implmenting the revoke command)
on the other hand, any user can access the database "db1"
after lo
Anibal David Acosta wrote:
Windows server enterprise has the Microsoft Cluster Services.
This enable fail-over scenario between two computers.
So, when one of them go offline, the other is activated, this involve
many steps, including IP changing, the slave become the master IP
address .
everything running and working in aprox. 10 seconds.
De: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] En nombre de Kasia Tuszynska
Enviado el: viernes, 17 de septiembre de 2010 07:30 p.m.
Para: pgsql-admin@postgresql.org
Asunto: [ADMIN] question about HA in
Kasia Tuszynska wrote on 18.09.2010 01:30:
1. The doc is lovely but all of the examples are for linux, has
anyone tired a Hot Standby streaming scenario on windows? Any issues
specific to windows? I know that linux and windows environments
“should” behave the same but actually running in both of
Kasia Tuszynska wrote:
The doc is lovely but all of the examples are for linux, has anyone
tired a Hot Standby streaming scenario on windows? Any issues
specific to windows? I know that linux and windows environments
"should" behave the same but actually running in both of those
environmen
Hi Everybody,
I am doing a bit of research about High Availability solutions offered as part
of core in Postges 9.0, I have couple of questions, sorry if they expose my
novice status where it comes to HA on Postgres:
1. The doc is lovely but all of the examples are for linux, has anyone
ti
"Benjamin Krajmalnik" writes:
> As a result, I have decided to partition the table and add to each record a
> partition id, which can be used to route it to the correct partition.
>
> Presently, all of the records reside on what will ultimately become the
> parent partition.
>
> What would be th
On Wed, Jan 13, 2010 at 7:30 PM, Radhika Sambamurti wrote:
>
> Hi,
> I am currently looking into partitioning a table of which 90% of the lookups
> are for the prior week. It has about 9 million rows and selects are a bit
> slow, since the table is joined to two other tables. I am planning on
Scott Marlowe wrote:
On Wed, Jan 13, 2010 at 6:11 PM, Benjamin Krajmalnik wrote:
Yes, I will be using table inheritance and inheriting the current table where
the data resides.
I was wondering if it would be "kosher" to perform the insert on itself, but I
guess since the rules engine tak
On Wed, Jan 13, 2010 at 6:11 PM, Benjamin Krajmalnik wrote:
> Yes, I will be using table inheritance and inheriting the current table where
> the data resides.
> I was wondering if it would be "kosher" to perform the insert on itself, but
> I guess since the rules engine takes over there should
You are always very helpful.
> -Original Message-
> From: Scott Marlowe [mailto:scott.marl...@gmail.com]
> Sent: Wednesday, January 13, 2010 5:58 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Question on moving data to new partit
On Wed, Jan 13, 2010 at 5:51 PM, Benjamin Krajmalnik wrote:
> I have some tables which have an extremely high amount of update activity on
> them. I have changed autovacuum parameters (cost delay and limit), and
> whereas before they would never be vacuumed and bloat they are running fine.
>
> Ho
I have some tables which have an extremely high amount of update
activity on them. I have changed autovacuum parameters (cost delay and
limit), and whereas before they would never be vacuumed and bloat they
are running fine.
However, as the platform scales, I am afraid I will reach the same
situa
Adam Tucker wrote:
> I'm interested in having live replication from one server to another, and
> I've looked into many of the options out there but I'm unclear on one part of
> it. The way our database works is that each individual user account has
> their own schema. When a new user signs up,
On Mon, 2009-12-07 at 13:29 -0500, Adam Tucker wrote:
> I'm interested in having live replication from one server to another, and
> I've looked into many of the options out there but I'm unclear on one part of
> it. The way our database works is that each individual user account has
> their own
I'm interested in having live replication from one server to another, and I've
looked into many of the options out there but I'm unclear on one part of it.
The way our database works is that each individual user account has their own
schema. When a new user signs up, a new schema is created an
"John Lister" wrote:
> When you do a vacuum it marks the deleted rows as being usable
> again and I can see that it reports that "xxx index row versions
> were removed", however are these rows marked for reuse in an index
> in the same manner as they are in the table? I note that the docs
> say
Hi, excuse my ignorance, but I have a couple of quick questions regarding
vacuuming and indexes.
When you do a vacuum it marks the deleted rows as being usable again and I
can see that it reports that "xxx index row versions were removed", however
are these rows marked for reuse in an index in
"Mark Steben" writes:
> Is it possible that, during startup, postmaster.pid takes a second or two to
> be created and hadn't been created yet when the test was run?
It's not instantaneous, for sure. For one thing, the kernel could be
scheduling the postmaster at lower priority than the continue
Hi folks, were running Postgres 8.2.5 and Linux Redhat.
I run a cron script to start our server using pg_ctl after I copy the data
cluster over from a replicated server.
To test the start success / failure I test for the presence of
postmaster.pid in the cluster.
This weekend, the server started s
On Fri, Feb 27, 2009 at 4:42 AM, Lentes, Bernd
wrote:
>
>
> Scott Marlowe wrote:
>> -Ursprüngliche Nachricht-
>> Von: Scott Marlowe [mailto:scott.marl...@gmail.com]
>> Gesendet: Freitag, 27. Februar 2009 11:04
>> An: Lentes, Bernd
>> Cc: pgsql-admi
Scott Marlowe wrote:
> -Ursprüngliche Nachricht-
> Von: Scott Marlowe [mailto:scott.marl...@gmail.com]
> Gesendet: Freitag, 27. Februar 2009 11:04
> An: Lentes, Bernd
> Cc: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] Question to transaction ID wraparound
>
&
> -Ursprüngliche Nachricht-
> Von: Scott Marlowe [mailto:scott.marl...@gmail.com]
> Gesendet: Freitag, 27. Februar 2009 11:04
> An: Lentes, Bernd
> Cc: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] Question to transaction ID wraparound
>
> On Wed,
On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
wrote:
> Hello ML,
>
> I'm very new to Postgres.
> In the log, i got messages concerning transaction ID wraparound.
> I red the documentation and made a vaccum on that database.
> In the documentation i also found the hint to look in the database with
Cc: pgsql-admin@postgresql.org
>> Betreff: Re: [ADMIN] Question to transaction ID wraparound
>>
>> On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
>> wrote:
>> > Hello ML,
>> >
>> > I'm very new to Postgres.
>> > In the log, i got mess
Scott Marlowe wrote:
> -Ursprüngliche Nachricht-
> Von: Scott Marlowe [mailto:scott.marl...@gmail.com]
> Gesendet: Donnerstag, 26. Februar 2009 18:18
> An: Lentes, Bernd
> Cc: pgsql-admin@postgresql.org
> Betreff: Re: [ADMIN] Question to transaction ID wraparound
&
On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
wrote:
> Hello ML,
>
> I'm very new to Postgres.
> In the log, i got messages concerning transaction ID wraparound.
What exact message did you get?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscripti
Amit Jain wrote :
Its a log analyzer tool through which you can trap the running
queries and have reports about update/delete/insterts which are
executing at database system.
http://pgfouine.projects.postgresql.org/
Lentes, Bernd wrote:
Its a log analyzer tool through which you can trap the running queries
and have reports about update/delete/insterts which are executing at
database system.
http://pgfouine.projects.postgresql.org/
Lentes, Bernd wrote:
Lee Azzarello wrote:
Sometimes the number grows by 5 in one second.
I
Lee Azzarello wrote:
> > Sometimes the number grows by 5 in one second.
> > I'm also astonished about the fact that all databases grow
> by the same amount.
> > Do you have any explanations for this behaviour ?
> > Why are the numbers growing so quickly ?
>
> What kind of work load is on the da
On Wed, Feb 25, 2009 at 5:05 AM, Lentes, Bernd
wrote:
> Hello ML,
>
> I'm very new to Postgres.
> In the log, i got messages concerning transaction ID wraparound.
> I red the documentation and made a vaccum on that database.
> In the documentation i also found the hint to look in the database with
Hello ML,
I'm very new to Postgres.
In the log, i got messages concerning transaction ID wraparound.
I red the documentation and made a vaccum on that database.
In the documentation i also found the hint to look in the database with
"SELECT datname, age(datfrozenxid) FROM pg_database;", which i di
1 - 100 of 277 matches
Mail list logo
