> On Apr 21, 2017, at 3:29 PM, Michael Paquier <michael.paqu...@gmail.com>
> wrote:
>
>> On Sat, Apr 22, 2017 at 3:02 AM, Ian Harding <harding@gmail.com> wrote:
>> Am I misunderstanding how this works? I have WAL archiving set up, so the
>> files ar
I used this command to set up a streaming replica and it worked perfectly.
I tried to run it to create an online backup of the master on that replica
for backup purposes and it seems not to have worked as well.
I thought that streaming the WAL would eliminate the need to keep tons of
WAL around,
I have a function that returns bigint[] and would like to be able to
compare a bigint to the result.
freeload= select fn_descendents('trip'::varchar,61::bigint);
fn_descendents
---
{935,815,689,569,446,325,205,191}
(1 row)
freeload= select 935::bigint in
On Fri, Dec 5, 2014 at 4:55 PM, Ian Harding harding@gmail.com wrote:
I have a function that returns bigint[] and would like to be able to
compare a bigint to the result.
freeload= select fn_descendents('trip'::varchar,61::bigint);
fn_descendents
Forgot to include the list! Sorry!
If you have a non-standard socket file location pg_upgrade will not work
for this upgrade.
On Fri, Apr 5, 2013 at 9:37 AM, Leonardo Carneiro chesterma...@gmail.comwrote:
Beside all notes, i recommend you to use pg_upgrade, to avoid a complete
backup/restore
Ack! Sorry. Bad list etiquette in so many ways...
-- Forwarded message --
From: Ian Harding harding@gmail.com
Date: Sun, Mar 3, 2013 at 8:26 PM
Subject: Re: [GENERAL] pg_upgrade
To: Bruce Momjian br...@momjian.us
It doesn't seem to though. Here's what I get when I leave
with the -w flag.
On Thu, Feb 14, 2013 at 10:41 PM, Ian Lawrence Barwick barw...@gmail.comwrote:
2013/2/15 Ian Harding harding@gmail.com
On Feb 14, 2013, at 9:50 PM, Ian Lawrence Barwick barw...@gmail.com
wrote:
2013/2/15 Ian Harding harding@gmail.com
When I run pg_upgrade
instantly.
On Fri, Feb 15, 2013 at 9:19 AM, Jeff Janes jeff.ja...@gmail.com wrote:
On Fri, Feb 15, 2013 at 4:54 AM, Ian Harding harding@gmail.com
wrote:
I don't think it would get any further... It fails and --retain says
Retain sql and log files after success I can look at that log file
is not supported when starting a pre-9.1 server\n),
On Fri, Feb 15, 2013 at 9:45 AM, Ian Harding harding@gmail.com wrote:
-
pg_upgrade run on Fri Feb 15 05:09:34 2013
environment variable is set to match.
I'll try that tonight.
On Fri, Feb 15, 2013 at 10:09 AM, Ian Harding harding@gmail.com wrote:
This is interesting, although I'm not sure it's relevant. From pg_ctl
source.
00477
write_stderrhttp://doxygen.postgresql.org
When I run pg_upgrade, it tries to start the old cluster with the -w flag,
which waits a while and declares failure, even though it starts the
server. If I start/stop without -w everything is great.
Can I tell pg_upgrade not to use that flag, or is there a reason it is not
working that I should
Old is 8.4, new is 9.2. I am not supplying an but the minimum options and
--check succeeds. My pg_ctl fails when run by hand with -w (although the
database does start) so I know that's the issue.
On Feb 14, 2013, at 9:50 PM, Ian Lawrence Barwick barw...@gmail.com wrote:
2013/2/15 Ian
On Tue, Nov 6, 2012 at 5:45 AM, Kevin Grittner kgri...@mail.com wrote:
Darren Duncan wrote:
Ian Harding wrote:
It says everything is happy as normal...
2012-11-05 16:22:41.200 PST - :LOG: invalid record length at BA6/6DCBA48
What does this log line mean? Is that happy as normal
I had a 9.0.8 hot standby setup, one master, two slaves, working great.
Then, I tried to re-initialize by making a base backup, the way I've done
it many times before, but for some reason I can't get the standby to accept
connections. I copied the postgresql.conf and recorvery.conf out of the
On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman netll...@gmail.com wrote:
On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding harding@gmail.com wrote:
I had a 9.0.8 hot standby setup, one master, two slaves, working great.
Then, I tried to re-initialize by making a base backup, the way I've
On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman netll...@gmail.com wrote:
On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding harding@gmail.com wrote:
On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman netll...@gmail.com
wrote:
On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding harding
On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman netll...@gmail.com wrote:
On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding harding@gmail.com wrote:
On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman netll...@gmail.com
wrote:
On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding harding
I know this is the wrong place, but I tried creating an account on
their site to contact them and it does not work.
The 9.0.10 package throws an error when I try to install it that it
has an unsatisfied dependency on libpython. Since it brings its own
libraries, I'm not sure why that would be,
On Thu, Oct 11, 2012 at 8:56 AM, Scott Mead sco...@openscg.com wrote:
Hey Ian,
On Thu, Oct 11, 2012 at 10:52 AM, Ian Harding harding@gmail.com wrote:
I know this is the wrong place, but I tried creating an account on
their site to contact them and it does not work.
I'll take a look
I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys and a trigger.
Clearly, something is causing a resource contention issue, but here's
my main question:
I have log_lock_waits = on and
On Sunday, May 20, 2012, Martijn van Oosterhout wrote:
On Sun, May 20, 2012 at 12:26:26AM -0700, Ian Harding wrote:
I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys
On Thu, Oct 20, 2011 at 11:42 AM, Raghavendra
raghavendra@enterprisedb.com wrote:
On Thu, Oct 20, 2011 at 11:58 PM, John R Pierce pie...@hogranch.com wrote:
On 10/20/11 2:33 AM, Raghavendra wrote:
Am assuming you are having $PGDATA (data directory) and their WAL
Archives.
he said he
If someone happened to accidentally end up with a lot of files that
were NOT part of their database in the data/base/X directory, how
could they go about getting a reliable list of files they could safely
delete? The files were there before the current incarnation of the
database, so have
Well, they are actually streaming replication slaves, and I boogered
up the rsync command, so there they are. I diffed the directories
from the master to the slave, and think I will go ahead and delete all
the files that don't appear in both places and see what happens.
Worst case, I have to set
On Thu, Sep 29, 2011 at 5:32 PM, Fujii Masao masao.fu...@gmail.com wrote:
On Fri, Sep 30, 2011 at 1:35 AM, Ian Harding harding@gmail.com wrote:
I updated the firewall rules on a streaming replication standby server
and thought nothing of it. I later happened to notice on the primary
I updated the firewall rules on a streaming replication standby server
and thought nothing of it. I later happened to notice on the primary
that ps aux | grep stream didn't show streaming to that server
anymore. On the standby that command still showed the wal receiver
patiently waiting for new
Oracle has a configuration option for its version of hot standby
(DataGuard) that lets you specify a time based delay in applying logs.
They get transferred right away, but changes in them are only applied
as they reach a certain age. The idea is that if something horrible
happens on the master,
On Fri, Sep 16, 2011 at 8:35 AM, hubert depesz lubaczewski
dep...@depesz.com wrote:
On Fri, Sep 16, 2011 at 08:02:31AM -0700, Ian Harding wrote:
Oracle has a configuration option for its version of hot standby
(DataGuard) that lets you specify a time based delay in applying logs.
They get
If you install using a package manager, you might only have to install
the postgresql-pltcl (or similarly named) package, then do
createlang pltcl mydatabase
from the command line and you are ready to go. If you build from
source, you have to worry about prerequisites yourself.
On Thu, Sep 15,
I have never had this particular problem in PostgreSQL, it seems to
just know when queries can be flattened and indexes used. I know
that takes tons of work. Thank you for that.
Here's the Oracle question.
http://stackoverflow.com/questions/1439500/oracle-index-usage-in-view-with-aggregates
I
On Wed, Sep 3, 2008 at 10:36 AM, William Garrison [EMAIL PROTECTED] wrote:
When I attended the PostgreSQL East conference, someone presented a way of
doing this that they used for http://www.mailermailer.com/ and they did
this:
SET constraint_exclusion = on;
EXPLAIN
SELECT
*
FROM
On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane [EMAIL PROTECTED] wrote:
Ian Harding [EMAIL PROTECTED] writes:
Is there any way to tell if a trigger or triggers are disabled on a
table? I was updating some data a week or two ago and must have
forgotten to re-enable the triggers. Took me a little
Is there any way to tell if a trigger or triggers are disabled on a
table? I was updating some data a week or two ago and must have
forgotten to re-enable the triggers. Took me a little while to figure
out. \d tablename didn't tell me, nor did \d+ tablename.
This is on 8.2.3.
Thanks,
- Ian
I accidentally formatted a string for tsearch before trying to cast it
to a date, and it worked!
select 'June152007'::date
date
2007-06-15
(1 row)
Is this a happy accident, or is it OK to count on it continuing to
work this way?
Thanks,
Ian
---(end of
On 6/5/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Mon, Jun 04, 2007 at 08:25:22PM -0700, Ian Harding wrote:
I know this is a question that gets asked a zillion times and is
almost always pilot error.
I don't know much about this but the complaint is this:
The usual error about
On 6/3/07, PFC [EMAIL PROTECTED] wrote:
Yeah, it is awful ;^) However the existing system is equally awful
because there is no way to enter NULL!
Consider this form :
First name :Edgar
Middle name : J.
Last name : Hoover
Now, if someone has no middle name, like John Smith,
I know this is a question that gets asked a zillion times and is
almost always pilot error.
I installed PostgreSQL 8.2.x and the Tsearch2 package on NetBSD which
went fine, but I can't get the tsearch2.sql file to run.
The usual error about file does not exist relative to
$libdir/tsearch2 gets
On 6/2/07, Alexander Staubo [EMAIL PROTECTED] wrote:
On 6/2/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote:
I don't know if it's a general problem, but I've been involved in a
using rails and it appears to have it's own way of declaring the
database. It presumes to handle referential
An empty string is not null! Null means the value is missing, which is
clearly not the case here. I would say Rails is exactly in the right
here. When an HTML form is posted, empty input boxes are declared as
empty strings, which what the user entered. The problem is not with
Rails/ActiveRecord
On 6/3/07, Alexander Staubo [EMAIL PROTECTED] wrote:
On 6/3/07, Ian Harding [EMAIL PROTECTED] wrote:
An empty string is not null! Null means the value is missing, which is
clearly not the case here. I would say Rails is exactly in the right
here. When an HTML form is posted, empty input
On 31 May 07 09:46:47 -0700, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello all -
I'm working on a site with PHP and Postgres, coming from a MySQL
background.
I was looking for an equivalent to the mysql_insert_id() function, and
a site recommended this:
Another option is
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values you are looking for.
In my experience, the LIKE searches are fast for
On 5/31/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Ian Harding wrote:
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values
This keeps biting me. In a trigger function for INSERT OR UPDATE if you try
IF TG_OP = 'UPDATE' AND OLD.foo = 'bar' THEN
...
it will blow up on inserts because there is no OLD. I always expect
this to short circuit and am always disappointed. Easy fix, of
course...
IF TG_OP = 'UPDATE' THEN
Postgres set this up and take a cut.
On 5/16/07, Ian Harding [EMAIL PROTECTED] wrote:
Well, I didn't do that, but as an exercise I split the manual in 740
page chunks (maximum size at lulu), which misses the last couple
hundred pages (old release notes and index, mostly) and put them on
lulu
On 5/14/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Rich Shepard wrote:
On Mon, 14 May 2007, Bruce Momjian wrote:
How much would it be to email the PDF manual to someone like Kinkos and
get it printed? Effectively, that might be the cheepest solution because
it is print-on-demand.
What I
Or use a SAVEPOINT. I don't know about the impact on resources if you
leave it hanging around for a long time, but I use these for exactly
the scenario you are talking about.
- Ian
On 4/16/07, Martin Langhoff [EMAIL PROTECTED] wrote:
On 4/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Seems overly
On 2/22/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Joshua D. Drake escribió:
Andrej Ricnik-Bay wrote:
On 2/23/07, Jim Nasby [EMAIL PROTECTED] wrote:
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
On 2/21/07, Tom Lane [EMAIL PROTECTED] wrote:
Ian Harding [EMAIL PROTECTED] writes:
I had views that used syntax like
WHERE datecol current_date and (otherdatecol is null or otherdatecol
current_date)
Suddenly, this is ungodly inefficient in 8.2.3. It worked just fine in 8.1.3
of SQL and are upgrading to
8.2.X, it might be a problem.
- Ian
On 2/21/07, Ian Harding [EMAIL PROTECTED] wrote:
This whole thing strikes me funny since my application has run fine
for 6 years and now I have queries that simply take forever, and even
had one that threw an error (Tom fixed
On 2/18/07, Chris [EMAIL PROTECTED] wrote:
Toby Tremayne wrote:
Hi all,
I'm just experimenting with tsearch2 - I have it all working fine but I
was wondering if there's a way to create indexes containing vector
columns from multiple tables? Or if not, how do people usually manage
this
On 2/17/07, Rick Schumeyer [EMAIL PROTECTED] wrote:
This may be bad design on my part, but...
Not at all. Very common scenario
I have three tables of interest...Account, Employee, and
AccountEmployeeRelation. There is a many-to-many relationship between
accounts and employees. The join
On 2/16/07, Rafa Comino [EMAIL PROTECTED] wrote:
Hi from Spain,
I have a problem with TSearch2,
I have a table with more than a million registers (a table of books, for
example),
I made a tsearch2 index for one of my fields (the title of the books, for
example),
I make queries from that
On 2/16/07, Lou Duchez [EMAIL PROTECTED] wrote:
Like everyone else, I use pg_dump for backup purposes; I have a cron job
that runs a pg_dump whose output is then FTP'd elsewhere. Two things
that would make my life easier:
1) grant select on database ... or, hypothetically, grant select on
On 2/12/07, Bill Moseley [EMAIL PROTECTED] wrote:
I'm looking for a little guidance in representing a file system --
well just the file and directory structure of a file system.
Often articles on representing a hierarchy discuss the advantages of
using Nested Sets (or nested intervals) it
On 2/12/07, Bill Moseley [EMAIL PROTECTED] wrote:
On Mon, Feb 12, 2007 at 10:53:53AM -0500, Merlin Moncure wrote:
On 2/12/07, Richard Broersma Jr [EMAIL PROTECTED] wrote:
Can you describe in a little bit more detail about what you mean by
'Adjaceny LIst'?
Adjaceny list is the term used
A thousand words. I like the brevity of this post:
http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
Can't really argue with it.
- Ian
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
Brazil has been trying to get its ISPs to block access to a certain
video. I wonder if too wide a net was cast in that effort.
http://www.slate.com/id/2157399/?nav=navoa
On 1/17/07, Jorge Godoy [EMAIL PROTECTED] wrote:
Bruno Wolff III [EMAIL PROTECTED] writes:
Be sure you aren't blocking
There is no GUI tool that I know of, but there is EXPLAIN which gives
the same information.
- Ian
On 1/8/07, guillermo arias [EMAIL PROTECTED] wrote:
is there a tracking trace tool in postgre? like the SQL Analizer in MS
sqlserver.
I have downloaded the PGAdmin III and i have not found any
in the settings.
On 1/8/07, Ian Harding [EMAIL PROTECTED] wrote:
There is no GUI tool that I know of, but there is EXPLAIN which gives
the same information.
- Ian
On 1/8/07, guillermo arias [EMAIL PROTECTED] wrote:
is there a tracking trace tool in postgre? like the SQL Analizer in MS
sqlserver
On 1/8/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
On 1/8/07, Jeffrey Melloy [EMAIL PROTECTED] wrote:
Not exactly. SQL Analyzer also includes live monitoring of
whatever queries are coming into the database. You can
If you have a dot in your gmail username, take it out. Gmail ignores
it and validation scripts often puke on it.
Then use that email as your reply to, not some nonexistent carp.
- Ian
On 12/13/06, wheel [EMAIL PROTECTED] wrote:
I seem to have a natural knack for hitting the ruts around here,
On 11/13/06, Scott Marlowe [EMAIL PROTECTED] wrote:
On Mon, 2006-11-13 at 15:36, novnov wrote:
OK, thanks everyone, I gather from the responses that postgres performance
won't be an issue for me then. If MS SQL Server and Postgres are in the same
ballpark performance-wise, which seems to be
If first period end and second period start dates are the same, I need that in
this case expression
returns true.
Is it possible to implement this using OVERLAPS operator ?
I think the best workaround is a function of some kind in whichever
language you choose. I think you could actually
On 11/2/06, louis gonzales [EMAIL PROTECTED] wrote:
Hey Brian,
Yeah I had considered this, using cron, I just feel like that is too dirty.
Actually I didn't see Andreas' post, can someone forward that?
I'm running this application on Solaris 9. Ultimately what I want to
know is, is there
On 10/20/06, Tom Lane [EMAIL PROTECTED] wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Shane Ambler wrote:
The one thing worse than kill -9 the postmaster is pulling the power
cord out of the server. Which is what makes UPS's so good.
If your server is changing the data file on disk and
On 8/2/06, Flemming Frandsen [EMAIL PROTECTED] wrote:
Ian Harding wrote:
NOTIFY interacts with SQL transactions in some important ways.
Firstly, if a NOTIFY is executed inside a transaction, the notify
events are not delivered until and unless the transaction is
committed
On 8/1/06, Carlo Stonebanks [EMAIL PROTECTED] wrote:
I have been trying to figure out where to put my plTcl questions, and where
the people most knowledgable about that topic may be – either on these mail
lists or elsewhere.
TCL is dead. Long live TCL.
PLTCL was taken out of the core
On 8/1/06, Flemming Frandsen [EMAIL PROTECTED] wrote:
I have an application that does aggresive caching of data pulled from
the database, it even keeps the objects cached between transactions.
Normally this works very well and when the cache is warmed up about 90%
of the database time is saved.
On 8/1/06, Christopher Browne [EMAIL PROTECTED] wrote:
Martha Stewart called it a Good Thing when Carlo Stonebanks [EMAIL
PROTECTED] wrote:
I am interested in finding out a non-religious answer to which
procedural language has the richest and most robust implementation
for Postgres. C is at
It's here now. I think it used to be in the main distro, but has been
moved out recently.
http://pgfoundry.org/projects/pgtcl/
On 24 Jul 2006 03:07:59 -0700, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hello everybody,
I must replace an old server by a new one, and I decide to upgrade
I wasn't trying to fight it. It's just that the port disagrees with the
PG documentation and apparently most other ports. The maintainer said
it was for backward compatibility but it's apparently only a FreeBSD
phenomenom :-)
It may be a *BSD pheonomenon, since I know it applies in NetBSD as
postgresql_autodoc and dia.
On 28 May 2006 05:19:04 -0700, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
What open source tool do people here like for creating ER diagrams?
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
There used to be a knob that would allow you to temporarily see
deleted tuples. Don't know if it's still there. Sounded kinda
dangerous.
http://archives.postgresql.org/pgsql-patches/2005-02/msg00126.php
Also, you could start (now) using PITR so you could simply restore to
the moment before
You should look up the contrib module ltree which is made for this
sort of thing. If you reinvent the wheel like this, you will be stuck
with 2 levels. With ltree you can have as many as you need and add
more at any time. It lets you query for ancestors and descendants of
any item at any level.
This problem has been solved, by the use of sequences. If you can't
use them as a default, you can use them instead of
MAX(clipid)
You would use
NEXTVAL(clipid_seq)
assuming you had first done
CREATE SEQUENCE clipid_seq;
SELECT SETVAL('clipid_seq', (select MAX(clipid) from whatevertable));
This is interesting.
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/
There are a few bugs
1. In the graphic overview PostgreSQL == Progres
2. In description of PostgreSQL database cluster, After
initialization, a database cluster contains a database called
The docs state that postmaster.pid is A lock file recording the
current postmaster PID and shared memory segment ID (not present after
postmaster shutdown
I never looked until now, but I see the number 5432001 where the pid
should be, and the real pid is in /tmp/.s.PGSQL.5432.lock, along with
the
A commonly overlooked comparison for always on systems is to compare
what sorts of operations you can do to databases without needing to
restart the server or drop tables, lock out users etc.
We use Sybase Adaptive Server Anywhere 8 here and the thing that
annoys me about it is exactly this.
On 3/29/06, David Bernal [EMAIL PROTECTED] wrote:
I recently have been attempting to get my install of postgresql 8.1
(running Win XP as OS) to listen on both 127.0.0.1 and my IP address,
192.168.0.100 (inside my network, obviously.) As such, I tried first
setting listen_addresses =
I'm wondering if I could get some suggestions as to how implement
this quickly and simply? I was thinking a web interface using PHP
would be the fastest way of going about it.
If you used Ruby on Rails, you'd be finished by now. It slices, it
dices, it makes julienne fries.
Seriously,
On 3/24/06, Ben [EMAIL PROTECTED] wrote:
My understanding is that a stored procedure does an implicit begin/commit when
it executes. Maybe my brain isn't working so well this morning, because I
can't
figure out how I would do:
begin;
call stored proc;
call another stored proc;
commit;
On 3/16/06, Tomi NA [EMAIL PROTECTED] wrote:
On 3/13/06, Claudio Tognolo [EMAIL PROTECTED] wrote:
I can disable the Trigger?
I'd like to know how this could be done, as well. What I really need is a
hold-off-all-triggers-untill-I-tell-you-to command, but
hey, making a trigger just not
And it's been a while; but I thought transactions like that could
overflow rollback segments in that other database.
ORA-01555: snapshot too old: rollback segment number string with name
string too small
Cause: Rollback records needed by a reader for consistent read are
overwritten by
On 3/15/06, chris smith [EMAIL PROTECTED] wrote:
Hi all,
Just wondering which full text module is better what the differences
are between tsearch and fti ?
Having only used tsearch/tsearch2 all I can say that it works as
advertised and I am extremely happy with it.
- Ian
The big job is populating the index columns. I think you can only put
the full text index column in the same table as the referenced
columns. In other words, you will end up with 3 tables, each with a
ftidx column. I hope your docs show how to create and populate the
indexes and to create
On 1/8/06, Guy Rouillier [EMAIL PROTECTED] wrote:
Carlos Moreno wrote:
Any comments? If it is the first option above, then it feels like
by definition there is absolutely nothing that can be done, now or
ever :-(
I got an IMAP account with BurntMail.com. I belong to a dozen mailing
On 1/7/06, Magnus Hagander [EMAIL PROTECTED] wrote:
A recent article about an Oracle worm:
http://www.eweek.com/article2/0,1895,1880648,00.asp
got me wondering.
Could a worm like this infect a PostgreSQL installation?
It seems to depend on default usernames and passwords - and
lazy
As I recall, the MS SQL Server draggy droppy diagrammer tool made it
seem trivial to rearrange columns did the same thing. It just
generated SQL statements to:
Begin transaction
select data in new order into a new table
drop dependent objects
drop old table
rename new table
re-create dependent
On 12/28/05, Dmitry Panov [EMAIL PROTECTED] wrote:
On Wed, 2005-12-28 at 13:38 +0100, Martijn van Oosterhout wrote:
On Wed, Dec 28, 2005 at 03:17:40PM +0300, Dmitry Panov wrote:
I'm currently considering setting up online backup procedure and I
thought maybe it would be a useful feature
On 12/28/05, Dmitry Panov [EMAIL PROTECTED] wrote:
On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
Dmitry Panov [EMAIL PROTECTED] writes:
Yes, but if the server has crashed earlier the script won't be called
and if the filesystem can't be recovered the changes will be lost. My
point
On 12/28/05, John McCawley [EMAIL PROTECTED] wrote:
I am currently having a problem with a query never finishing (or at
least not in a reasonable amount of time.) I have had similar problems
to this in Postgres over the past several years, and I have always found
workarounds. This time I'd
I have a file which is a long series of SQL commands. Creating
tables, copying in data, indexing, munging the data, intermittently
vacuuming to keep things moving.
I have usually run this big script like this:
nohup psql dbname script.sql
After upgrading to 8.0, the script to slow to a crawl
On 11/1/05, Andrew Rawnsley [EMAIL PROTECTED] wrote:
They actually did make _some_ strides. The installer actually works
consistently (knock on veneer-covered-pressboard), which is something I
haven't seen since the pre-8i text-mode installs...
Doesn't quite compare to the 5 minute
On 10/8/05, Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
I use PostgeSQL less than year. Before I worked with MS SQL Server
2000, MySQL 34, Oracle8i and Interbase. Also, I studied standards
SQL:1999 and SQL:2003. So, after switching to PostgreSQL I've
encountered with several things that seem
On 10/6/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
On Thursday 06 October 2005 18:20, Tom Lane wrote:
No, there's no reason for 8.0 to be slower at this than 7.4, if all else
is equal. I'm betting that all else is not equal. Maybe you are using
a different encoding or locale in the
On 9/6/05, Jürgen Rose [EMAIL PROTECTED] wrote:
I did some serious stuff with SQLServer and Interbase, and I had
**never** those performance problems.
On a laptop? Under VMWare?
I have used MSSQL Server too, and find PostgreSQL to compare favorably
in most cases. You may have found a
Mine in similar, and the only thing I have changed from defaults is
work_mem. It made certain complex queries go from taking forever to
taking seconds. I have a database connection pool limited to 10
connections, so I set it to 10MB. That means (to me, anyway) that
work_mem will never gobble
My first idea when this was mentioned was more like
ALTER TABLE CASCADE
where CASCADE meant recompile all the views that depend on that table.
Not that I think any of this is a good idea, but if it was going to be
done, that's what would make the most sense to me.
- Ian
Brand X simulates this in their GUI diagrammer by tracking
dependencies and dropping and recreating dependent views on schema
changes. This might be a better job for one of the GUI tools for us
too, rather than trying to put it in the back end. Brand X doesn't do
it in their backend either.
On
1 - 100 of 157 matches
Mail list logo