a loop that will generate WAL
activity, run that until the segment gets archived. Haven't really
thought of something good to use for that purpose yet.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
e the first part of the series
(from the base backup), the last ones (from the current pg_xlog), but will
be missing some number in the middle (the recycled files).
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: explain analyze is your friend
hat goes into the WAL when you do that. You'd need to
implement a process that made sure to sync changes in the underlying
filesystem before modifying a tablespace.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
the xlog directory and instead
only work with what the archive_command is told.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
cho
me to be sent a ticket.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(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
nderstand that if your underlying hardware has issues, that may cause
more corruption (with possible data loss) rather than less.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
wing the recommended procedure rather than trying to do
something a little different. There are too many edge cases here that
could^H^H^H^H^Hwill bite you one day.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)-
ve this month's average", you'll be in a
positition to catch performance issues before they completely blindside
you; makes you look good in meetings, too.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
ey're doing simply
by using more expensive hardware. In your case, I think it's safe to say
you've got quite a bit of margin for improvement that way when you run
into a problem.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
delete any archived logs file on the secondary from
before that time. Instead of doing "ls | sort -g -r" you should be doing
something like looping over the files in a bash shell script and using
[ -ot ] to determine which files to delete.
--
* Greg Smith [EMAIL PROTECTED] htt
s.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html I refer
to sometimes. It's from March of 2005 so several pieces are out of date.
Kevin Kline's "SQL in a Nutshell" also has some helpful suggestions on
syntax differences between the major SQL dialects, but it's e
or: There is a time difference
between the Client and Server." when trying to login.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your d
be given
their own port number.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
h cluster you
get to.
You'd need to give some more OS and general network setup information to
get any more specific or clever than that.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
wary of when trying this is the SQLite deals with
dates and times very differently than PostgreSQL does. Even when
insulated with an ORM tool that can bite you.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast
ion of the PITR mechanism or its
cleanup.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joinin
o simulate types and operations that now are
built-in to PostgreSQL, like the interval type, so it's not quite as
intimidating a read as it seems at first; there's a lot of code for older
databases that you can completely ignore.
--
* Greg Smith [EMAIL PROTECTED] http://w
iable writes that use the drive's cache
for instant fsyncs, instead of right now where you have to push all that
to the controller level.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: I
westnet.com/~gsmith/content/postgresql/pg-disktesting.htm has
an outline of how to do those tests.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
hat label in it.
That's how you prevent this class of problem. If you don't find the label
you expect in the history, abort the whole thing because your backup
didn't happen correctly.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
mmend http://www.gtsm.com/oscon2003/toc.html on this topic.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
e for this parameter for
your class of system.
effective_cache_size = 650MB
This is in the right ballpark, but you might see improvements increasing
to the 1GB range. See
http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm for more
on this and related topics.
--
* Gre
h multiple anecdotal
samples on this subject:
http://reviews.pricegrabber.com/hard-drives/m/11165851/
The problems with their products are so widespread I'm sure it would be
easy for you to find many more if you search around a bit.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.co
f things you'll need to learn.
Gentoo can be a good server environment, but the learning curve to get
started is probably harder than you want to take on if you're new to
Linux.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---
n a 64 bit installation is not
a problem limited to Ubuntu; it's an equally messy problem on all Linux
distributions, and the workarounds for each are similar. On the topic of
Firefox plug-ins:
Fedora/RHEL:
http://www.cyberciti.biz/tips/linux-flash-java-realplayer-under-64bit-firefox.html
Plucker ( http://plkr.org/ ) is a tool for viewing documentation on
handhelds running the PalmOS, and I just noticed that they have the
PostgreSQL documentation available:
http://projects.plkr.org/postgresql-documentation/
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore
k for dead horse riding[1], obviously technique #12
"Harnessing several dead horses together for increased speed" would allow
faster progress were all these addressed at once.
[1] http://soli.inav.net/~catalyst/Humor/dhorse.htm
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmi
stamps on all that data.
To get more specific advice, report if you see anything interesting in
your log files and send some details about the PostgreSQL version you're
using and the settings in the postgresql.conf file that you've changed
from their defaults.
--
* Greg Smith [EMAIL PR
code coming in 8.3 that addresses this issue head-on, it can be tricky to
accomplish in the current production releases.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0
GROUP BY c.relname,isdirty
ORDER BY 2 DESC;
I have something I'm working on that covers a lot of this topic at
http://developer.postgresql.org/index.php/Buffer_Cache%2C_Checkpoints%2C_and_the_BGW
but that's probably a little too low-level for you to chew on usefully
right no
some disclaimers
about what you should ignore in the guides that haven't been updated
recently.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 3: Have you checked our extensiv
setting either percentage
over 5% or either maxpages>100 as a first step on a production system.
You may be in for a bad day tomorrow.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: expla
On Mon, 13 Aug 2007, Scott Marlowe wrote:
We can look at how big your shared_buffers are, your work_mem, and a
few others in postgresql.conf.
That's going to be sort_mem, not work_mem, with 7.4
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimor
ng of trivia
in that category lately, haven't gotten to issues with their product much
so far.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore y
caching behavior not being
turned on by default in that operating system.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
relatively small amount of memory. The main benefit for having a
caching controller is fsync acceleration, the reads should pass right
through the controller's cache and then stay in system RAM afterwards if
they're needed again.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com
stem, your card, or the OS/driver you're using
if open_sync doesn't work under Linux; in fact, it should be faster in
practice even if it looks a little slower on test_fsync.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end o
happens to the pending writes for the drives that aren't there
anymore is kind of undefined though; presumably they'll just be thrown
away, I don't know if there are any cards that try to hang on to them in
case the original disks are connected later.
--
* Gr
data from the
beginning. That's another reason why the Wiki is a bad way to cope with
this data; adding another column is a painful and error-prone operation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of
been reasonable to maintain
because more rows get added, but rarely columns. This feature comparision
table will be the other way around, which is the harder one to cope with.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
to suggest that the Postgres vs. PostgreSQL renaming
argument be dropped in favor of renaming the database "Horizontica".
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: explain analyze is your friend
gives you considerably more flexibility than trying
to squeeze everything into the archive_command.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ut giving
some specifics about the two disk controllers you're comparing, how much
cache they have, and whether they include a battery backup.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
--even though it's possible the real-world performance
of the CPU/memory might be a little better on the Opteron box. The fact
that it will have 2X as many disks will just increase its lead. And now
you know why everyone wanted such specific information!
--
* Greg Smith [EMAIL PROTECTE
faster I'd expect it to be.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(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
r a bit more heavily
than I'd normally recommend, but with his particular system that worked
out well.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the
ng something close to a checkpoint I/O spike every cycle,
and that the background writer waiting for that big write to finish might
delay checkpoint requests from processing in a timely fashion.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(
some basis for figuring out what % of the index is being held
there.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscr
uessing you got your copy during that period.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
27;t incremented by any of the earlier
insertions, so it's still at a low value. Here's what I got after going
through the whole install process:
postnuke=# select nextval('pn_categories_category_cat_id_seq');
nextval
-----
6
So there are values from 1 to 37 (a
environment.
Accordingly, focusing on the raw performance of PostgreSQL is kind of
misleading. You shouldn't have to hit the database for everything if you
put the right kind of layer on top.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
--
pplication where data normalization is the
only way to solve the fundamental problem causing the slowdown, it's
impossible to truly appreciate why you should consider design tradeoffs in
that area from day one. Can you build a database without someone who has
been th
instead spend that time thinking about what's gone wrong, or monitoring
the client and/or server for clues.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the plan
lot of sense. You mentioned
training and certification. Part of the value of going through either of
those is that you end up with some baseline idea of what someone who has
gone through the class/test has been exposed to.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
UNIX-ish, you're probably linking
against unixODBC, which is available under the LGPL presumably to avoid
this issue.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searche
em was
positively sluggish until I fixed that.
Does Linux suck compared to BSD?
Not the Mac OS BSD. Last time I looked into this OS X was still
dramatically slower than Linux on things like process creation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
-
ge. If you wanted to do this for your application, you'll have
to go through a dump, initdb with the change, then reload on your
database.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
never have too many ways to try and recover from such
a situation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
re of a problem that could corrupt data. Even if it were
feasible for you to self-certify in some fashion, the only path there that
would make sense would be extracting the changes made to reach EAL1 in
that customized 8.1.5, then apply at least those important patches.
--
* Greg Smith [E
On Fri, 16 Nov 2007, Tom Lane wrote:
Greg Smith <[EMAIL PROTECTED]> writes:
Right, by NTT: http://www.nttdata.co.jp/services/postgreSQL/english.html
Were those mods ever submitted upstream?
As far as I can tell they weren't even released offically. I didn't see
any sourc
the end of ISO/IEC 15408-3:2005. That serves
as a sort of index of what you need to pay attention to in the other
documentation.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 3: Have you c
urity.gov/pubs/10064.html
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so th
ges from Sebastien's site, then see if you can build 1.8.0 from
source. While the pgadmin packagers might get to relasing RHEL4 RPMs at
some point, with this set of prerequisites it's a difficult version to
support and I think less of a priority as a result.
--
* Greg Smith [EMAIL
ecomes a serious concern, you'd be much better off
with Linux, one of the BSDs that's not hobbled by using the Mach kernel,
or one of the more serious UNIXes like Solaris.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadc
love to see it--this is actually one of the items on the
relatively short list of why I'm typing this on a Thinkpad running Linux
instead of a Macbook (the other big one is Apple's string of Eclipse
issues, which I already ranted about recently at
http://slashdot.org/comments.pl?s
d yet.
Last I heard it was actually glibc combined with a kernel problem, and
changes to both would be required to resolve:
http://kerneltrap.org/mailarchive/linux-kernel/2007/4/3/73000
I'm not aware of any resolution there but I haven't been following this
one closely.
--
* Gr
net.com/~gsmith/content/postgresql/chkp-bgw-83.htm
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ve already gotten made the right
assumptions. There's some additional fun statistics you can collect with
the Linux iostat, but sadly that needs a newer kernel as well.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)-
yours has from this
technique (like the multi-threaded C++ apps it appears aimed at). I just
wouldn't expect it to be a big win for the PostgreSQL server itself.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)
the server
abruptly, and then fsync=off could hurt :).
Here you're hitting on the real point. If a proposed solution adds
potential for database corruption if someone trips over the server cord,
it's not really a solution at all.
--
* Greg Smith [EMAIL PROTECTED
results that
aren't so useful.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
e just three obvious ones, you can explore yourself to see if they
or others seems like a good fit to what you want. Think of it this way:
instead of one phone number to call for support, now you've got
dozens--and that's not even considering the free help you can often find
on
rs/2007-10/msg01310.php
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
gs, and you can
make the changes permanent by fiddling with the /boot/device.hints file.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
to the administrator
and tasks anyway--an experienced Linux system administrator may be a
little slower on some things than one running Apple's GUI tools, but once
you get to more scriptable changes they could be far more efficient.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.
llow you to adjust whether the individual disks utilize their
cache or not. For database use, if you're using the controller cache to
preserve writes, you should make sure the individual disk caches are
turned off.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
-
individual queries won't run quite as fast as some of the
dual-core alternatives, but when you get twice as many of them it's hard
to complain. The X3220 is a little faster and more expensive.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
-
use it instead of the example restore.sh included in the
message I referenced above.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
is setup to be accessed over
the network like this.
5) If that goes OK, import into the new version with 'psql -f dump.sql'
That should get you started in the right direction.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of
on, which may help you figure out your
issue. It may be that you need to adjust the logging settings in the
postgresql.conf file as well.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 1:
DDL (table creation etc.). Forwarding SQL handles those
but I'm not sure how your suggested scheme would. You should certainly
look at what went into the design of both the existing WAL replication and
tools like Slony to get an idea the full scale of challenges here.
--
* Greg Smith [
file over.
It's kind of hard to reuse any portion of their solution without adopting
the whole thing, but it's a decent approach if you're comfortable with
Python code.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(e
than just a trigger and getting the data moved over the LAN before you're
done.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: explain analyze is your friend
limitation of what you were suggesting. I
personally work mostly on replication in terms of disaster recovery, so in
my world DDL is always a replication requirement rather than never.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of
None of those will work if you use another
tool to connect.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
7;ve spend working on
your own not wasted but educational--you can never know too much about
disaster recovery of your database.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
spond to anything you ask about.
Dictating policy is something the people *answering* questions get to do,
and if your introduction to the list involves insulting them like you've
done above I hope you never run into something you need advice about here.
--
* Greg Smith [EMAIL PROTECTED] http
). Swapping might do both, so consider mine a second
vote to correlate this with vmstat output.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 6: explain analyze is your friend
user was responsible for starting the service?
That's both something that could cause your error and something that would
survive the re-intall regime you've tried so far.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of
-term tool, but for hacking something together
it's not an awful way to do it.
Like all questions with security implications, I highly recommend you
believe nothing I said above and confirm each suggestion through your own
research and testing.
--
* Greg Smith [EMAIL PROTECTED] http
On Wed, 19 Dec 2007, Tom Lane wrote:
Not sure if pgpool has its own list.
There's a moderately active general user list as part of the set at
http://pgfoundry.org/mail/?group_id=155
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimor
On Fri, 21 Dec 2007, Andreas Kretschmer wrote:
(answer from the nice doc-bot on our irc-channel)
Which for those of us who hate IRC is also available at
http://search.postgresql.org ; the docbot hits show up at the top before
the main search results.
--
* Greg Smith [EMAIL PROTECTED] http
ce issues when you have a
checkpoint.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Sat, 22 Dec 2007, Martin wrote:
The problem is getting all the sequences set without doing each one by
hand.
See if this helps you:
http://archives.postgresql.org/pgsql-general/2007-10/msg00969.php
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
date a row, that
becomes a dead row that's still taking up space, and if you do a lot of
those they get in the way of finding the rows that are still live. Take a
look at
http://www.postgresql.org/docs/current/interactive/routine-vacuuming.html
to get an idea of the process.
--
* Gr
date a row, that
becomes a dead row that's still taking up space, and if you do a lot of
those they get in the way of finding the rows that are still live. Take a
look at
http://www.postgresql.org/docs/current/interactive/routine-vacuuming.html
to get an idea of the process.
--
* Gr
ady has a workaround everyone can get in the near
future.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
actually doing under the hood. The initdb one may not be useful for
you--the --auth settings may not be what you want for example, and there's
the language question as well. But seeing exactly what the stock initdb
does should be instructive.
--
* Greg Smith [EMAIL PROTECTED] http://ww
tion system with fsync=off
as that's kind of scary.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
*60+1)*1GB=121GB worth of disk
space used just by the WAL segments--that's on top of whatever is used by
the database.
--
* Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD
---(end of broadcast)---
TIP 5: don't for
1 - 100 of 760 matches
Mail list logo
