Reindexdb in contrib should help with rebuilding indexes.
Bruno G. Albuquerque wrote:
I am having a weird problem here. I have the automated process to
install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing
the database server itself, my process does the following:
1 - Runs
use initdb to create the cluster (including the template db's), if you
haven't already done so.
Paul Keyes wrote:
Hi All,
I'm confused about one aspect of backing up and moving
a database to a different server.
I've used pg_dump to dump the database and moved he
resulting file to the new serve
From http://docs.sun.com/source/817-1836-10/perfplat.html
High File System Page-in Rate
If you are seeing high file system page-in rates on Solaris 8 or 9, you
may benefit from increasing the value of segmap_percent. This parameter
is set by adding the following line to the /etc/system file:
Did you change this in your postgresql.conf:
listen_addresses = '*'
it defaults only to localhost
German Raul Hoyos Parravicino wrote:
Hello Everydoy.. I need help
I have installed PostgreSQL in my LinuX -SUSE "postgresql-8.1.3.tar.gz"
I start Postgre using "pg_ctl start -D/usr/local/dat
What might be more bullet proof would be to make the archive command
copy the file to an intermediate local directory, then have a
daemon/cron job that wakes up once a minute or so, check for new files,
then copy them to the network mount. You may want to use something like
lofs to make sure t
Did you have your archive_command configured before you started this
test (before starting the db?)...
also did the tx_logs actually get saved? It looks to me that you don't
have any valid archives. Also somewhat suspicious that it's starting
with serial 1 for the transaction log -- which wo
Hello, Jaider
The build instructions for solaris seem to be lost from the techdocs site, but
I just found
out today that there's a binary pkg on sunfreeware.com for sparc 5.9. If it
works it will be a
real time saver
Jaider Sousa Fraga wrote:
My name is Jaider. I live in Brazil, and I need one i
Hi, Daniel
I run a similar environment and I've seen this problem a lot.
It's a java code problem -- your developers need to run a profiler to see where
the resource leaks are -- they need to make sure that
everytime they open a connection, they also close it as well -- and don't
forget to to clo
Not sure if it will work in windows, but in unix, I use the envrionmental
variable PGPASSWORD
Not the safest thing in the world, but in my case, if a hacker's gotten through
two layers of firewall, I'm sunk anyhow. :)
Andrei Bintintan wrote:
Hi,
I have to run some command line commands that I h
George Wilk wrote:
Hi,
I am attempting to use the WAL archiving on a Solaris machine, running
PostgreSQL 8.1.4. The archive_command specified in the
postgresql.conf file does not get executed, nor do I see any log
entries showing errors etc. What am I doing wrong here?
Here is the
I think you may have a race condition in your code -- you don't find the
new file, sleep, while sleeping both the new file and the stop file come
in, you wake up, find the stop file and never copy the last segment over.
George Wilk wrote:
I posted to this group before with the same topic but
You need to make the script wait forever for the next archive file, or
return 1 only if you want to complete the recovery. Here's a stub of
what we do:
#!/usr/bin/ksh
set -e
# Where copy.sh fetches WALs from
ARCHDIR=/data3/archive_log
# Name of log file that copy.sh writes to
copy_log=copy.
Hi, Brian
We have been doing PITR backups since the feature first became available
in postgresql. We first used tar, then, due to the dreadful warning
being emitted by tar (which made us doubt that it was actually archiving
that particular file) we decided to try CPIO, which actually emits mu
off the
backup. If you kick off archiving first, you are assured of a valid
backup (when the recovery is done.) You may get some extra log files
that way, but better too many than too few. (been there, done that.)
Tom Davies wrote:
On 17/01/2008, at 4:42 AM, Tom Arthurs wrote:
The import
14 matches
Mail list logo
