On Thu, May 04, 2006 at 14:20:39 -0700,
Sriram Dandapani <[EMAIL PROTECTED]> wrote:
> Hi
>
>
>
> I have a scenario where I need to reset all sequences(about 400). Is
> there a system table that I can query to get a list of sequences
> (Postgres 8.1.x)
You can do something like:
select * from
Title: RE: [ADMIN] Tale partitioning
>BTW, I should have mentioned that partitioning is a very new feature and
>that folks probably would like to know about shortcommings you find
>while using it.
We just implemented partitioning, and have found it very useful for dropping old data, as oppos
Hi
I have a scenario where I need to reset all sequences(about
400). Is there a system table that I can query to get a list of sequences
(Postgres 8.1.x)
"Shivaji S" <[EMAIL PROTECTED]> writes:
> tom thanks for the input ,but the below queries doesn't support for my post=
> gres version 7.1.1
7.1.1? Egad. Update to something remotely modern, before it eats
your data. The list of bugs fixed since then would curl your toes.
See for yourself:
http:
On Thu, 2006-05-04 at 15:21, Shivaji S wrote:
> tom thanks for the input ,but the below queries doesn't support for my
> postgres version 7.1.1 it shows the error
>
> ERROR: Function 'pg_postmaster_start_time()' does not exist
> Unable to identify a function that satisfies the given argument typ
tom thanks for the input ,but the below queries doesn't support for my postgres version 7.1.1 it shows the error
ERROR: Function 'pg_postmaster_start_time()' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
Regards,
Shi
BTW, I should have mentioned that partitioning is a very new feature and
that folks probably would like to know about shortcommings you find
while using it.
On Thu, May 04, 2006 at 11:40:51AM -0700, Sriram Dandapani wrote:
> Thanks...looks like partitioning will help.
>
> -Original Message---
Thanks...looks like partitioning will help.
-Original Message-
From: Jim Nasby [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 11:37 AM
To: Sriram Dandapani
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Tale partitioning
Please include the mailing list in your replies so oth
Please include the mailing list in your replies so others can provide input.
> From: Sriram Dandapani [mailto:[EMAIL PROTECTED]
> Most of our reports use a order by limit X...The rowcount in
> some tables
> are > 200 million. (and the table size is about 50-100gb)
>
> Does the fact that constrai
If your backup file
still hit that limit even after being compressed, you may want to use the split
command to split it into chunks with the desired size that suit your
O/S.
Check out this
PostgreSQL doc page on handling large databases: http://www.postgresql.org/docs/8.1/interactive/backup
I think a better question to be asking yourself is: why are you using
seperate databases for all of this? It certainly sounds like all the
activities are related, so ISTM it would make a lot more sense to put
everything in one database and possibly use schemas to seperate things
logically.
On Thu,
You may use the
pg_stat_activity view to find out what's running on the database, ie. select *
from pg_stat_activity ;
You may also use the
pg_postmaster_start_time() function to find out postmaster startup time, ie.
select pg_postmaster_start_time() ;
Husam
http://firstdb
Hi,
Is there any command to find current running threads/queries on postgres.
and how to find the uptime of my database.Please guide me
Regards,
Shivaji
On Mon, May 01, 2006 at 06:25:49PM -0400, [EMAIL PROTECTED] wrote:
> I am using Postgres version 8.0.3. I have noticed that when I set the
> log_statement parameter to 'all', I get the values for the bind variables.
> Is it possible to get all of the same information that I get when I set
> lo
Jyry Kuukkanen wrote:
On Thu, 4 May 2006, Rodrigo Sakai wrote:
Hi, I'm trying to do a backup of a database that is larger then 4 GB. But it gets an error when the file size gets 1.2 GB! I think its an Operational System problem (linux)! So, I want to know if exists some solution
On Thu, 4 May 2006, Rodrigo Sakai wrote:
> Hi, I'm trying to do a backup of a database that is larger then 4 GB. But
> it gets an error when the file size gets 1.2 GB! I think its an Operational
> System problem (linux)! So, I want to know if exists some solution to backup
> my database??
>
Hi, I'm trying to do a backup of a database
that is larger then 4 GB. But it gets an error when the file size gets 1.2 GB! I
think its an Operational System problem (linux)! So, I want to know if exists
some solution to backup my database??
The command that I used was=
pg_dump -U po
I have two separate database applications running, one for the initial
Pre-Delivery preparation of new vehicles, and one for the final taxing and
delivery to customers.
These two systems were developed independently but are used by the same
people. Each of these databases has a user table, use
Hogan, James F. Jr. ha scritto:
> Can anyone point me in a direction that may help me populate in real
> time a table that holds?
>
> Current_user
> Timestamp
> "The Select Statement Submitted by the User"
>
> I would like to easily determine who viewed what and when they viewed
> it.
>
I think
19 matches
Mail list logo
