at how it affects _this_ list every time he starts
bitching, for example.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
In response to Tom Hart [EMAIL PROTECTED]:
Bill Moran wrote:
[snip]
To a large degree, I think Karoly has blown the situation out of
proportion. Look at how it affects _this_ list every time he starts
bitching, for example.
Is it just Karoly (chx) who has all these things to say
In response to dvanatta [EMAIL PROTECTED]:
What's up with 3 of the 7 being from Pennsylvania? What's the connection?
Well, as everyone knows, Pennsylvania is a haven for brilliant
people. In fact, simply living in Pennsylvania makes you smarter.
--
Bill Moran
http://www.potentialtech.com
out your product to your client.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
)
index creation)
1) It only needs to be done once
2) You can remove the indexes from the replica and add them back in after
the initial sync is complete.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 2: Don't 'kill -9
PostgreSQL have a
pg_pretend_to_escape_string() that effectively does nothing?
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
: FATAL: database postgres does not exist
why? Is it not possible to have multiple version installations i the same
machine(in different ports)?
PostgreSQL 7.4 doesn't install a postgres database by default. Try
explicitly connecting to template1.
--
Bill Moran
http://www.potentialtech.com
on to Thomas' comment. You can also install OpenOffice.org with
the pgsql ODBC driver and use the OOo spreadsheet to access data directly.
I haven't done this, personally, so I can't vouch for how well it works.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast
of windows on top of
my old version.
zip :-)
Can someone tell me what I am doing wrong? We have an end of the year
rush and we have a number of people world wide who would be using
this once we can actually test it.
Bill
---(end of broadcast)---
TIP 3
://www.postgresql.org/docs/8.3/static/app-initdb.html
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Sebastien ARBOGAST [EMAIL PROTECTED] wrote:
2007/12/15, Bill Moran [EMAIL PROTECTED]:
Sebastien ARBOGAST [EMAIL PROTECTED] wrote:
I'm trying to start postgreSQL server on my Macbook Pro. I've
installed it using packages available here:
http://www.kyngchaos.com/wiki
In response to D. Dante Lorenso [EMAIL PROTECTED]:
Bill Moran wrote:
D. Dante Lorenso [EMAIL PROTECTED] wrote:
All,
I'd really like to have ORDER BY and LIMIT for UPDATE and DELETE
commands. Is this possible?
UPDATE invoice i
SET reserve_ts = NOW() + '1 hour'::timestamp
not going to argue as to whether your suggestion would be
a good idea or not, I will suggest you look at SELECT FOR UPDATE, which
will allow you to do what you desire.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 2: Don't
advanced.
I do see it from other perspectives. I can still see it from the
perspective of a Bill Moran from 10 years ago who got chewed out for
top-posting because I didn't know anything and didn't get very good
help because I didn't formulate good questions. That's a Bill Moran
who learned
people begin
ignoring the thread, and this is what me (and others) who say please don't
top-post are trying to avoid.
If you want to turn it into some personal war or something, please don't
do it on the list.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast
in
stock is greater than zero.
Did anyone knows how can i do that with postgre?
Thanks a lot.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
In response to Joshua D. Drake [EMAIL PROTECTED]:
Thanks to all the testing, feedback and bug reports the community has
performed with the current betas, we now have our fourth beta
of 8.4.
I assume you meant 8.3.
--
Bill Moran
http://www.potentialtech.com
---(end
?
Andrus.
PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Bill Moran
http://www.potentialtech.com
Use select pg_cancel_backend(pid) instead -- we have to do this periodically
when queries get timed out by the web server but Postgres doesn't notice /
doesn't get notified...
- Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Cole
Sent
down.
Are you sure you're interpreting that number correctly? I took it to
mean a counter of the number of delete operations since server start.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 9: In versions below 8.0
In response to Ow Mun Heng [EMAIL PROTECTED]:
On Thu, 2007-11-08 at 12:02 -0500, Bill Moran wrote:
Frequently, when people ask for help because they've exceed max_fsm*,
it's because they're not paying attention to their systems, and therefore
the problem has been occurring for a while
are monitoring their databases closely don't hit this
problem nearly as often.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
out on import, there is no resource
starvation in any way
You do realize that you're contradicting yourself here, right?
The advice provided by others is good as well, so I won't repeat it.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast
In response to Gauthier, Dave [EMAIL PROTECTED]:
One question I had earlier that I don't think got answered was how to
undo an initdb. dropdb drops a DB, but how do I undo an initdb?
rm -rf the directory in which you put the initdb.
--
Bill Moran
http://www.potentialtech.com
is _not_ for top-posting -- perhaps you
should either follow the preferences of the group, or leave the group.
But this horse has been beat to death before...
Obviously not, as it keeps coming back to life. I guess it's an
undead horse?
--
Bill Moran
http://www.potentialtech.com
and vmstat results of postgresql
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Reg me Please
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Bill Moran
http://www.potentialtech.com
the sequence without actually adding
rows.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
is that
it locks tables while working on them, so you have to take into account
what other workload might be blocked while vacuum full is working, and
how long vacuum full is liable to take.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast
suffer horribly from this and reconnected, and that the database
finished up its recovery in a timely manner.
Hopefully, I can generate a reproducible example so I can file a
bug, but haven't gotten that far with it yet.
--
Bill Moran
http://www.potentialtech.com
---(end
index, there may be some advantage gained
by having indexes defined slightly differently. I.e., your PK is
(ABCD) but you have an additional index on (DCBA)
Whether or not this is actually helpful depends on the nature of the
queries you run.
--
Bill Moran
http://www.potentialtech.com
the place.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
start with shared_buffers around 2 - 3G, if
you're using a modern version of PG. With that much shared memory, a
large portion of that index should stay in RAM, as long as it's being
used often enough that PG doesn't swap it for other data.
--
Bill Moran
http://www.potentialtech.com
is doing in the wild under pressure. If anyone cares to
throw some out I would really appreciate it.
http://people.freebsd.org/~kris/scaling/
Lots of interesting graphs on that page ... most of them seem to indicate
that RDBMS scale rather nicely.
--
Bill Moran
http://www.potentialtech.com
new records. Thus, you assign each handheld a unique
device ID, and that's part of the primary key for each table, so there's
no chance of of conflict.
Sounds like a fun and challenging project. I'm jealous.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast
approach I know for you is Veil:
http://veil.projects.postgresql.org/curdocs/index.html
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
read this, almost deleted it, read it again ...
Just in case there's confusion, MONO + FYIReporting _is_ native on Linux.
At least, as much so as Java on Linux is.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 4: Have you
you pick/choose which tables you want to
duplicate. This can optimize things, as it's not normally worthwhile
to replicate things like session tables, and they usually eat up a
lot of bandwidth.
http://www.slony.info
--
Bill Moran
http://www.potentialtech.com
---(end
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 3:25 PM
To: Bill Bartlett
Cc: 'Andreas Kretschmer'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we
going to change the applications
that I need to use for my day-to-day work. Feel free to continue
posting your feelings in email signatures though -- never can tell if it
will indeed influence a change ...)
Much appreciated!
- Bill
---(end of broadcast
them off
am Fri, dem 05.10.2007, um 10:05:32 -0400 mailte Bill
Bartlett folgendes:
Quick request to the group: we have several members who
include bogus
or humorous X-Message-Flag headers in their email
messages. Could I
request that you _please_ turn them off? Because they come
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 10:45 AM
To: Bill Bartlett
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn them off
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, October 05, 2007 12:30 PM
To: Bill Bartlett
Cc: A. Kretschmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone using bogus /
humorous X-Message-Flag headers, could we please turn
turn them off
Bill Bartlett [EMAIL PROTECTED] schrieb:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
A. Kretschmer
Sent: Friday, October 05, 2007 10:57 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Request: Anyone
data it's holding, roughly. If you're set to 16 Meg
max, I'm assuming your return set is 8Meg or larger.
I'm not sure, but that's probably correct.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 2: Don't 'kill -9
disk.
Mike
Bill Moran wrote:
In response to Mike Charnoky [EMAIL PROTECTED]:
This is strange... count(*) operations over a period of one day's worth
of data now take ~1-2 minutes to run or ~40 minutes. It seems that the
first time the data is queried it takes about 40 minutes
)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
?
Updated rows also produce dead tuples that require vacuuming. If the
table is insert only, you don't need vacuum.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
: pgsql-general.postgresql.org
List-Owner: mailto:[EMAIL PROTECTED]
List-Post: mailto:pgsql-general@postgresql.org
List-Subscribe: mailto:[EMAIL PROTECTED]
List-Unsubscribe: mailto:[EMAIL PROTECTED]
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast
of the table, all of those indexes.
* Keep them there, but keep a disk based backup for integrity.
* Run all selects against the in RAM copy. Always.
This is what PG does if you allocate enough shared_buffers.
--
Bill Moran
http://www.potentialtech.com
---(end
Solaris
* BSD - OpenBSD, FreeBSD, NetBSD
* Microsoft Windows
One of these days I'm hoping to have some time to get back to using it
(instead of just using Java for cross-platform work).
- Bill
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday
? What's your shared_buffer settings?
What's your maintenance_work_mem set to?
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
That doesn't mean you're vacuuming often enough, however. Switch your
nightly vacuum to vacuum verbose and capture the output to see how much
work it has to do. Are your fsm settings
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
On Thu, 2007-09-20 at 13:22 -0400, Bill Moran wrote:
In response to Robert Fitzpatrick [EMAIL PROTECTED]:
I have a large database used with our mail filter. The pg_dumpall
results in about 3GB with this being the only database
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Martin Gainty
Sent: Tuesday, September 19, 2000 5:58 PM
To: johnf; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Building Windows fat clients
Hello Guys
Using C# means .NET framework
others that have
implemented something similar.
Thanks,
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
performance, then you should
investigate further. Depending on the exact nature of the problem,
there are many possible solutions, three that come to mind:
* Add RAM/SHM
* REINDEX on a regular schedule
* (with newer version) reduce the fill factor and REINDEX
--
Bill Moran
http
).
I'm not sure how to find the current value, but a smaller fill factor
on busy tables should lead to less fragmentation, thus more efficient
indexes over time. Keep in mind that a smaller fill factor will also
lead to larger indexes initially.
--
Bill Moran
http://www.potentialtech.com
for you.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
!
--
Bill Moseley
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
may see the same course_number
in Course table, but (school_id, course_number) should be always
unique. How can I make the constrain?
ALTER TABLE Course PRIMARY KEY(school_id, course_number);
and add the school_id column to the Course table.
--
Bill Moran
http://www.potentialtech.com
antiquated, which may be why MS doesn't
use it. It's difficult to use if you've got a DHCP driven network where
IPs change a lot.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
Markus Schiltknecht [EMAIL PROTECTED] wrote:
Hi,
Bill Moran wrote:
While true, I feel those applications are the exception, not the rule.
Most DBs these days are the blogs and the image galleries, etc. And
those don't need or want the overhead associated with synchronous
replication
'cellspacing=0 cellpadding=6'
SELECT p.last_name, p.first_name, [blah blah blah]...
- Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Phoenix Kiula
Sent: Saturday, September 01, 2007 5:24 AM
To: Ashish Karalkar
Cc: pgsql-general
to
sharding. Just the ones that exceeded the scalability of replication,
but they don't explicitly say, IIRC.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
In response to Markus Schiltknecht [EMAIL PROTECTED]:
Hi,
Bill Moran wrote:
First off, clustering is a word that is too vague to be useful, so
I'll stop using it. There's multi-master replication, where every
database is read-write, then there's master-slave replication, where
only
will cause pain. Have
you determined that the extra performance gain that immutable will give
you is even necessary? If not, then start out with a more conservative
approach and approach the immutability problem _if_ you see performance
issues.
--
Bill Moran
http://www.potentialtech.com
in any way when reading/writing
data? If we turn off/disable atime on the DB volumes will that cause
any type of issue at all with PostgreSQL 8.1 on Red Hat Enterprise
Linux?
I frequently run with noatime and have never noticed any problems.
--
Bill Moran
http://www.potentialtech.com
most of the table in to memory
anyway.
If it's wrong, it's either because your analyze data isn't up to date,
or your tuning parameters don't match your hardware.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 1
In response to Markus Schiltknecht [EMAIL PROTECTED]:
Hi,
Bill Moran wrote:
I'm curious as to how Postgres-R would handle a situation where the
constant throughput exceeded the processing speed of one of the nodes.
Well, what do you expect to happen? This case is easily detectable
the hardware requirements
and one or more nodes is unable to keep up.
Just musing, really.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
.
BTW: does anyone know of a link that describes these high-level concepts?
If not, I think I'll write this up formally and post it.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please
In response to Hannes Dorbath [EMAIL PROTECTED]:
On 24.08.2007 02:43, Bill Moran wrote:
Hannes Dorbath [EMAIL PROTECTED] wrote:
Bill Moran wrote:
I guess I just feel that broken is a bit of a harsh term. If
your expectations are for full-blown connection management from
pconnect
problem I'd
appreciate it. However, I managed to get the results I needed, so we
could also call this fixed via workaround.
Thanks for the help, Tom and others!
- Bill Thoen
Tom Lane wrote:
Bill Thoen [EMAIL PROTECTED] writes:
(gdb) bt
#0 0x003054264571 in fputc () from /lib64/libc.so.6
that they usually are.
To get your columns in a specific order, specify the column names in
that order in your SELECT statement. The SQL standard doesn't provide
for any other way to guarantee column order, and neither does Postgres.
--
Bill Moran
http://www.potentialtech.com
parsing and startup -- unless I misunderstood the question.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
In response to Josh Trutwin [EMAIL PROTECTED]:
On Thu, 23 Aug 2007 13:29:46 -0400
Bill Moran [EMAIL PROTECTED] wrote:
Well you haven't given us any indication of data set or what you
are trying to do. However, I can tell you, don't use pconnect,
its broke ;)
Broke? How do you
of requirement the entire reason for 2-phase commit?
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Decibel! [EMAIL PROTECTED] wrote:
On Aug 19, 2007, at 7:23 AM, Bill Moran wrote:
Assumptions:
a. After pg_stop_backup(), Pg immediately recycles log files and
hence wal
logs can be copied to backup. This is a clean start.
I don't believe so. ARAIK, all pg_stop_backup() does
On Tue, Aug 21, 2007 at 04:38:42PM -0500, Scott Marlowe wrote:
On 8/21/07, Bill Thoen [EMAIL PROTECTED] wrote:
How would you suggest I try to track down this problem?
I run the following query:
SELECT a.* FROM compliance_2006 a, ers_regions b
WHERE a.fips_st_cd=b.fips_st
On Wed, Aug 22, 2007 at 09:46:21AM +1200, Andrej Ricnik-Bay wrote:
On 8/22/07, Bill Thoen [EMAIL PROTECTED] wrote:
How would you suggest I try to track down this problem?
Any suggestions?
postgres version?
Operating system?
Anything in the log(s)?
PostgreSQL Version is 8.1.5, running
0x00409153 in MainLoop ()
#6 0x0040b16e in main ()
Please tell me what it means if you can and if I can fix this problem.
Thanks,
- Bill Thoen
Alvaro Herrera wrote:
Martijn van Oosterhout escribió:
That said, it would be nice if it returned an error instead of
crashing.
In my
for the connection. However, my knowledge of this
approach is still very sketchy.
Documentation is spread around, but the two sites you should peruse are
the MapServer docs at: http://mapserver.gis.umn.edu/docs and the PostGIS docs
at: http://postgis.refractions.net/docs/.
- Bill Thoen
How would you suggest I try to track down this problem?
I run the following query:
SELECT a.* FROM compliance_2006 a, ers_regions b
WHERE a.fips_st_cd=b.fips_st
AND a.fips_cnty_cd=b.fips_cou AND b.region =1
AND a.fips_st_cd='17' AND a.fips_cnty_cd='003';
and it works. But when I try
down the exact problem and fixing it?
Any help would be appreciated
- Bill Thoen
Tom Lane wrote:
Bill Thoen [EMAIL PROTECTED] writes:
Tom, here's the explain results: Does this help explain what went wrong?
(And yes, I think there will be a *lot* of groups.)
explain select
many questions
you ask of knowledgeable people. You're going to want to have first-
hand experience going through the process.
HTH.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 4: Have you searched our list archives
something? Does anyone know what might be wrong?
- Bill Thoen
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Bill Thoen [EMAIL PROTECTED] wrote:
I'm new to PostgreSQL and I ran into problem I don't want to repeat. I have
a database with a little more than 18 million records that takes up about
3GB. I need to check to see if there are duplicate records, so I tried a
command like this:
SELECT count
, crop_status_cd, practice_cd, seq_nbr
- Seq Scan on compliance_2006 (cost=0.00..1039927.18
rows=18048318 width=160)
(6 rows)
On Sun, Aug 19, 2007 at 01:19:51PM -0400, Tom Lane wrote:
Bill Thoen [EMAIL PROTECTED] writes:
I knew this would take some time, but what I didn't expect
that pagination for multi-million tuple results does not make
sense.
Then what is the point to this thread? Are we just shooting the breeze at
this point?
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 5: don't forget
that should work just fine, so verify all your
configuration first. You may be able to get more acceptable estimates
by increasing your statistics targets, for example.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 4
PostgreSQL's data (and possibly
the WAL logs as well) is architecture dependent. This can be a royal pain if
you don't know about it and you have a mix of architectures.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 6
the transaction errors, then all queries
within the transaction are rolled back.
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
.
However, this is just speculation. You didn't provide analyze output, table
schema, hardware details, or configuration information ... so it's entirely
possible that there is something else wrong. I'm just making an educated
guess.
--
Bill Moran
http://www.potentialtech.com
bet is to set up triggers on
your tables to maintain counts in a separate table. This can be rather
complex to set up, and you take a performance hit during inserts and updates,
but I don't know of any other way to do it.
--
Bill Moran
http://www.potentialtech.com
);
}
thanks, brendon
--
Bill Moran
http://www.potentialtech.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
many of the postings like this that keep
reappearing on these lists.
- Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Magnus Hagander
Sent: Saturday, August 04, 2007 3:09 PM
To: nac1967
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
-interactive mode whereas the
Cygwin version of psql is fully-functional.
- Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of nac1967
Sent: Saturday, August 04, 2007 3:01 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] v8.2 ... command line
on a FreeBSD machine, you
can use mksnap_ffs to back it up, and that approach is actually
recommended for PITR-type backups.
* If the data is mounted via NFS or something similar and the filesystem
is not FFS2, then snapshots are not available on FreeBSD.
--
Bill Moran
http
/snapshot /var/db
mdconfig -a -t vnode -f /var/db/snapshot -u 4
mount -r /dev/md4 /mnt
[ ... do whatever you do to back up /mnt (which is the snapshot of
/var/db ...]
umount /mnt
mdconfig -d -u 4
rm /var/db/snapshot
2007/8/2, Bill Moran [EMAIL PROTECTED]:
Maybe. I'm confused by your question
701 - 800 of 1176 matches
Mail list logo