#x27;
make: *** [all] Error 2
Any help would be appreciated.
Thanks, Matt
PS, I'm on Windows 2000 and the binaries didn't seem to work. If I'm doing
something wrong, let me know how to do it right.
---(end of broadcast)---
TIP 5: Ha
Murthy Kambhampaty wrote:
Backup restore has been tested so far by restoring a table and comparing the
contents; they were identical. Thanks to rsync performance is fantastic
compared to pgdump to a file (my past e-mail to the list will give some idea
of the problems we've had with that). I'd be i
and, a way of empirically deriving some 'correct'
optimizer parameters for a given machine would be very nice :-)
Matt
On Wed, 2003-06-18 at 18:07, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Sure, it would be great if we could do it.
>
>
ns.
>
> On 18 Jun 2003, matt wrote:
>
> > Are there really any performance settings of much interest beyond the
> > shared and non-shared memory settings? Beyond those the interactions
> > get so complex that automation is probably impossible anyway, and
> > certai
This is not facetious, honestly, but what about google?
site:archives.postgresql.org +"OS X" +terminal
returns just a couple of pages...
Of course there's no date ordering as such, although "+2003" works
fairly well, as does +"[ADMIN]".
Not a panacea I know, but it's quick, and it does have the
>
> If you're gonna accuse me of lying, you damned well better have the balls
> AND evidence to back it up.
>
Wow. Scott, all traffic to the admin list has ceased since you posted
this, we are shocked!
You put a lot of effort into finding the root of the 'mysteriously good
IDE performance' issue
>> If he doesn't have the wit to respond then he's just a troll anyway.
>
> Well, I still feel I should apologize for my harshness on a public list.
> I could have at least taken that one private. But you are right, I did
> spend a lot of my time chasing down the IDE issues, so to be so flippantly
> Does the law require protection from a determined DBA, or just casual
> viewing by the DBA? *If* it's the latter, you could do something like
> this:
The EU directive (and therefore the laws of indiviual countries) requires
that if someone gets access to your *DATABASE* they cannot get personal
Got any suggestions now?!? I was sort of looking for more information /
insight on my postgresql.conf file... but it seems we had to get the "IS HE
A MORON" question answered :P
Anyhow, again thank you for any help you can lend...
Well, try not to SHOUT is a good suggestion. Also, how about p
Title: Message
You
would assign a different subnet to the connection, and then tell the servers to
connect to the PG server's address on that subnet. No other changes
required. Very odd setup though. If you want a 'private' connection
then use a switch, rather than needing umpty NICs in t
Switches are not security devices. While it is harder to sniff packets on
switches, you can't count on them to prevent hostile machines on the
switch from playing games with the arp protocol. Also I believe that if
a switch doesn't remember where a particular mac address is it will send
the packet
If you have 6 app servers it's just daft to stick 6 NICs in your DB
server.
While there might be some cases where that makes sense most likely it
isn't something you would want to do. I believe the original motivation
was to solve bandwidth congestion rather than security.
Put all your eggs in one basket, and WATCH THAT BASKET.
Better yet, pay someone more reliable than oneself to watch it.
Preferably a well-paid and happy fox.
Or _maybe_ put your eggs in an invisible super-basket?
Not trolling, just checking the analogy integrity field.
M
--
Hi guys
I had just recreate database that deleted some
useful data in one of teh table. There's no backup dump badly. But as i know
there a transaction log taht will log everything from beginning, anyone know how
to do a rollback or roll forward?
e
Anyone, with any clue here please let me know. I will be eternally grateful. :)
--Matt
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
comes back on lines. I'm looking for recommendations
of the best solution to use. Is there any sort of concensus?
thanks,
--Matt
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-n
y
(I am compiling without readline 'cause it wouldn't compile with it,
even after installing it!)
Does anybody have a suggestion?
Thanks!
--
Matt
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister c
I just found the solution in the docs (DOH!):
LD_LIBRARY_PATH=/usr/local/lib:/usr/local/ssl/lib
export LD_LIBRARY_PATH
Andrew Sullivan wrote:
On Wed, Jan 22, 2003 at 12:27:40PM -0600, Matt Mello wrote:
I'm having trouble compiling pg7.3.1 for Sol7.
The configure command I use
nt: 14 March 2003 17:55To: 'Matt
Clark'Cc: [EMAIL PROTECTED]Subject: Re: [ADMIN]
LVM snapshots
Try - [GENERAL] A few questions to real pgsql gurus
Ben
Thanks Murthy, that's exceptionally helpful!
Does anyone know what (in general) would cause the notices that Murthy spotted in the
logs as per the snippet below?
> The postmaster is started and stopped on the backup server, so that any
> problems can be identified right away. (Notice the "ReadR
there some unknown amount of time that
will pass before it will be ready? The postmater docs didn't seem to
indicate that once you run it, it is absolutely ready for connections.
Thanks!
--
Matt Mello
---(end of broadcast)---
TIP 1: subscribe
A P3
1GHz is probably roughly equivalent to a P4 1.5GHz, so going from dual P3 1GHz
to single P4 2.4GHz would likely be slower in any case. Don't forget that
unless you're talking about the "Xeon MP" then the whole "Xeon" tag is pretty
meaningless for the P4 range.
If
you moved to a *dua
Well, I usually am under a misapprehension! Thanks for the explanation about LIMIT
too.
In that case then, I shall stop worrying and learn to love the planner.
M
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 08 August 2003 16:15
> To: Matt Clark
.0025effective_cache_size = 262144 # 2GB of FS cacherandom_page_cost =
2
For now the planner seems to be making the right choices, but
my concern is that at some point the planner might start making some bad
decisions, especially on more complex queries. Should I bother tweaking
the planner costs
27;;
Does the first case generate any more dead tuples that will need vacuuming than the
second case, or are the two updates 'merged'
when the transaction is committed? Or is the answer 'sometimes' (I would guess
depending on checkpoints)?
Cheers
Matt
> > It is crashing the linux box. Not rebooting, not kernel panic,
> but only stop
> > to respond.On the console if I type reboot it will not to
> reboot and so on.
> > But it crash only if I start intensive operations on pg.
If you can type 'reboot' then surely it hasn't stopped responding?
--
I rather like it actually. Cisco equipment has a 'show tech-support' command that
does exactly that, dumps all the config, HW/SW
versions, current state, you name it. If you have a problem you run that, attach the
output to yr support email, and 99% of the
time there's enough info there to solv
It won't work.
You could instead have a separate boolean attribute called 'expired' for
each row. Set this to true whenever you expire the row, and create the
partial index using that attr.
Matt
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL P
> I could made persistent connection, but with 10.000 clients it will kill
> the server.
But if they're virtual domains, why would you need one connection per domain? You
should only need one connection per apache
process...
---(end of broadcast)
Ooh, I see. That's a tricky one. Do you really need that level of separation?
> Because every virtual domain has its own database, username and
> password. So one client domain1.com with db: domain1db user: domain1user
> cannot access to second client database domain2.com db: domain2db user:
>
> W liście z pią, 31-10-2003, godz. 12:25, Matt Clark pisze:
> > Ooh, I see. That's a tricky one. Do you really need that level of separation?
>
> Well, if you talk with the clients, and they promise, that they will not
> access to other databasess, and specially
more constructive ;-)
M
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marek Florianczyk
> Sent: 31 October 2003 13:20
> To: Jamie Lawrence
> Cc: Matt Clark; [EMAIL PROTECTED]
> Subject: Re: [ADMIN] performance problem - 10.000 databases
>
>
.
Yet one more solution, and I don't know if it is possible or not, is to wrap
your application with a small script that will set the environment for you such
as:
#!/bin/sh
export LD_LIBRARY_PATH=.
/usr/local/apache/cgi/asd.cgi (or the like)
HTH's
Matt
Quoting "Siddhar
> I got all your points, thanks for such a great discussion, Now the last
> thing I want is how can I close the data files and flush the cache into
> the data files. How can I do this in postgresql
pg_ctl stop
---(end of broadcast)---
TIP
ho knows whether the
files have _really_ been written to disk after an fsync. Postgres just has to believe
what the operating system tells it...
Matt
> Don't joke, this for stopping the Postgres Server. I want close the
> files in between the database operations. I am looking for s
PG
will believe it has 'crashed' when you start it from a restored snapshot, and PG
is designed to recover perfectly well from crashes. If you stop the
postmaster before the snapshot is taken then it will definitely work
fine.
Matt
-Original Message-From:
[EMAIL P
> .. I can't _quite_ tell if you're serious or not ... :)
>
> If you are serious, are you saying to do something like:
>
> CREATE TABLE new_money (product text, dollars int4, cents int4);
Ha :-) That would not be serious. I'm pretty sure he meant to just store the product
cost in cents instea
BEGIN;
DELETE FROM mytable;
!!! OOOPS
ROLLBACK;
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Jeremy Smith
> Sent: 20 February 2004 06:06
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] "DELETE FROM" protection
>
>
>
> This may be an all-time idio
manipulate the data.
Matt
[1] There are ways of avoiding having to enter the info manually, but
they're very tricky to implement securely.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister comma
And how does one account for key information? If one encrypts any information
deemed worthy to be a key then you have to decrypt the entire database to find
particular information.
Of course, you could keep keys unencrypted for use, but then again, why encrypt
it at all?
Quoting Mitch Pirtl
Quoting Mitch Pirtle <[EMAIL PROTECTED]>:
> Matt Davies wrote:
>
> > And how does one account for key information? If one encrypts any
> information
> > deemed worthy to be a key then you have to decrypt the entire database to
> find
> > particular informa
ut of keys(%hash) is NOT ordered! Try:
foreach $company_id ( sort keys %traffic ) {
foreach $ip_id ( sort keys %{$traffic{$company_id}} ) {
foreach $port ( sort keys %{$traffic{$company_id}{$ip_id}} ) {
Matt
---(end of broadcast)---
an
explanation as to why it's no longer available ANYWHERE!
Anybody know of a similar project out there -- or why this fell off the
face of the earth? (Patents maybe?)
Matt D.
---(end of broadcast)---
TIP 9: the planner will ignore your des
bunch of zero-length files
and symlink them in advance, but that's perhaps _too_ kludgey...
I'm having a rummage around in the code at the moment, and it seems like it
might be possible to get PG to put each table in its own directory. Anybody
seen that tried before?
Cheers
Matt
s and symlink them in
advance...
Cheers
Matt
s basically, as comparing
the price of a terabyte of ATA mirrored disks and the same TB on SCSI
hardware raid is enlightening.
M
-Original Message-
From: Bradley Kieser [mailto:[EMAIL PROTECTED]
Sent: 06 May 2004 11:03
To: Matt Clark
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [
Hello all!
I apologise in advance if any of my questions are in a FAQ somewhere - I
haven't seen them...
Does anyone know when (if ever) replication support will be added to the
main PostgreSQL codebase? Is there any chance it'll be included in the
upcoming 7.5 release?
I've taken a look at the
On 06 July 2004 16:41, Christopher Browne wrote:
> > I've taken a look at the replication solutions already available,
> > including the sterling effort made on Slony-I, but we're really
> > looking for integrated, base-level support rather than an add-in.
>
> The problem is that "replication" d
omers-- both legally and
ethically-- more than we got (which was nothing-- no notice, no
explanation, no refund, no data, no contact info, no nuthin).
Thank you,
-Matt
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose
When migrating our Postgres databases from 32 to 64-bit systems, including
large binary objects, how well will this work?
32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb
64-bit server) pg_restore -d mydb backup.pg
I'm hoping that PG's compressed custom archive format is
Matt
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Tino Schwarze
Sent: Tuesday, March 30, 2010 9:39 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Migrate postgres to newer hardware
Hi Renato,
dump/restore is
I'm trying to get started with Streaming Replication and Hot Standby using
PostgreSQL 9.0 (9.0.0-1PGDG.el5 installed from PGDG).
I've followed the instructions at
http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Binary_Replication_in_6_Steps
using two fresh databases, but I'm not hav
oughts?
Thanks,
--
Matt Williams
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
version 9.1
--
Matt Williams
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
On Friday, April 6, 2012 at 4:04 PM, Scott Whitney wrote:
> What version, Matt? I had that problem back in 8.1x
>
> > I have a database that is utf8 and displays utf8 values correctly in psq
With that same dump file that is displaying incorrectly open in vim, I can
paste in the utf8 character I provided as an example and it displays correctly.
--
Matt Williams
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
On Friday, April 6, 2012 at 4:03 PM, Steve Crawford wrote
I ran it through xxd and the hex-bytes are different than those of the proper
utf8 character:
03300a0: 7472 c383 c2b6 6d65 7209 3009 5c4e 0931 trmer.0.\N.1 (from the
dump file)
ö : c3b6
ö : c383 c2b6
--
Matt Williams
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
On
56 matches
Mail list logo