On Mar 26, 2004, at 6:28, Anony Mous wrote:
Thanks again. I've got it working using the API calls described.
pg_dump does return an exit code of 0 upon success. Does anyone know
off
hand what is returned when the process fails?
Not 0. You're looking for success, right?
--
Dusti
pg_dump from executing fully, would there still be an output file up to the point where the corruption was encountered? If so, does anyone have any suggestions on another method to confirm whether or not the db was successfully dumped?
The exit code?
--
Dustin Sallings
asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
---(end o
an being a script a DBA would run whenever he determined it
necessary).
--
Dustin Sallings
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
---
I don't believe sequences should automatically create
themselves (the tables and columns don't).
--
SPY My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D
6179
---(end of
broadcast)---
TIP 8: explain analyze is your friend
--
SPY My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
in volume and replication is a
requirement.
I look forward to hearing what the options are. Thanks.
--
SPY My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08
w can I do this with SQL in Postgres. Any ideas.
insert into xyz(uvw) values ('Test');
INSERT 18968479 1
dustin=# select currval('xyz_id_seq');
currval
-----
1
(1 row)
--
dustin sallingsThe world is watching America,
http://2852210114/~dus
com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
while still allowing writes?
Use a filesystem that supports snapshotting.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98
dex in about half that time, and a vacuum takes me approximately
five minutes.
Now, it's true, I don't remember having to vacuum before, but the
vacuum isn't very painful.
--
dustin sallingsThe world is watching America,
http://2852210114/~dustin/ and America is watching TV.
, give examples of what's
# > > worse now than before.
# > >
# > > --
# > > -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
# > > "I have the heart of a child; I keep it in a jar on my desk."
# > >
#
#
--
dustin sallingsThe world is watching America,
http://2852210114/~dustin/ and America is watching TV.
e house, but I'm in no way interested in using them as data servers.
--
dustin sallingsThe world is watching America,
http://2852210114/~dustin/ and America is watching TV.
ll on the other laptop.
The laptop I usually keep with me runs Postgres for development on the
road. It's kinda one of those, ``Choose the right tool for the job''
things. If a database server is what you want, then Windows 95 probably
isn't.
--
dustin sallings
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
than, say, 30,000 rows.
#
# [Snip]
#
# -Original Message-
# From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
# Sent: Thursday, January 06, 2000 10:14 AM
# To: Dustin Sallings
# Cc: The Hermit Hacker; [EMAIL PROTECTED]
# Subject: Re: [GENERAL] Benchmarks
#
#
# > Untrue, vacuum is *extremely* importa
update my stats every
day, or more frequently, but only cleanup once a week or month or
whatever.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0
database pooling, and the other is written in perl and makes
a database connection each time it has a batch of inserts. I've not seen
the actual behavior when the event processing system breaks the database,
but it's usually followed by a ton of inserts trying to make their way in.
--
dus
# Roberto Moreda
# Resp. Dpto. Informática Handem/San Luis
# Tlf +34 981 779000
# Fax +34 981 779022
# Pol. Piadela Sur, Autovía A6 Sal.567
# 15300 Betanzos (A Coruña) - España
#
#
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Salli
On Thu, 8 Jul 1999, Albert Chen wrote:
# I know there is a ApacheMysql module. Has ApachePostgres module?
What exactly are you wanting to accomplish?
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EM
; Laurence
# >
# >
# >
# >
#
# Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
# Systems Administrator @ hub.org
# primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
#
#
#
--
SA, beyond.com My girlfriend asked
That doesn't tell you the last value you added, that tells you the
last value that was added at all. currval('network_networkid_seq') tells
you the last one you added.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/0
--/
# > > // > /- Piotr Stelmaszyk | Student of Computer Science ---/
# > > // > /-- | at Poznan University of Technology /
# > > // > /- mailto:[EMAIL PROTECTED] -/
# > > // > /- mailto:[EMAIL PROTECTED] ---/
# > > // > //
# > > // >
# > > // >
# > > // >
# > > //
# >
om My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
riend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
mThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L__ and America is watching TV. __
to use it because I don't like the
way the data is stored on disk, though.
--
Principal Member Technical Staff, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0
rategy. It's very difficult to improperly shut
down a Linux machine while it's actually doing something and not lose a
file. It's very difficult to run an OS for five years without having it
improperly shut down (given normal home conditions).
--
SA, beyond.com My girlfr
yond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
On Thu, 1 Apr 1999, Rick Dearman wrote:
// Where are the system logs kept?
Where ever you put them.
--
Principal Member Technical Staff, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57
//
// But what is best?
//
//
//
--
Principal Member Technical Staff, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_
input row you want, a trigger or rule would
be still yet better. :)
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_
On Tue, 9 Mar 1999, amarof wrote:
# please give me the way to do that
Nobody knows what your server is.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57
/ > // my $0.02
// > //
// > // steve doliov
// > //
// > //
// > //
// >
// > --
// > Principal Member Technical Staff, beyond.comThe world is watching America,
// > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
/
inserts at the
// back.
//
// my $0.02
//
// steve doliov
//
//
//
--
Principal Member Technical Staff, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA
ere=>
What's a millisid? If it's something obscure, there may not have
been a max() defined for it.
//
// -Original Message-
// From: dustin sallings [mailto:[EMAIL PROTECTED]]
// Sent: Saturday, February 06, 1999 2:21 PM
// To: Jonny Hinojosa
// Cc: PostGreSQL Maili
E 'x' AND b LIKE 'y'.
// >
// > Jonny Hinojosa
// > TCA Internet
// > [EMAIL PROTECTED]
// > 409.693.8885
// >
// >
//
//
//
--
Principal Member Technical Staff, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings &l
nyone have any idea what's causing this problem, or how to fix it?
I've done larger joins before... Anyway, I'm going to have to denormalize
my database some to work around this.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/0
which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
atching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L__ and America is watching TV. __
value is
used.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
Technical Staff, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L__ and America is watching TV. __
, and implementing a
# Perl DBD or DBI for Postgresql. Can anyone assist?
#
# Bob
#
#
#
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65
| (610) 853-3000
// + If your life is a hard drive, | 830 Blythe Avenue
// + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
//
//
--
SA, beyond.com The world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings &l
k).
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L___ I hope the answer won't upset her.
America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L and America is watching TV. __
l Hill, Pennsylvania 19026
//
//
--
SA, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L and America is watching TV. __
comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L and America is watching TV. __
each of the subqueries only needs
# to be evaluated once, rather than once per row of users. Is there a
# way to reformulate this query to make it less expensive?
#
#
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[E
5
// 1| 6
//
//
//
// hope someone outthere can help me :)
//
// Henrik Pedersen
// Demark
//
//
--
SA, beyond.comThe world is watching America,
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 5
You also might want to add an index or two (the SQL book would tell you
all about it).
--
SA, software.net My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
|Key fingerprint = 87 02 57 08 02 D0 DA D
52 matches
Mail list logo
