r_namespace does this? I didn't find much info on that.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
you are essentially simulating a power
failure to PG. Luckly the WAL works like a champ. Also, these backups can
be much larger since it has to include the indexes as well. but this is a
price you have to pay.
I did have some initial problems with snapshots & corruption but it turned
out to be us
key is that -L that tells it how big to make htings. If your -L is
smaller than the actual size of the volume you'll get corruption (as I
found out).
The restore is to simply take pg down, rm $PGDATA and untar mb.backup
into $PGDATA, start up PG and thats it.
Godo luck - be sure to test it ou
On Thu, 16 Oct 2003 09:49:59 -0700
Josh Berkus <[EMAIL PROTECTED]> wrote:
> Jeff,
>
> > The downside is
> > this method will only work on that specific version of PG and it
> > isn't the"cleanest" thing in the world since you are essentially
> &g
On Thu, 16 Oct 2003 10:09:27 -0700
Josh Berkus <[EMAIL PROTECTED]> wrote:
> Jeff,
>
> > I left the DB up while doing this.
> >
> > Even had a program sitting around committing data to try and corrupt
> > things. (Which is how I discovered I was doing th
you. Also,
if you could provide explain analyze of each query it would be even more
helpful!
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 8: explain analyze is your friend
up the only "safe" way to do this is to
either stop postgres and then backup, or if you are using a logical
volume manager take a snapshot.You cannot just "tar" a "live" pgdata
directory as the contents will change as tar goes through each file and
you'll be l
ostgresql.org/project/psqlodbc/projdisplay.php
It compiles on solaris for me anyway.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
> On Wed, 22 Oct 2003, David Wagoner wrote:
>
> > Jeff,
> >
> > Thanks, I saw that page but thought is was only for Windows since it
> > said Win32. But, I'll try it on Solaris and see what happens.
> >
You'll need to download source
ed so my UnUsed
was rather steady.
The thing that bothers me most is why all that stuff in the clog?
There are entries in there that are older than the last time I spun PG.
Machine is a 2xp3-800mhz, 2gb, linux 2.2.17 [old], pg 7.3.4
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
On Wed, 29 Oct 2003 11:32:12 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Jeff <[EMAIL PROTECTED]> writes:
> > [ pg_clog not getting truncated ]
>
> pg_clog is truncated on the basis of the oldest completely vacuumed
> database in your installation. Most likel
intenance on it either.
Why not go through the list in pg_database to make sure you didn't
forget about any (like I did).
given that template0 and 1 rarely change.. I don't see why we'd need to
vacuum them
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http:/
have 1.400.000 rows!
> What is wrong? Anybody help please.
>
1. did you remember to load data?
2. did someone accidentally delete the data?
3. are you connected to the correct db (I've panic'd before but realized
I was on dev, not production!)?
4. sure that is the right table?
--
nd I try the same thing:
psql mydatabase -h BACKEND -U ownerofmydatabase
I get:
psql: FATAL 1: No pg_hba.conf entry for host 192.168.24.4, user
ownerofmydatabase, database mydatabase
My pg_hba.conf file has two lines
local all trust
host all 192.168.24.0 255.255.255.0 passw
Thanks Mallah
First I'll check to make sure it won't break my application and then
I'll have to learn how to back up my database and then perhaps I'll
start looking for the way to do an upgrade. Which means I'll be hanging
around for a while ;-)
Jeff
[EMAIL PRO
Thanks Valentin
Ping BACKEND worked and -U 192.168.24.8 returned the same result but Tom
gave me a suggestion that solved it, I was editing the wrong pg_hba.conf
file. :-(
Jeff
Valentin Militaru wrote:
Try using the IP instead of backend.
Also, try a ping BACKEND from the second machine, see
Thanks Tom!
I was editing /usr/local/pgsql/data/pg_hba.conf when I should have been
editing /var/lib/pgsql/data/pg_hba.conf
Now everything works.
Jeff
Tom Lane wrote:
Jeff <[EMAIL PROTECTED]> writes:
I get:
psql: FATAL 1: No pg_hba.conf entry for host 192.168.24.4, user
ownerofmyda
g (also shown in vmstat)
Where any of these tables analyze'd?
I see you used no indexes, so on each of your tables it must do a seq
scan. Try adding an index to your test tables and rerun..
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuart
t only goes slow with hundred(s) of clients connecting and
disconnecting?
I'm guessing the CPU is pretty pegged on the box.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)-
ts.
One of the best things you can do to increase insert speed is a nice,
battery backed raid card with a pile of disks hanging off of it.
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)
; broadcast)--- TIP 5: Have you checked our
> extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broad
7.3.x by setting CFLAGS=-O2 before
running configure.
However, establishing connections will not get much of an increase due
to solaris' amazingly slow fork().
The thread issue has been beaten to death on -HACKERS.
You can also check the -performance lists for the threads I posted about
this...
> read(0, "", 4096) = 0
> read(0, "", 4096) = 0
> read(0, "", 4096) = 0
>
fd 0 is usually stdin, unless the program disconnects stdin.
Maybe pg_restore is waiting for input,
ked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
--
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 8: explain analyze is your friend
you could too, to varying degrees of success).
If mysql works, then use it, but I'd be suprised if it didn't suffer a
lot of these same problems as well.
If you seriously need this feature, then you'll either have to A. buy
oracle/whatever or B. pay to fund development o
_freeze/unfreeze.
It may also be nice every once in a while to do a normal pg_dump..
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
tion. (This is true of any
tcp-based protocol).
If that connection had a transaction open it'll likely have rows locked.
Killing PG caused it to rollback that transaction freeing those locks.
Eventually PG would have found out the socket was dead. Most likely if
it tried to write to it.
--
w big is the dump in
terms of MB?
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
the db is
useless until this happens).
--
Jeff Trout <[EMAIL PROTECTED]>
http://www.jefftrout.com/
http://www.stuarthamm.net/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hen an nfs mount "goes away" (unpingable). On our
machines linux simply blocks in the kernel so you cannot even kill -9 the
applications (or unmount the mount!) granted things will resume once nfs
comes back.. but by that time your machine may be in Big Trouble(tm)
---
Is there a way in postgresql to find the current user status within a
database like sp_who in Sybase?
stall
the entire postgreSQL just to get libpq.
1) Is there a way to install and build just the libpq stuff ?
2) Is the libpq file and required header available on the Web ?
3) Is there a better way to create the client program; should I use a
different interface ?
Jeff Foster
[EMAIL PROTECTED]
mp; msg, int append)
^^^
Warning:1 future errors were detected and ignored. Add a '+p' option
to detect and fix them before they become fatal errors in a fu
ture release. Behavior of this ill-formed program is not guaranteed to match
that of a well-formed program
gmake[2]: *** [pgconnection.o] Error 2
gmake[2]: Leaving directory
`/home/jfoste/DBase/postgresql-6.4.2/src/interfaces/libpq++'
Jeff Foster
[EMAIL PROTECTED]
for that matter...
>
> I mean, if one was to mirror it, as per the "So you want to be a mirror"
> page, how much room is needed...
>
> thanks
> Bob
>
>
=====
Jeff MacDonald // Hu
speed
>
>
> > Darren Greer wrote:
> > >
> > > Hello all. On another maybe related note to my recovery issues, I am
> > > noticing a drastic slow down with my database. A couple of days ago,
> when
> >
> > Have they been vacuumed rece
just to throw a wrench into the conversation,
isn't thre a tcp/ip nfs that does more error checking
than the standard udp nfs ?
or am i just blowing smoke ?
jeff
On Mon, 13 Mar 2000, Bruce Momjian wrote:
> > Hello folks,
> >
> > Can anyone tell me if pgsql is nfs-fri
-f $PREFIX.last
> ln -f $PREFIX.last $PREFIX.hour.`date +%H`
> ln -f $PREFIX.last $PREFIX.day.`date +%d`
> ln -f $PREFIX.last $PREFIX.month.`date +%Y%m`
>
> Run this every hour, and $PREFIX will contain backups for every hour for
> the last day, every day for
quot;,"","","dbname");
return this message
Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'www-data' is not in 'pg_shadow'
can anyone please tell me why !? thank you very much
Jeff K.
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
he name of your id
sequence during insert (use \ds to view your sequences).
This is not automatically indexed unless you make it a primary key
during creation. See the PostgreSQL docs for more info.
Jeff
--
Errors have occurred.
We won't tell you where or why.
Lazy programmers.
-- Hacking haiku
You can also try the following page:
http://people.freebsd.org/~kevlo/postgres/portNT.html
This shows you how to run PostgreSQL with Cygwin. Cygwin is a unix
environment running on NT. There isn't an NT native version of PostgreSQL.
v/r
Jeff Plaxton
""Kuti Attila"
mpling rows, but my data is not terribly random, so
it gets fooled?)
[And here's the remaining question in my puzzled mind: ANALYZE would not
change the reltuples value, but VACUUM FULL ANALYZE did. Er-wha?]
--
Jeff Boes Vox 269-226-9550 x24
Director of
least one wal archive available in
the archive or the pg_xlog dir, the restore errors out and exits. So the
base backup is really not complete without at least one wal archive
following it. Is this by design?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
ATA base backup
and then any archived wal files that come after 51?
The background on this is that I'm trying to script up a one script restore
solution and my testing has me running into the occassional surprise.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fr
files that come after 51 if none happen before the
next base backup?
Thanks for all the help guys!
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-
postmaster eventually recycle them
after the restore was complete?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP
Sounds like slony is what you're looking for:
http://slony.info/
On Sat, 25 Jun 2005, hellz waren wrote:
Could you someone tell me if there's any open source
project that enables real time replication of data
back up.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost
On Thu, 23 Jun 2005, Jeff Frost wrote:
I guess I forgot to ask one other question. If the archived wal files are
streamed in one by one, would it still be safe to leave the pg_xlog directory
intact in the base backup? What would happen with the out of date log files?
Would they just stay in
se of disk space concerns, but because rsync
occassionally reports that these files disappear out from under the running
rsync process, and so I was thinking I'd rather just exclude them if they are
not required as I want my pitrbasebackup script to return 0 if rsync is
successful.
--
one other thing...it will always look in the pg_xlog directory
for that current xlog which is required and will not look for it in the
archive dir. It would be nice if it would also look in the archive dir for
this one, no?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
| tail -1`/backup_label
if [ -f $OLDESTFILE ]; then
/usr/bin/find $PITRDESTDIR -type f -not -newer $OLDESTFILE \
-exec rm -f \{\} \;
fi
Your mileage may vary, but it appears to work for me.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
ta/pg_xlog/0001000B" (log file 0,
segment 11): No such file or directory
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)
ot attempt to retrieve that first WAL
via the restore command. All the ones after that it was happy to do it for,
but if that one did not exist, it told me to get lost. That was on 8.0.3. I
did not test any other versions.
Putting it in the pg_xlog dir made everything go smoothly though.
--
did not even try to get it out of the
archive.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Thu, 30 Jun 2005, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
I'll have to retest that particular scenario and verify that something
else was not causing the problem when I have a chance now that I have
a fully functional and scripted out base backup and recover soluti
On Wed, 6 Jul 2005, Bruce Momjian wrote:
We basically run the command you give us via system(), so it is hard for
us to know exactly why it failed.
Understandable..but it would at least be nice to know that it failed. It does
not appear to log anything at this point.
--
Jeff Frost, Owner
22:14:06 db1 postgres[26299]: [4-2] directory
Jul 5 22:14:06 db1 postgres[26299]: [5-1] LOG: invalid checkpoint record
Jul 5 22:14:06 db1 postgres[26299]: [6-1] PANIC: could not locate required
checkpoint record
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http
about.
Using PITR in this way has the added benefit of allowing you to restore the DB
to some point in the past if need be.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
On Sat, 30 Ju
here:
http://www.postgresql.org/docs/8.0/interactive/backup-online.html
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP
to the secondary server and archiving
the WAL files to a shared storage medium for replay.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of bro
D Kavan wrote:
> There are 66 project id's in the project table and 3 rows in the
> project_members table for global_id 2915, but it only returns 3. I
> would think it should return 66 rows, with 63 of them having a null
> pm.project_id.
>
> SELECT
> p.project_id, pm.project_id
> FRO
Yoway,
What are you upgrading from/to? Can you share your dump and restore command
line as well?
On Fri, 5 Aug 2005, Buorn, Yoway wrote:
I'm upgrading Gforge and the first sql file I tried to load gave me the
following error:
--
Jeff Frost, Owner <[EMAIL PROTECTED
backup.dump
pg_restore is looking for one of the other output formats (tar or custom).
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
earched the web, but found what appeared to be
non-free solutions.
Thanks,
Dave
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC ht
forget to increase your free space map settings
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 3: Have you ch
e user postgres
and the local system user postgres. Psql, by default, tries to connect with
the same database username as the local system username, so if I was running
psql in my local system account jeff, it would use 'jeff' as the database
username unless I set the PGUSER environment
, it looks like this:
C:\>echo %appdata%
C:\Documents and Settings\jeff\Application Data
C:\>cd %appdata%
C:\Documents and Settings\jeff\Application Data>
On Tue, 30 Aug 2005, Lane Van Ingen wrote:
%APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application
Data subdir
Since we're on the vacuum kick these days, what's the best way to tell if my
autovacuum settings are working well? I'm sure I can query some info out of
the pg_stats tables, no?
Also, if using autovacuum, should I still do a vacuum full on a regular
basis?
--
Je
eye on
"du $PGDATA" or pg_class.relpages entries.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 5: don
idea what it is/does. I'm new to postgresql
(obviously). Thanks for your time. -John
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
what if my database has ~200GB and more (I know this is a future :D)?
From my point of view it won't be good idea to copy entire database to backup
array. I would like to here opinions about this case - what do you propose?
Maybe some of you already do something like this?
--
Jeff Frost,
Before I reinvent the wheel, has someone already written a logwatch filter for
slony logs? I googled for logwatch slony to no avail.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-64
there are 3
files that have not been archived, sometimes there are 4, and sometimes there
are more.So, my question is, when is archive_command invoked?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 F
";\connect booktown postgresERROR: syntax error at or near "\" at character 146Please give me some advise, I am kind of struck here. I need information on how to create and connect to a databaseWhere I can find error log message in postgres.org web site which can help me trouble sh
chive" | tail -1
(My pg_xlog is on a different disk set from the PGDATA dir.)
It appears to work fine for me. Don't forget to make a base backup before you
begin the WAL archiving, or you won't be able to restore anything.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fr
000DF
0001001300E0
0001001300E1
0001001300E2
0001001300E3
0001001300E4
0001001300E5
0001001300E6
Given that list, does that mean that 0001001300DF is the in use
WAL file?
--
Jeff Frost, Owner <[EMAIL PROTECTED
there
is only one timeline, but I'd love to generalize the script so we can put it
in contrib, but first I'd like to make sure it actually works properly. :-)
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650
I'm going to attempt to do my best in describing the situation... so please
forgive any ignorance on my part since I am very new to the Postgres community.
We have 2 identical Postgres databases, one on a Windows 2003 platform, and the
other on a SUSe 9.3 Linux platform (both platforms have iden
ignal the postmaster (using pg_ctl reload or kill -HUP) to make it re-read
the file.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end o
Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of bro
red from a nightly pg_dump which we have kept doing, but that means we
lost about 20 hrs of data. :-(
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcas
nder maximum stress, from experience.)
I absolutely agree..unfortunately, it's only been 3 months since the last
test. :-(
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
tching roles between the biweekly base
backups.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 1: if posting/read
ut a hitch.
Thanks again... let me know if you can think of anything that could/would
prevent this problem in the future (outside of eliminating domain types).
Jeff Kirby
>>> Tom Lane <[EMAIL PROTECTED]> 10/02/05 8:53 PM >>>
"Jeff Kirby" <[EMAIL PROTE
-1 flag when you put ls to a pipe.
-Jeff
FILE=$( ls -t1p $PGXLOG | grep -v / | head -1 )
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
ually running after the box gets into multi user mode?
If not, I'd look at paths and permissions. Does anything show up in the logs
to indicate why it might have failed? Is the script atttempting to start it
as the incorrect user perhaps?
--
Jeff Frost, Owner <[EMAIL PROT
{PARTIAL}/${FILE}.partial
find ${PARTIAL} -name *.partial | grep -v ${FILE} | xargs -i rm -fr {}
}
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broa
On behalf of a previous employer who, due to major downsizing, is left
without an answer to this:
What's the best way to treat impending OID wrap-around in a 7.4.8
database? This DB has been online for about 18 months, and is expected
to hit the dreaded wrap-around in about a month. At an applicat
e they could be transferred (code
24) at main.c(791)
PITR base backup rsync command failed!
Would it be ok to just exclude the pg_internal.init file since it disappeared
during the base backup?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com
2005 at 11:25:25 -0700,
Jeff Frost <[EMAIL PROTECTED]> wrote:
Is it at all possible to manually replay archived WAL files after restoring
from a pg_dump dumpfile?
You probably want to look at:
http://candle.pha.pa.us/main/writings/pgsql/sgml/backup-online.html
That is from the soon to
t:
24 Partial transfer due to vanished source files
So I can just consider an exit code of 0 or 24 as both being success.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
ot:
/etc/init.d/postgresql-8.0 start
What did I do wrong, and even more important, what should I do?
TIA
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
history
Can you post the output?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
also run 8.1.0 on the same server? Then, I could copy the
data and support two databases until things looked good. Then, I'd shutdown
8.0.3.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
own a problem of this nature.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
peopel think is relevant.
Thoughts?
My 2c ...
I would appreciate an easy way to keep tabs on autovacuum's activity.
A stat table seems like a practical way to have this info readily
available.
No need to keep values across dump/reloads, right?
- Jeff
--
Jeff Bohmer
VisionLink
cuum ANALYZE stats should follow it.
But if the ideal is impractical, making both ANALYZE and VACUUM stats
follow the GUC would still be real nice.
- Jeff
--
Jeff Bohmer
VisionLink, Inc.
---(end of broadcast)---
TIP 1: if posting/reading throu
should be the
opposite, too.
Unless I misunderstand, if stats_reset_on_server_start=off, these
(currently nonexistent autovacuum) stats would only be relevant for
autovacuum's VACUUM activity and not it's ANALYZE activity.
--
Jeff Bohmer
VisionLink, Inc.
rver_start. Because autovacuum's VACUUM activity
data would be relevant across restarts, even if
stats_reset_on_server_start=true. But I see now that my idea is ugly
and just confuses things. I agree that having it work the way you
suggest is preferable.
- Jeff
--
Je
m curious as to why initdb is kicking off when you su to the postgres user
though. Is this how the solaris pkg is set up?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
On Sat, 19 Nov
opt/sfw/lib
On Sat, 19 Nov 2005, olive Mckenzie wrote:
Hello Jeff Frost,
I have installed installed libreadline.so.4. When I do a search for it I
find it in /opt/sfw/lib.
initdb kicks off even if i try the command from root.
Olive
Jeff Frost <[EMAIL PROTECTED]> wrote:
Olive,
Y
1 - 100 of 366 matches
Mail list logo
