On 06/20/2016 03:18 AM, Job wrote:
> Hello,
>
> we have a table with an heavy traffic of pg_bulkload and delete of records.
> The size pass, in only one day, for example for 1Gb to 4Gb and then 1Gb back.
>
> We have important problems on size and the only way to gain free space is
> issueing a v
On 05/23/2014 08:57 AM, Vincent de Phily wrote:
> I need to reduce downtime to a minimum, so I can't afford to let "alter table
> set tablespace" take an exclusive lock on the table for the 2h it'll take to
> copy the data.
You might look at pg_repack (https://github.com/reorg/pg_repack). The
m
On 11/17/2013 11:48 PM, David Johnston wrote:
> I am guessing that it is the need for the index to point to new versions of
> the physical record that the index is churning so much and causing this kind
> of bloat?
Bingo.
> I am preparing to REINDEX the unique index and DROP the non-unique one ov
On 05/22/2013 08:49 AM, RDNikeAir wrote:
> I have a database that is on a RAID5 machine that is almost out of memory
> (277GB of 330GB used). I have deleted some data and run the VACUUM FULL
> command, but after a few hours gave me the error message "Server closed the
> connection unexpectedly. Th
On 01/20/2013 11:17 PM, bhanu udaya wrote:
> I am trying to restore 9.5G database (1GB dumpfile) which has 500
> schemas with 1 lakh rows in each schema. Could take the data dump using
> pg_dump and it takes around 40 minutes. I tried to use pg_restore to
> restore this dump, but it takes hours to
On 01/13/2013 03:44 PM, Gavin Flower wrote:
I would tend use Fedora for development, but would consider CentOS (or
RHEL, if we had the budget) for production - I avoid Ubuntu like the plague.
I happen to be doing my own research on this matter. I tend to lean
more toward RHEL or CentOS for pr
On 10/19/2012 08:06 AM, GMAIL wrote:
> Il 19/10/2012 16:05, Chris Ernst ha scritto:
>> On 10/19/2012 07:50 AM, GMAIL wrote:
>>> Il 19/10/2012 15:40, Chris Ernst ha scritto:
>>>> On 10/19/2012 07:24 AM, GMAIL wrote:
>>>> What happens when you try
On 10/19/2012 07:50 AM, GMAIL wrote:
> Il 19/10/2012 15:40, Chris Ernst ha scritto:
>> On 10/19/2012 07:24 AM, GMAIL wrote:
>> What happens when you try to connect? Any error message? Log entries?
>> - Chris
> now i be able to connect, after update pgAdmin, but i recei
On 10/19/2012 07:24 AM, GMAIL wrote:
> Il 19/10/2012 15:24, Chris Ernst ha scritto:
>> On 10/19/2012 07:02 AM, GMAIL wrote:
>>> I have 2 cluster databases, running on the same host, Ubuntu. My fist
>>> database port is set to default but my second database por
On 10/19/2012 07:02 AM, GMAIL wrote:
> I have 2 cluster databases, running on the same host, Ubuntu. My fist
> database port is set to default but my second database port is set to
> 5433 in the postgresql.conf file. While everything is ok with local
> connections, I cannot connect using any of my
On 10/10/2012 09:56 AM, Bruce Momjian wrote:
> Can you show me what is in the PG_VERSION file in the old cluster? It
> should be "9.1".
Hi Bruce,
Thank you for the reply. Indeed it is "9.1":
# cat /postgresql/9.1/main/PG_VERSION
9.1
And just for good measure:
cat /postgresql/9.2/main/PG_VERS
Hi all,
I'm trying to test using pg_upgrade to go from 9.1.6 to 9.2.1 on Ubuntu
server 10.04. But when I run pg_upgrade, it tells me I can only run it
on 8.3 or later.
Old:
postgres=# SELECT version();
version
-
On 09/26/2012 10:42 AM, SUNDAY A. OLUTAYO wrote:
> This IF last_id IS NULL THEN suppose to test if last_id is NULL, that is
> the select query did not found it
> then execute the rest of the red sql but it always fail to insert the
> *NEW.amount *into*amount*, every other things fine.
I believe wh
On 05/23/2012 07:11 AM, Herouth Maoz wrote:
> Hi guys,
>
> I'm interested in a solution that will allow our customers to run reports -
> which may involve complicated queries - on data which is as up-to-date as
> possible.
>
> One thing I don't want to do is to let the reporting system connect
Hi Hannes,
You can't use streaming replication, but you can use slony to replicate
between different architectures.
- Chris
On 09/20/2011 02:26 PM, Hannes Erven wrote:
> Hi folks,
>
>
> I'm planning to set up streaming replication from one master to one
> slave. I've read at
> http://www.pos
On 05/01/2011 07:37 PM, gvim wrote:
> I've been looking through the Date/Time functions and operators on the
> docs and can't find anything obvious to do this simple task - filter a
> date column for entries which are later than a specified date.
>
> gvim
>
Try "WHERE date > '2011-04-01'" replaci
Well.. the "quick and dirty" start would be:
SELECT * FROM pg_stat_activity;
As for a good management tool, I would recommend pgAdmin3:
http://www.pgadmin.org/
- Chris
On 01/29/2010 12:34 PM, Gauthier, Dave wrote:
> Hi:
>
>
>
> PG V8.3.4 running on Linux.
>
>
>
> I have a D
SELECT * from pg_stat_user_indexes;
On 01/07/2010 02:23 PM, akp geek wrote:
> Hi All -
>
> Is there way to the list of indexes created for all the tables
> in postgres? can you please help
>
>
> Regards
> Venkat
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Ahmad,
Do you have something monitoring PostgreSQL by connecting to port 5432
(or whatever you have it listening on) such as Nagios or Zenoss?
- Chris
Ahmad Rumman wrote:
> I am getting WARNING at log file:
>
> Jan 6 11:19:54 dev04 postgres[14624]: [1622-1] DEBUG: name: unnamed;
> blo
Easy mistake to make
The repo RPM version is 8.4-1 <-- note the hyphen. This is the repo for
all 8.4 versions, including 8.4.2.
Install the proper repo RPM for your platform and then you can just yum
install (or upgrade) PostgreSQL 8.4.2.
To browse the files in the 8.4 repo, try:
http://yu
Dimitri Fontaine wrote:
> Le 19 déc. 2009 à 16:20, Chris Ernst a écrit :
>
>> Hmm.. That does look very interesting. The only thing that concerns me
>> is where it says it supports "Basic Queries (Extended queries not yet
>> supported)". I'm not sure wh
t out.
- Chris
Filip Rembiałkowski wrote:
>
> Tsung [http://tsung.erlang-projects.org/] has a nice pg proxy module. It
> records your "query stream" and is able to replay it later.
>
>
>
> 2009/12/18 Chris Ernst mailto:cer...@esoft.com>>
>
>
Greg Smith wrote:
> Chris Ernst wrote:
>> I started writing my own log parser to pull the statements from the
>> postgres logs, but as I get in to the details, it's not quite as
>> straight forward as I had thought. Keeping track of which client
>> connections ha
Rory Campbell-Lange wrote:
> On 18/12/09, Chris Ernst (cer...@esoft.com) wrote:
>> I have a project where I need to be able to capture every query from a
>> production system into a file such that I can "replay" them on a staging
>> system. Does such a thing
Hi all,
I have a project where I need to be able to capture every query from a
production system into a file such that I can "replay" them on a staging
system. Does such a thing already exist or should I start writing my
own log parser?
Thank you for your help.
Chris Ernst
25 matches
Mail list logo
