Hello all,
I want to set Auto vaccunme in such a way that it will start in the Mid night
(12:00 A.M.)
Is there any way to do this except Cron Job for Linux
Thanks In advance
With Regards
ashish ...
Alvaro Herrera wrote:
Bruce McAlister wrote:
I have just checked the pg_stat_all_tables in the pg_catalog schema and
I can see the index scans etc table values incrementing. The data in the
tables seems to be updating. Just an FYI, I've enabled manual vacuum
analyze runs on the
Try and remember to CC: the list - there are plenty of other people who
can help too.
chandresh rana wrote:
Hi Richard,
Let me explain you exactly what am trying to achieve.
Am trying to export the database of the sever(ver 7.4) to my local
server(ver 8.2).The problem in exporting ,is that
Ashish Karalkar wrote:
Hello all,
I want to set Auto vaccunme in such a way that it will start in the Mid night
(12:00 A.M.)
Is there any way to do this except Cron Job for Linux
What's wrong with cron? It's the tool that's designed to run timed jobs.
--
Richard Huxton
Archonet Ltd
On Wed, Jun 27, 2007 at 09:28:24AM +1200, Martin Langhoff wrote:
Alvaro Herrera wrote:
I think it would be much easier if you did something like
select * from test where lower(to_ascii(value)) = lower(to_ascii('martín'));
When to_ascii doesn't work (for example because it doesn't work
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
--
Regards,
Hannes Dorbath
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
Greetings,
I am trying to setup postgres and postfix using webmin. I am
following this guide:
http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System_-_Postfix_to_Postgres
I received the following in the postgres db section of webmin:
select * from pg_database order by datname failed :
Thnkas Richard for your replay.
Actually ,I was looking for some setting in postgresql.conf file
Is there any one?
With Regards
Ashish
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: Ashish Karalkar [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday,
Ashish Karalkar wrote:
Thnkas Richard for your replay.
Actually ,I was looking for some setting in postgresql.conf file
Is there any one?
Not to run at just a specific time.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 2:
Hi everybody,
I could not find any information on the passing arrays to the dblink
remote call.
By now I am using something like:
select t.r from dblink( connection_name, 'select r from
remote_stored_procedure( ARRAY[' || array_to_string( my_id_array,
',' ) || '] )' ) as t(r text);
The
2007/6/27, Danyelle Gragsone [EMAIL PROTECTED]:
Greetings,
I am trying to setup postgres and postfix using webmin. I am
following this guide:
http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System_-_Postfix_to_Postgres
I received the following in the postgres db section of webmin:
The work-around for old Slony versions:
replication_wait() {
echo Waiting for all slaves are in sync with the master...;
echo
`slonik_print_preamble`
# Hack for old Slony: this is a dummy operator which generates a
SYNC
# event and saves its ID for later waiting
Hannes Dorbath wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
Table spaces are the only solution I can think of.
If you create a table space on a different file system, then a table in
that
I've been looking around for this functionality:
Is it possible to use COPY with a file that doesn't reside in the DB's
filesystem? I know there is sort of a solution in using COPY from stdin/
COPY to stdout, however that depends on calling the psql command, which
breaks the flow of control of
On 6/27/07, Hannes Dorbath [EMAIL PROTECTED] wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
I am afraid currently you are stuck with tablespaces as a quoting tool.
Of course having a filesystem
I am sorry William but you lost me. I haven't disabled anything have I?
On 6/27/07, William Leite Araújo [EMAIL PROTECTED] wrote:
2007/6/27, Danyelle Gragsone [EMAIL PROTECTED]:
Greetings,
I am trying to setup postgres and postfix using webmin. I am
following this guide:
On 27.06.2007 16:58, Dawid Kuroczko wrote:
On 6/27/07, Hannes Dorbath [EMAIL PROTECTED] wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
I am contemplating using XFS filesystem's quota to achieve
I just checked the manual and it says nothing about being able to use the SQL
copy to access network files.
But you have an option that almost works for you. I am sure others here will
have some suggestions, but if I were in your place, I'd gather more information
about where
Hi everybody,
I have problem with frequently updated table (around 30.000 records and 1000
updates/minute, few indexes).
After a while all queries to that table become much slower then at the begining
(the number of records in the table is quite stable all the time).
I can see that
On Jun 27, 2007, at 9:32 AM, Jaime Silvela wrote:
I've been looking around for this functionality:
Is it possible to use COPY with a file that doesn't reside in the
DB's filesystem? I know there is sort of a solution in using COPY
from stdin/ COPY to stdout, however that depends on calling
Postgresql 8.1
I made a simple modification to contrib/xml2 to include the ability to process
exslt tags... On the production side, the postmaster crashes when I try to
process my exslt stylesheet. On my development machine, everything runs without
crashing. There's a number of differences
On Wed, Jun 27, 2007 at 10:32:32AM -0400, Jaime Silvela wrote:
I've been looking around for this functionality:
Is it possible to use COPY with a file that doesn't reside in the DB's
filesystem? I know there is sort of a solution in using COPY from stdin/
COPY to stdout, however that depends
Hi CG
looks as if your 64bit box needs 64bit libraries instead of default 32 bit
did you check here
http://dries.studentenweb.org/apt/packages/perl-XML-LibXSLT/info.html
Let us know
M--
This email message and any files transmitted with it contain confidential
information intended only for the
Tomasz Rakowski wrote:
I have problem with frequently updated table (around 30.000 records and
1000 updates/minute, few indexes).
After a while all queries to that table become much slower then at the
begining
(the number of records in the table is quite stable all the time).
I can see that
I need to check if the last two characters of a field are a number. I am
trying something like this but it does not want to work.
substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'
How should I do this?
--
Thanks,
Warren Bell
---(end of
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Warren
Sent: Wednesday, June 27, 2007 12:31 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Checking for a number
I need to check if the last two characters of a field are a
On 27.06.2007 15:18, Albe Laurenz wrote:
Hannes Dorbath wrote:
What would be a solution to prevent a single user/schema to fill the
disk using PostgreSQL? Is it a good idea to use separate table spaces?
Table spaces are the only solution I can think of.
If you create a table space on a
I compiled the libraries from the source tarballs I configured using
--with-crypt --with-debugger --with-python. It is always possible I missed
something!
Do you think the RPMs will even be applicable considering I'm not using RedHat
or Fedora?
- Original Message
From: Martin
yes..go with the specific distro for your OS (either RH or Fedora)
keep us apprised!
Thanks/
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email
The problem is that the getline/readline interface, which does exist for
Ruby, doesn't seem to work so well, and anyway operates line by line; I
would have preferred to just hand a file descriptor and be done with it.
Thanks for your suggestions too, Erik and Ted. Performance-wise the best
Hi,
i have a column in my table defined like this:
time_stamp timestamp DEFAULT ('now'::text)::timestamp with time zone
Data gets filled in this column from a Unix tools server.
Example values of this field are:
time_stamp
2007-06-27
Hi,
Il giorno 27/giu/07, alle ore 20:54, Jaime Silvela ha scritto:
The problem is that the getline/readline interface, which does
exist for Ruby, doesn't seem to work so well, and anyway operates
line by line; I would have preferred to just hand a file descriptor
and be done with it.
Jasbinder Singh Bali escribió:
Hi,
i have a column in my table defined like this:
time_stamp timestamp DEFAULT ('now'::text)::timestamp with time zone
Note that the column is of type timestamp, which _doesn't_ have a time
zone. You probably want
time_stamp timestamp with time zone DEFAULT
On Wed, Jun 27, 2007 at 02:54:05PM -0400, Jaime Silvela wrote:
The problem is that the getline/readline interface, which does exist for
Ruby, doesn't seem to work so well, and anyway operates line by line; I
would have preferred to just hand a file descriptor and be done with it.
Hrm, in
...As we continue through this process I just want to express my sincere thanks
for your suggestions heretofore
I use neither RedHat nor Fedora :( I also didn't look carefully at the RPMs you
were offering me. They are for XML::LibXSLT, not LibXSLT. Sorry about that!
I originally built
What is happening (or not happening) with pgaccess?
In upgrading a computer from Debian Linux 3.1 (sarge) to Debian Linux
4.0 (etch), the package pgaccess is no longer available.
My wife has it installed on her Ubuntu system, which is the version
before the current one. However, the
Well, for Ruby there are two Postgres drivers, a native compiled one I
run in Linux, and a pure Ruby one that I use in Windows. The PGconn
object in the Windows version doesn't seem to offer the methods putline,
readline or endcopy. The Linux version does, but since I do development
in both
Bruce McAlister wrote:
Ok now this is interesting:
select datname, age(datfrozenxid) from pg_database;
datname |age
-+---
blueface-crm| 441746613
Note this value is 440 million, and you said in your original report that
Bret Busby wrote:
What is happening (or not happening) with pgaccess?
As far as I know pgaccess has been dead for years. I would suggest
www.pgadmin.org
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 ||
On 6/28/07, Danyelle Gragsone [EMAIL PROTECTED] wrote:
I am sorry William but you lost me. I haven't disabled anything have I?
Hard to say w/o seeing the WHOLE file. You're looking in the
wrong section.
What you need to make sure is that the line William posted
*isn't* commented out.
Thanks Alvaro,
Your information proved very handy.
~Jas
On 6/27/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Jasbinder Singh Bali escribió:
Hi,
i have a column in my table defined like this:
time_stamp timestamp DEFAULT ('now'::text)::timestamp with time zone
Note that the column is of
BEFORE
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
#local is for Unix domain socket connections only
host template1 postfix, postfixadmin all 10.2.0.202 255.255.255.0 trust
# IPv4 local connections:
hostall all 127.0.0.1/32 trust
# IPv6 local
Warren escreveu:
I need to check if the last two characters of a field are a number. I am
trying something like this but it does not want to work.
substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'
How should I do this?
Try:
SELECT your_field ~ '.*[[:digit:]]{2}$';
Osvaldo
Hello,
I get the following message in the pgstartup.log:
postmaster cannot access the server configuration file
/database/postgresql.conf: Permission denied
I have:
1) read the file doing the following:
a) su posgres
b) less postgresql.conf
2) made sure each directory to file is
On 6/28/07, Danyelle Gragsone [EMAIL PROTECTED] wrote:
BEFORE
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
#local is for Unix domain socket connections only
host template1 postfix, postfixadmin all 10.2.0.202 255.255.255.0 trust
# IPv4 local connections:
hostall
--- Osvaldo Rosario Kussama [EMAIL PROTECTED] wrote:
Try:
SELECT your_field ~ '.*[[:digit:]]{2}$';
This could be simplified a little. :o)
WHERE your_field ~ '\\d{2}$';
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
Alvaro Herrera wrote:
Bruce McAlister wrote:
Ok now this is interesting:
select datname, age(datfrozenxid) from pg_database;
datname |age
-+---
blueface-crm| 441746613
Note this value is 440 million, and you said in
Matthew,
Thank you for reply.
I was trying to configure autovacuum for given table to be more aggressive
(min=100, scale factor=0.01).
Then waited for autovacuum to be activated for given table
(watching Server status window; about 1000 updates/min, 30.000 rows in the
table, so
Here is the entire file.
# PostgreSQL Client Authentication Configuration File
# ===
#
# Refer to the PostgreSQL Administrator's Guide, chapter Client
# Authentication for a complete description. A short synopsis
# follows.
#
# This file
On 6/28/07, Danyelle Gragsone [EMAIL PROTECTED] wrote:
Here is the entire file.
Could someone please take a look at this and tell me what I am doing
wrong. Apparently I have something commented that I shouldn't but I
don't know what that is. Sorry if I sound like a complete moron.. but
I am
Hi all.
I understand this can be a ridiculous question for most you.
The very same query on the very same db shows very variable timings.
I'm the only one client on an unpupolated server so I'd expect a
rather constant timing.
INstead for a while the query become very slooow and the CPU reached
Bruce McAlister wrote:
Alvaro Herrera wrote:
Bruce McAlister wrote:
Ok now this is interesting:
select datname, age(datfrozenxid) from pg_database;
datname |age
-+---
blueface-crm| 441746613
Note this value
Tomasz Rakowski wrote:
Matthew,
Thank you for reply.
I was trying to configure autovacuum for given table to be more aggressive
(min=100, scale factor=0.01).
Then waited for autovacuum to be activated for given table
(watching Server status window; about 1000 updates/min,
On Jun 27, 2007, at 16:17 , Richard Broersma Jr wrote:
--- Osvaldo Rosario Kussama [EMAIL PROTECTED] wrote:
Try:
SELECT your_field ~ '.*[[:digit:]]{2}$';
This could be simplified a little. :o)
WHERE your_field ~ '\\d{2}$';
Using dollar-quotes means not having to escape your \d (which I
Amazing how one little line.. makes everything sad.
Now all I have to do is figure out how to login. My old username and
password no longer works..
thanks for helping!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On 6/28/07, Danyelle Gragsone [EMAIL PROTECTED] wrote:
Now all I have to do is figure out how to login. My old username and
password no longer works..
So you were able to connect to the database with webmin
before this change? In that case you may want a similar
line for your own user account
Alvaro,
I changed autovacuum parametrs for this specific table in pg_autovacuum
insert into pg_autovacuum(vacrelid,enabled,vac_base_thresh,
vac_scale_factor, anl_base_thresh, anl_scale_factor,
vac_cost_delay, vac_cost_limit,
freeze_min_age,
Alvaro Herrera wrote:
How much is the age decremented by on a vacuum run then?
It should be decremented to the vacuum_freeze_min_age. However, I'm
running some experiments with your settings and apparently it's not
working as it should.
Nah, false alarm, it's working as expected for me.
Tomasz Rakowski wrote:
Alvaro,
I changed autovacuum parametrs for this specific table in pg_autovacuum
insert into pg_autovacuum(vacrelid,enabled,vac_base_thresh,
vac_scale_factor, anl_base_thresh, anl_scale_factor,
vac_cost_delay,
Alvaro,
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table are
constant (at least for this hour: 500)
and number of pages
Yes,
That was the odd thing about it. All I did was add the ip address. I
will have to change my postgres password cause I can't remember it.
bleh..
---(end of broadcast)---
TIP 6: explain analyze is your friend
Is it possible to have a user-defined function (a plpqsql function) as the
argument to a default clause that issues SELECTs on other tables?
Thanks,
Keary Suska
Esoteritech, Inc.
Demystifying technology for your home or business
---(end of
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images, I want use postgres, anyone have experience with
this kind of systems, can you suggest me an opensource solution ??
Thanks.
---(end of
On Jun 27, 2007, at 18:18 , Keary Suska wrote:
Is it possible to have a user-defined function (a plpqsql function)
as the
argument to a default clause that issues SELECTs on other tables?
Not according to the documentation:
yay its fixed. How do I make the topic solved?
Danyelle
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Tom Lane wrote:
Pierre Thibaudeau [EMAIL PROTECTED] writes:
I am puzzling over this issue:
1) Is there ever ANY reason to prefer varchar(n) to text as a column type?
In words of one syllable: no.
Not unless you have an application requirement for a specific maximum
length limit (eg, your
Brian J. Erickson [EMAIL PROTECTED] writes:
I get the following message in the pgstartup.log:
postmaster cannot access the server configuration file
/database/postgresql.conf: Permission denied
Are you trying to change the standard config file location on a
Red Hat or Fedora system? If so
So, I wrote myself a trigger function that when called will
dynamically create new partition tables and rules so that the first
new record for each partition creates the partition. The only bit that
I wanted to see if there was a a better solution was the actual insert
into the new table at the
On Jun 27, 2007, at 19:38 , Paul Lambert wrote:
Is there any disk space advantages to using varchar over text?
No.
Or will a text field only ever use up as much data as it needs.
Yes.
From http://www.postgresql.org/docs/8.2/interactive/datatype-
character.html
The storage requirement
Paul Lambert wrote:
Is there any disk space advantages to using varchar over text? Or will a
text field only ever use up as much data as it needs.
1. no 2. yes.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1, W 73º 13' 56.4
Hackers share the surgeon's secret pleasure in
Michael Glaesemann wrote:
Works for me:
test=# select version();
version
--
PostgreSQL
Paul Lambert wrote:
Looks like my bad - I created the table initially through pgAdminIII and
it appears I selected the wrong character varying from the dropdown list.
CREATE TABLE tester
(
test_varchar character varying[],
test_text text
)
If I change it to character varying(20)
Tomasz Rakowski wrote:
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table
are constant (at least for this hour: 500)
and number of
Hi All,
I've found on pg7.4.x that plpgsql trigger will not wait for finishing
one line of command before executing to the next line, specially if
that command is firing another trigger on another table. This is very
wrong on my point of view. This only happen on pg7. To check:
(create master
Michael Glaesemann [EMAIL PROTECTED] writes:
On Jun 27, 2007, at 18:18 , Keary Suska wrote:
Is it possible to have a user-defined function (a plpqsql function)
as the
argument to a default clause that issues SELECTs on other tables?
Not according to the documentation:
Luki Rustianto [EMAIL PROTECTED] writes:
I've found on pg7.4.x that plpgsql trigger will not wait for finishing
one line of command before executing to the next line, specially if
that command is firing another trigger on another table. This is very
wrong on my point of view. This only happen
76 matches
Mail list logo
