Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
With Regads
Ashish Karalkar
Want to start your own business?
Learn how on Yahoo! Small Business.
Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
With Regads
Ashish Karalkar
Have a burning question?
Go to www.Answers.yahoo.com and get answers from
On Friday 08 December 2006 09:16, Ashish Karalkar wrote:
| Can we have Auto Backup facility to schedule backup of
| PostgreSQL Database
| I am using version 8.2.0
why don't you use cron to set up a backup script?
Ciao,
Thomas
--
Thomas Pundt [EMAIL PROTECTED] http://rp-online.de/
Yes, setup a cron job using pg_dump utility and in case you need incremental
backups PITR can serve the purpose
Thanks,
Shoaib
On 12/8/06, Thomas Pundt [EMAIL PROTECTED] wrote:
On Friday 08 December 2006 09:16, Ashish Karalkar wrote:
| Can we have Auto Backup facility to schedule backup
Andrus wrote:
In my current DBMS I can use
create table t1 ( f1 int, f2 int );
create table t2 ( f3 int, f4 int );
update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
That looks like a self-join on t1 without using an alias for the second
instance of t1.
I think you meant:
update
[please include a meaningful subject]
On Dec 8, 2006, at 17:10 , Ashish Karalkar wrote:
Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
cron pg_dump or pg_dumpall on unix works great. I'm not sure on
Windows, but I bet there's something.
You can use a view for that join query and then create a rule over it to
insert in the referenced tables for the inserts in view.
Thanks,
Shoaib
On 12/8/06, Alban Hertroys [EMAIL PROTECTED] wrote:
Andrus wrote:
In my current DBMS I can use
create table t1 ( f1 int, f2 int );
create table
Hi all,
I tried the knewly introduced feature allowing one to exclude a schema
from a backup with pg_dump, but I got a
really strange error :
pg_dump -U postgres MYDB -N _MYDB gives me a dump including that schema.
I then tried pg_dump -U postgres MYDB -n _MYDB and then got pg_dump:
No matching
On Thu, Dec 07, 2006 at 06:01:13PM +0100, Zoltan Boszormenyi wrote:
I have just one more question:
How can I get an Oid out of a Datum, i.e.
how do I know what type I get in a given Datum?
DatumGetObjectId() seems to give me an Oid that
was specifically stored as a Datum.
I have found the
On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys wrote:
Andrus wrote:
In my current DBMS I can use
create table t1 ( f1 int, f2 int );
create table t2 ( f3 int, f4 int );
update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
That looks like a self-join on t1 without using an
On fös, 2006-12-08 at 10:17 +, Ragnar wrote:
On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys wrote:
Andrus wrote:
In my current DBMS I can use
create table t1 ( f1 int, f2 int );
create table t2 ( f3 int, f4 int );
update t1 set f1=t2.f3 from t1 left join t2 on
On Thu, Dec 07, 2006 at 02:52:11PM -0800, Alan Hodgson wrote:
On Thursday 07 December 2006 08:38, Angva [EMAIL PROTECTED] wrote:
three commands. For instance I have a hunch that creating the indexes
first (as I do now) could slow down the clustering - perhaps the row
locations in the
Hello List,
I am still trying to generate RPM for an IA-64 server with Red Hat
Enterprise Linux 4 AS and today, I got a question about the
postgresql-8.2.0-2PGDG.src.rpm.
This src.rpm contains :
-rw-r--r-- 1 postgres postgres 12459207 Dec 2 20:25
postgresql-8.2.0.tar.bz2
-rw-r--r-- 1
Hi!
error with Subquery alias...
help...
SELECT *,(SELECT COUNT(id)
FROM articles a WHERE a.lft articles.lft AND a.rgt articles.rgt) AS depth
FROM articles
where (depth 3)
ORDER BY lft
Max mailto:[EMAIL PROTECTED]
---(end of
TSearch does change from version to version.
- Create your database with template=template0
- Load tsearch2.sql
- Truncate pg_ts_* tables
- Try to restore
Ignore the already exists errors and examine the rest carefully.
On 08.12.2006 00:11, Rick Schumeyer wrote:
It was my understanding that
Sorry, not only load tsearch2.sql. Load your dictionaries as well.
(The SQL-Files generated after Gendict and make in contrib/dict_xx)
On 08.12.2006 12:08, Hannes Dorbath wrote:
TSearch does change from version to version.
- Create your database with template=template0
- Load tsearch2.sql
-
I have two similar datasets, on two diffrent m/cs.
One m/c has PG 8.0.0 installed the other has PG 8.1.5 installed
i vaccum analyzed both and i see that the delete performance in PG 8.1.5 is one
third and sometimes one fifth of PG 8.0.0
please see that the number of rows etc is similar and
On Thu, Dec 07, 2006 at 04:44:35PM -0700, [EMAIL PROTECTED] wrote:
fields. The WHERE clause that I use in SQL Server is:
getdate() + ((2100 + 5 + (9*Points)) / 86400) = DueTime
Where the numbers are actually parameters passed in to the function.
Other than changine getdate() to now(), I'm
On fös, 2006-12-08 at 13:58 +0300, Max Bondaruk wrote:
Hi!
error with Subquery alias...
SELECT *,(SELECT COUNT(id)
FROM articles a WHERE a.lft articles.lft AND a.rgt articles.rgt) AS depth
FROM articles
where (depth 3)
ORDER BY lft
you cannot refer to depth in the where because it is
On 8 Dec 2006 at 18:10, Michael Glaesemann wrote:
cron pg_dump or pg_dumpall on unix works great. I'm not sure on
Windows, but I bet there's something.
pgAdmin comes with pgAgent - I haven't used it, but it's a job
scheduler for postgreSQL. Alternatively, use the Windows scheduler
with
Hello,
On Fri, 2006-12-08 at 11:59 +0100, DANTE Alexandra wrote:
I am still trying to generate RPM for an IA-64 server with Red Hat
Enterprise Linux 4 AS and today, I got a question about the
postgresql-8.2.0-2PGDG.src.rpm.
We are working off-list with Alexandra and will inform the list as
On Dec 7, 11:42 pm, [EMAIL PROTECTED] (Tony Caduto)
wrote:
BigSmoke wrote:
On Dec 7, 11:07 pm, [EMAIL PROTECTED] (Merlin Moncure) wrote:
On 7 Dec 2006 14:02:53 -0800, BigSmoke [EMAIL PROTECTED] wrote:
I'm facing a particular task for which I need any procedural language
but PL/PgSQL. I
In article [EMAIL PROTECTED],
Alban Hertroys [EMAIL PROTECTED] writes:
Andrus wrote:
In my current DBMS I can use
create table t1 ( f1 int, f2 int );
create table t2 ( f3 int, f4 int );
update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
That looks like a self-join on t1 without
In response to Stéphane Schildknecht [EMAIL PROTECTED]:
Hi all,
I tried the knewly introduced feature allowing one to exclude a schema
from a backup with pg_dump, but I got a
really strange error :
pg_dump -U postgres MYDB -N _MYDB gives me a dump including that schema.
I then tried
First, I think the table design is probably not the best way to do this.
In the relational database world, Table 2 probably should look like this:
NODE1 NODE2
NODE1 NODE3
NODE2 NODE4
NODE2 NODE3
Then you could do:
INSERT INTO table1 SELECT DISTINCT column2 FROM table2 WHERE column2
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 02:36, Thomas Pundt wrote:
On Friday 08 December 2006 09:16, Ashish Karalkar wrote:
| Can we have Auto Backup facility to schedule backup of
| PostgreSQL Database
| I am using version 8.2.0
why don't you use cron to set up a backup
Is there a way I can have notifications to be streamed to the listener,
so I don't need to poll with LISTEN?
LISTEN foo;
LISTEN
NOTIFY foo;
NOTIFY
Asynchronous notification foo received from server process with PID 3593.
This does work for the same backend, but not for notifications issued
On Fri, Dec 08, 2006 at 03:38:49PM +0100, Hannes Dorbath wrote:
Is there a way I can have notifications to be streamed to the listener,
so I don't need to poll with LISTEN?
LISTEN foo;
LISTEN
NOTIFY foo;
NOTIFY
Asynchronous notification foo received from server process with PID 3593.
Hi -
I am trying to make use of table partitions. In doing so I would like to
use a rule to call a functioning which inserts the data into the proper
partition. To do so, I believe that I need to find a way to opaquely pass
NEW from the rule to a function which then passes it to INSERT.
Bill Moran [EMAIL PROTECTED] writes:
In response to Stéphane Schildknecht [EMAIL PROTECTED]:
pg_dump -U postgres MYDB -N _MYDB gives me a dump including that schema.
I then tried pg_dump -U postgres MYDB -n _MYDB and then got pg_dump:
No matching schemas were found
My guess is that you're
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain, something like:
CREATE DOMAIN gender_domain
AS character
Second method might be better.
Of course, you could also do a one chracter gender M/F if you want to
save space.
Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:23, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one
Raymond O'Donnell [EMAIL PROTECTED] schrieb:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain,
Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain, something like:
CREATE DOMAIN
-Oorspronkelijk bericht-
Van: H.J. Sanders [mailto:[EMAIL PROTECTED]
Verzonden: vrijdag 8 december 2006 16:33
Aan: Raymond O'Donnell
Onderwerp: RE: [GENERAL] Male/female
Hi ray.
We have done it with a integer whereby
0 = woman
1 = man
also self-documenting :-)
Ragnar [EMAIL PROTECTED] writes:
On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys wrote:
Andrus wrote:
update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
That looks like a self-join on t1 without using an alias for the second
instance of t1.
I think you meant:
update t1 set
On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain,
I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2
I have a servlet that uses connection pools.
The servlet do LOCK table,table2,table3,table4
then do some select (I am testing the code, I will put the update
H.J. Sanders wrote:
We have done it with a integer whereby
0 = woman
1 = man
also self-documenting :-)
Why not use unicode symbols 0x2640 and 0x2642?
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus
Just wondering.how do list members represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
[snip]
We have done it with a integer whereby
0
0 = woman
1 = man
This gave me my first good laugh of the day... I will never accuse DBAs of not
having a sense of humor albeit unique!
Richard,
gmail extended my laugh with the sponsored links:
How To Be A woman
How To Be The Girl That Every Man Secretly Wishes He Was Married To!
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a gender as it is a process of moving from one gender to another?
---(end of
Marc Evans [EMAIL PROTECTED] writes:
I am trying to make use of table partitions. In doing so I would like to
use a rule to call a functioning which inserts the data into the proper
partition.
Basically, you're guaranteeing yourself large amounts of pain by
insisting on using a rule for
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gender which has one TEXT column, that
being its primary key. For one client I had, there were
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa [EMAIL
PROTECTED] wrote:
Now we just need fast, stable and native replication for The Girl
That Every Man Secretly Wishes He Was Married To!
I want replication WITH that girl!
Any chance for 8.3?
bkw
Andreas Kretschmer wrote:
What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need an 'unreported' value of some sort.
--
Steve Wampler -- [EMAIL
Seven genders? Even San Fransisco thinks that's over the top.
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gender which
On Fri, 2006-12-08 at 17:39, Bernhard Weisshuhn wrote:
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa [EMAIL
PROTECTED] wrote:
Now we just need fast, stable and native replication for The Girl
That Every Man Secretly Wishes He Was Married To!
I want replication WITH that
Edoardo Panfili [EMAIL PROTECTED] writes:
I have a servlet that uses connection pools.
The servlet do LOCK table,table2,table3,table4
then do some select (I am testing the code, I will put the update in the
future) an then I close instruction and connection.
The first 4 executions of the
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a gender as it is a process of moving from one gender to
Keary Suska wrote:
Thanks to Erik, Jeff, Richard for their help.
I have a further inheritance question: do child tables inherit the indexes
created on parent columns, or do they need to be specified separately for
each child table? I.e., created via CREATE INDEX.
I assume at least that the
Hi
I am trying to restore a pgdump.sql file. i am very much in need of help.
i first went to pgAdmin III and created two database ( postgres and
anuradha)...
properties of anuradha ::
1) owner = ofbiz
2) encoding = 'UTF8'
3)connected ? yes
4) allow connections?
Joshua D. Drake [EMAIL PROTECTED] writes:
Yes, but further I don't know of any country that recognizes anything
but Male or Female.
I haven't read the beginning of the thread, but will this table be used only
for humans? There are animals that are hermafrodites (I hope I got the
English
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gender which has one
On Fri, 2006-12-08 at 11:05, Joshua D. Drake wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
Joshua D. Drake wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a gender as it is a process of moving
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called
I guess in the end it really depends on what the client wants to track
and what they don't. But this does actually have a serious implication,
and that is how do you code for something that is mutable vs. something
that supposedly is or very nearly immutable (i.e. the alphabet).
That not including Genetics,
where and individual could have
multiple X Chromomes individuals
Or be XY - female times those other
6 (or 7).
- Original Message -
From: brian [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Friday, December 08, 2006 9:19 AM
Subject: Re: [GENERAL]
Jorge Godoy wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Yes, but further I don't know of any country that recognizes anything
but Male or Female.
I haven't read the beginning of the thread, but will this table be used only
for humans? There are animals that are hermafrodites (I hope I
Csaba Nagy wrote:
On Fri, 2006-12-08 at 17:39, Bernhard Weisshuhn wrote:
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa [EMAIL
PROTECTED] wrote:
Now we just need fast, stable and native replication for The Girl
That Every Man Secretly Wishes He Was Married To!
I want
Tom Lane wrote:
Edoardo Panfili [EMAIL PROTECTED] writes:
I have a servlet that uses connection pools.
The servlet do LOCK table,table2,table3,table4
then do some select (I am testing the code, I will put the update in the
future) an then I close instruction and connection.
The first 4
Edoardo Panfili [EMAIL PROTECTED] writes:
It seems that if I put some delay between calls to the servlet all goes
well. I can change lock level but ther is something wrong.
Obviously I am doiung something wrong. To unlock the tables is not
sufficient close the Statement and the Connection?
Quick follow up on this, the guy who ran this test retested with a much
newer version of MySQL and sent this message to the DBMail mailing list
today.
Ok, I just did the test on mysql 5.0.27. It took 73 seconds
to deliver the 1000 messages. So, it's a good bit faster
than 4.1.20's 95 seconds,
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gender
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:31, John Meyer wrote:
Second method might be better.
Too much heat from declaring Males are True, Females are False?
Of course, you could also do a one chracter gender M/F if you want to
save space.
Raymond O'Donnell wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:40, Leif B. Kristensen wrote:
On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 12:38, Matthew O'Connor wrote:
Csaba Nagy wrote:
On Fri, 2006-12-08 at 17:39, Bernhard Weisshuhn wrote:
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa
[EMAIL PROTECTED] wrote:
[snip]
You know, here in the US not that
Tom Lane wrote:
Edoardo Panfili [EMAIL PROTECTED] writes:
It seems that if I put some delay between calls to the servlet all goes
well. I can change lock level but ther is something wrong.
Obviously I am doiung something wrong. To unlock the tables is not
sufficient close the Statement and
Edoardo Panfili [EMAIL PROTECTED] writes:
I spend many time to explain the bahaviour of the system:
I some occasions the system use another connection to retrieve some
information during the main connection. This explain the hangs but...
why sometimes the system works.
I do more tests.
On Fri, 2006-12-08 at 09:16, Edoardo Panfili wrote:
I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2
I have a servlet that uses connection pools.
The servlet do LOCK table,table2,table3,table4
then do
Scott Marlowe wrote:
On Fri, 2006-12-08 at 09:16, Edoardo Panfili wrote:
I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2
I have a servlet that uses connection pools.
The servlet do LOCK
On Fri, Dec 08, 2006 at 11:13:03AM -0600, Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in
Isn't that why we have null?
On Fri, 8 Dec 2006, Steve Wampler wrote:
Andreas Kretschmer wrote:
What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need
On 8 Dec 2006 at 15:12, Jorge Godoy wrote:
I haven't read the beginning of the thread, but will this table be
used only for humans? There are animals that are hermafrodites (I hope
Many thanks to all who responded - I had no idea of the monster I was
creating in starting this thread!
Yes,
Tom Lane wrote:
Edoardo Panfili [EMAIL PROTECTED] writes:
I spend many time to explain the bahaviour of the system:
I some occasions the system use another connection to retrieve some
information during the main connection. This explain the hangs but...
why sometimes the system works.
I
On 8 Dec 2006 at 11:13, Scott Marlowe wrote:
Male
Female
Hermaphrodite
Trans (MTF)
Trans (FTM)
Neuter
and... I can't think of a seventh possibility.
How about just plain confused??
--Ray.
--
Raymond O'Donnell
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
Yes, the table is used only for humans; it's part of some
administrative software I'm writing for an educational institution,
and the primary purpose of the gender column is to help the users
cope with a problem new to the west of Ireland - the
NULL concatenated to anything is NULL. Try this:
UPDATE test SET myint = COALESCE(myint || ARRAY[123], ARRAY[123]) WHERE
id = 1;
Or:
UPDATE test SET myint =
CASE WHEN myint IS NULL THEN ARRAY[123]
ELSE myint || ARRAY[123]
END
WHERE id = 1;
An empty array can be displayed as
On 8 Dec 2006 at 12:17, Richard Troy wrote:
Ray, darest I point out that that's never been possible in English
anyway? There are dozens if not hundreds of androgenous names - Pat and
Tracy come immediately to mind, and there are countless others!
You're correct, of course - but this is the
On 12/8/06, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a
big-snip
Male
Female
Hermaphrodite
This read, Intersexed
Trans (MTF)
Trans (FTM)
Neuter
and... I can't think of a seventh possibility.
Decline to state
ISO 5218 takes 22 pages to give us four oddly placed values for male,
female, and two versions of null, unknown and not
Steve Crawford wrote:
Of course this breaks apart when dealing with that very rare syndrome
(name escapes me) where the child appears female at birth but is
actually a male whose male sex-organs descend and appear at puberty
so I
guess we need to add apparent_sex_at_birth.
It turns out
Angva wrote:
Looking for a small bit of advice...
I have a script that updates several tables with large amounts of data.
Before running the updates, it drops all indexes for optimal
performance. When the updates have finished, I run the following
procedure:
recreate the indexes
cluster the
Hi all,
Since PITR works well, my use of pg_dump has shifted. Rather than using
it as a backup tool, I now use it as a snapshotting tool. At the end of
each month we do an ASCII dump to keep around, so if we ever need to,
we can see the data as it was any number of months or years ago.
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
please, give me a reason not to get cynical...
-Original Message-
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
please, give me a
Richard Troy wrote:
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
Yes, the table is used only for humans; it's part of some
administrative software I'm writing for an educational institution,
and the primary purpose of the gender column is to help the users
cope with a problem new to the
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product
Steve Crawford wrote:
Richard Troy wrote:
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
Yes, the table is used only for humans; it's part of some
administrative software I'm writing for an educational institution,
and the primary purpose of the gender column is to help the users
cope
On Fri, Dec 08, 2006 at 12:49:30PM -0800, Glen Parker wrote:
I'd like to see a general way to take indexes off line without actually
losing their definitions. For example, something like ALTER TABLE [EN
| DIS] ABLE INDEXES, ALTER INDEX [EN | DIS] ABLE, etc. This could
also be used
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a
Martijn van Oosterhout wrote:
On Fri, Dec 08, 2006 at 12:49:30PM -0800, Glen Parker wrote:
I'd like to see a general way to take indexes off line without actually
losing their definitions. For example, something like ALTER TABLE [EN
| DIS] ABLE INDEXES, ALTER INDEX [EN | DIS] ABLE, etc. This
On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
please, give me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 14:40, Richard Troy wrote:
big-snip
[snip]
0 = unknown
1 = male
2 = female
3 =
4 = female to male transgender
5 = male to female transgender
6 =
7 = hermaphrodite
8 = declined to state
9 = Neuter - Not applicable
Hmmm...
On Fri, 2006-12-08 at 16:13, Jeff Davis wrote:
On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba
Jeff Davis wrote:
On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free database in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
1 - 100 of 119 matches
Mail list logo