; and schemaname
= 'public';
relname | n_live_tup | n_dead_tup | last_vacuum |
last_autovacuum
-+++---+-
file| 47424031 | 4662 | 2013-05-31 11:43:14.681605-04 |
(1 row)
I did not
time
checking any changes even with very little changes. Maybe I miss some
option when using rsync can speed up the update.
--
Best regards,
Alex Lai
a...@sesda2.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
On Fri, Jul 29, 2011 at 03:39, Rohan Kadam wrote:
> Hi All,
>
> I have currently upgraded our database from postgres 8.2 to 9.0. When trying
> to restore my old database dump taken form 8.2 version(using pg_dumpall), I
> observed that my timezone is getting changed and getting set to GMT instead
>
On Thu, Feb 10, 2011 at 03:24, Sam Stearns wrote:
> Thanks, Norbert!
>
> I'll run the perl 5.10 upgrade past the guys.
>
> Sam
>
> On Thu, Feb 10, 2011 at 6:27 PM, Norbert Zacharias
> wrote:
perl -V
>>> Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
>>
>> May be an
2011/1/12 Achilleas Mantzios :
>
> Changed that to smth like: micros_total = micros_total + (double) micros;
> instead of the printf to beat any compiler optimization, and still linux runs
> at light speed:
> FBSD_TEST : user 0.089s, sys 1.4s
> FBSD_DEV : user 0.183s, sys 3.8s
> LINUX_PROD : user
On Tue, Aug 24, 2010 at 07:36, Tom Lane wrote:
> I can see how "access to" might be read as specifically meaning "CONNECT
> privilege for". Should we change this message from "access to whatever"
> to "privileges for whatever", or some such wording?
+1, There have been a few times I found that m
On Wed, Jul 28, 2010 at 15:43, Irene Barg wrote:
> Alex,
> The postmaster wouldn't start with shared_buffers = 5632MB, so we reduced it
> to 2GB. The system's shared memory is:
>
>> [dpp...@pipen18 ~]$ sudo /sbin/sysctl -a | grep kernel | grep shmmax
>> kernel
On Tue, Jul 27, 2010 at 15:58, Irene Barg wrote:
> I'm afraid I don't understand how turning on 'log_temp_files' will help?
Well, postgres is probably doing exactly what its told. You just need
to figure out what that is and why. ( and if it is some kind of bug,
we wont be able to do anything ab
On Mon, Jul 26, 2010 at 16:01, Irene Barg wrote:
>> 2010-07-26 11:33:33 MST system_admin metadataERROR: could not write block
>> 503414 of temporary file: No space le
>> ft on device
>> 2010-07-26 11:33:33 MST system_admin metadataHINT: Perhaps out of disk
>> space?
>> -bash-3.2$ df -h
>> Files
On Sun, Jun 20, 2010 at 10:36, Elior Soliman wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid). Both
> servers are going to use the same DB fil
On Wed, May 19, 2010 at 06:30, Josi Perez (3T Systems)
wrote:
> To avoid to delete registers I created one trigger activated "before delete"
> with lines like that:
> UPDATE tableX set dtExc = 'now', userExc = current_user where idTableX =
> OLD.idTableX;
> return NULL;
>
> but, I need do the sam
this problem?
I also noticed that when I go to Dependencies and Dependents tabs in
pgAdmin3 - I get the "OID out of range" error. Not sure if this is
related to the jobs not running. Below is the error with the statement
from logs.
I appreciate any help
On Wed, May 19, 2010 at 16:25, ALEXANDER JOSE wrote:
> I have a question, I have postgres 8.2.5 on a windows server on another
> machine and I have suse linux enterprise 10 postgres 8.4, you perform a
> backup with pgadmin 1.10 to a database and restore the database in the
> version of postgres 8.
On Tue, Mar 30, 2010 at 04:16, Mike Williams wrote:
> Thanks Alex, good to know I've not screwed up the kernel somehow.
>
> I've been using 2.6.32 with grsecurity-2.1.14-2.6.32.9-201002231820 applied.
Looks like the first instance I had of this problem was with
2.6.31.1-rc1-gr
On Sun, Mar 28, 2010 at 16:27, Mike Williams wrote:
> Test are para-virt VMs with "regular" kernels, production are real
> machines with hardened kernels (grsec+pax).
Ive seen this error on a few boxes around here, using a non grsec
kernel fixes it. I never bothered to report it because I cant
r
On Wed, Mar 3, 2010 at 10:32, Dhimant Patel wrote:
> Hi All,
>
> I am working with latest source downloaded from postgres org site.
> I compiled and installed the source with --with-wal-segsize=2, assuming it
> should give me 4MB size xlog files. (As per the documentation it is a power
> of 2 valu
On Tue, Jun 10, 2008 at 2:46 PM, Dinesh <[EMAIL PROTECTED]> wrote:
> Hi Scott,
>
> Thanks for your reply.
>
> Is there a built in exception in pl/pgsql ( similar to oracle's
> |DUP_VAL_ON_INDEX ) that I can use?
>
> I ran into an unique situation a couple of days ago. Procedure that inserts
> a new
then. So they were not vacuumed for quite some
time.
Even without vacuuming, I don't think postgres should ever behave like this,
but I'm glad my problem is solved now.
(perhaps this issue is fixed in newer releases, if not someone might want to
look in to this pg_* tables/vacuum is
de
pg_catalog tables? is there a way to dump the pg_catalog tables?
The pgserver is running on a 4 CPU dell 6850 with 16G of Ram with Fedora Core 4
on a reiserfs filesystem without any problems for years. And nothing has
changed on the server side of things.
thanks,
alex.
--
Sent via pgsql-admin
de
pg_catalog tables? is there a way to dump the pg_catalog tables?
The pgserver is running on a 4 CPU dell 6850 with 16G of Ram with Fedora Core 4
on a reiserfs filesystem without any problems for years. And nothing has
changed on the server side of things.
thanks,
alex.
--
Sent v
On Mon, Jun 9, 2008 at 10:17 PM, Tommy Cheng <[EMAIL PROTECTED]> wrote:
> you are right. I double checked. So, is there any way to turn off auto index
> creation for the parent? (the best is changing postgresql database setting)
> I am using postgres (PostgreSQL) 8.1.9 on CentOS 5 x86_64
>
Again,
Don't 'kill -9' the postmaster
>
>
ALTER TABLE table ALTER COLUMN column DROP NOT NULL
See http://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
for more information about dropping constraints.
Alex Kloss
signature.asc
Description: OpenPGP digital signature
ename FROM pg_stat_activity WHERE datname='databasename'
There's many other connection statistics in pg_stat_activity as well,
such as IP address, current query...
Alex Rowe
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (GNU/Linux)
iD8DBQFHF9y3LGN3BhEHOicRAmOpAJ9ia+gYRRRJ
I am is Alex, and I m developing a product with PostgreSQL 8.1. I have a
problem. This problem is that i have some unique constraints with
multi-columns. The problem is that there is some that of the check
constraint condition that can be null. As it is described in section
5.3.3, null of one
8.1.4-1, but not heavily (my unsaved database was created by psql 7.4)
I don't know what I have to do next. What I do wrong?
-
Thank you
Alex. Karpov
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore y
Hi Guys,
Just wondering if there is a way to specify the priority that the PostgreSQL
server runs at on a Windows 2003 server as I want to raise the server
priority 1 notch to be above some other processes running on that machine?
Cheers
Alex Shepherd
---(end of
If you simply put your database tables in their own tablespace, then
move that tablespace to a WORM device, I can't see why that wouldn't
work as long as you keep all the system tables etc.. on the regular RW
tablespace
Alex Turner
netEconomist
On 5/11/05, [EMAIL PROTECTED] <[EM
I think simply initialising the system causes writes in the system
tables and the WAL...
I'm sure someone more knowledgeable can chime in.
Alex. Turner
netEconomist
On 5/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Why? Any specific reason that you are aware of ?
> Are
on on this system or must I only use known PostgreSQL Server
versions with particular OpenSSL versions?
Cheers
Alex Shepherd
Phone: (Mobile) +64 (21) 64
Phone: (Home) +64 (7) 854 0819
Email: [EMAIL PROTECTED]
---(end of broadcast)---
hello all,
i work in an organization that has a handful of people accessing a few ms
access database files. i'm strongly considering porting everything to
postgre (as the backend for access) for a number of obvious reasons, one of
the most prominent ones would be the availability of a back up v
think this puzzle is mostly solved - all we need to do now is
figured out what the heck happened on the controller card!
Thanks,
Alex Turner
On Thu, 10 Mar 2005 23:09:07 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Alex Turner <[EMAIL PROTECTED]> writes:
> > Well - I am so
is pretty low though).
Alex Turner
netEconomist
On Thu, 10 Mar 2005 19:04:29 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Alex Turner <[EMAIL PROTECTED]> writes:
> > I have a question about IO timeouts:
> > We are using the 3ware escalade 9500S series of cards, and we
wait 30 seconds before it decided
that the system was upset, and put the database in maintainence mode.
Is there a way to increase to IO wait timeout so this doesn't happen?
Alex Turner
netEconomist
---(end of broadcast)---
TIP 1: subscribe and uns
ers that shouldn't need to be declared in the
first place.
PS
My PostgreSQL version is 7.4.7.
Thanks,
-
Alex Gutman, EMC Corp. :: Tel (877) 362-2887 ext. 44962 :: Fax (508) 435-8852
---(end o
as user postgres when issuing the above CREATE OR
REPLACE RULE command, if it's of any relevance.)
Is there any way I could achieve my goal?
With thanks in advance,
Alex Gutman, grateful PostgreSQL user since 1998
---(end of broadcast)-
doing, and also reducing the amount of memory for Postgresql file
cache.
All in all, I would personaly be very wary of running both together if
you are planning on doing any benchmarking.
Alex Turner
NetEconomist
On Thu, 20 Jan 2005 10:20:02 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED
Hello all.
Please help,
are there any way to set some (ex. deny creating tables)
privileges on database (not for databases objects)?
I want crant full access to one user (let say "adminuser"
for database "testdb") and make some others (read only)
users,
who can read only (do SELECT from "testdb
The result is the same as a brown-out or black-out - power disappears, machine reboots.
Hope this helps prod someone's memory!
Alex
---(end of broadcast)---
TIP 8: explain analyze is your friend
t UPS as *well*, and keep the machine powered
at all times ;)
Alex
--
Mail: Alex Page <[EMAIL PROTECTED]>
Real: Systems/Network Assistant, Epidemiology Unit, Oxford
Tel: 01865 302 223 (external) / 223 (internal)
PGP: 8868 21D7 3D35 DD77 9D06 BF0A 0746 2DE6 55EA 367E
-
postings on the net
suggesting otherwise. Is there anything to pay attention too ?
Thanks for any advise
Alex
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes d
Thanks for your help!
> Alex Pollock
> WFSC Data Services District
> Database Administration
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 4:56 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] transactions in
Does pg_dump include all transactions that are committed before the hot
backup is finished in the database backup? If not, what transactions are
included in the hot backup?
Thanks!
Alex Pollock
WFSC Data Services District
Database Administration
---(end of broadcast
Does PostgreSQL have a tool to diagnose and fix database corruption? Is
there any kind of database consistency checker? I couldn't find anything in
the doc...
Thanks!
Alex Pollock
WFSC Data Services District
Database Administration
MAC A0186-032
( 415) 243
esort, you can probably restore from the dump of the table/database you
make nightly (rght?).
Alex
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
I'm trying to backup and restore database from DBname to DBname2 (e.g. copy
database. it is for example).
When i'm trying to use these commands :
#pg_dump -f DBname.tar -b -o -Ft DBname
#createdb DBname2
#pg_restore -Ft -d DBname2 -f DBname.tar
pg_dump works fine, but pg_restore produce thi
running with the "-i" flag.
I hope this helps.
Alex Saip
Systems Engineer
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 6:39 AM
Subject: remote access
> I would like to make a connection from a client on m
a lot !
--
_____
/ Alex Carlos Braga Antao\ /_ __\
| Analista de Sistemas|// ...on ICQ |
| | // |
| e-mail : [EMAIL PROTECTED] | /// _/ |
| http://www.prdf.mpf.g
tried to make manually the db's table, but pg_upgrade didn't
work. When I run it creates a tmp file but it stays empty. it seems that
the program is waiting for something. The postmaster is working.
Thanks for any help,
--
____ ___
48 matches
Mail list logo
