init file I should insert it into.
Olive
Jeff Frost <[EMAIL PROTECTED]> wrote:
Olive,
You need to locate the libreadline.so.4 shared library on your system. I'm
guessing it's not in any of the standard locations and then add that path to
your LD_LIBRARY_PATH. You might
Honestly, I have no idea, but I think you would be better served by posting
this to a Solaris x86 mailing list. The charter of this list is really
postgresql administration based and not solaris x86 based.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
What is the exact command you are running (copy/paste)? As simply issuing "su
postgres" should not run initdb on login.
I typed
# su postgres
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
Well, that's quite different than what you mentioned before. You should do it
like this:
Chase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Jeff Frost, Owner <[EMAIL PROTECTED
antly failing with an authentication failure
psql -U vinodsr vinodsr < C:\MU\BP_BUSINESS_PARTNER_PARTY.dat
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(en
Use the .pgpass file.
On Thu, 1 Dec 2005, Theo Galanakis wrote:
database.bak prompts me for a password. How can I run the psql command
without being prompted for a password. The password prompt and < command
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, L
quest would be
welcome..maybe advocacy or the general list?
--
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:
distributed with v8.1
--
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
Run the following query:
show data_directory;
On Fri, 16 Dec 2005, Ken Hill wrote:
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
/postmaster -p 5432 -D /var/lib/pgsql/data
Which means the data directory is /var/lib/pgsql/data.
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Bortolucci wrote:
Hi,
What are the correct steps to move an database and from an server running
postgreslq 7.4.2 to another running 8.0.3?
--
Richard Bortolucci
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908
Greg, I'm not sure what you're looking for in the way of suggestions. Do
you just want to be able to start this postgres server up and remove some
data? Easiest way I see to accomplish that given the information you
provided is to move pg_xlog to the sda disk and symlink it to the data dir.
In
Greg,
Does pg_ctl stop -m immediate stop the postmaster for you?
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PRO
Seems like you're going to have to kill -9.
On Mon, 2 Jan 2006, Gregory S. Williamson wrote:
I tried
su - postgres -c '/apps/pgsql-7.4/bin/pg_ctl stop -D /data/postgres/gex_runtime
-m immediate'
on one of the two hozed servers and that's (I think) what got this:
---(
unefs.
Jim, excellent thought! And on Linux at least you can change it with the
filesystem still mounted:
tune2fs -m 0 /dev/sdb1
would probably do the trick.
You might want to set it back after you're done though. :-) Default appears
to be 5 on my machine.
--
Jeff Frost, Owner
at in the help files and documentaion
provided with the package. I really need this to work
and any help/tip/example is greatly appreciated.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
It looks like you have SERVICEPASSWORD misspelled.
I haven't actually tried this method as I do mostly linux/solaris postgres
administration, so hopefully someone else who deals with the windows installer
will chime in.
On Wed, 18 Jan 2006, Sean G wrote:
Hi again,
Jeff, thanks fo
ctl: too many command-line arguments (first is "Files\PostgreSQL\8.0\data")
Try "pg_ctl --help" for more information.
Please explain me what i need to do...
-Sandhya
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.co
Please do not resend questions to me directly that you have already sent to
the list.
I do not work in VC++ but I would first check that the postgres user (or
whatever user the postmaster is running as) has access to the files.
On Thu, 19 Jan 2006, sandhya wrote:
Hi Thank you Jeff,
But the
atabase i am getting the
following error.
Please help me what i need to do
Insert into sampletbl values(lo_import('c:\\sample.txt'),'sample.txt');
ERROR: function lo_import ("unknown") does not exist
HINT: No function matches the given name and argument types. Y
or the
user you are trying to access the file as does not have the rights to read it.
Again, check your permissions as I mentioned to you earlier.
On Wed, 18 Jan 2006, Jeff Frost wrote:
This is what works for me from the command line on Linux with PG 8.0.3:
INSERT into images VALUES ( lo_im
Is it reasonable to mount the PGDATA filesystem with data=writeback on ext3 as
long as the PGXLOG filesystem is mounted data=ordered and fsync=on? Or is
this only acceptable if you have battery backed controllers?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
built
via REINDEX:
select schemaname,relname,indexrelname,idx_tup_read,idx_tup_fetch from
pg_stat_user_indexes where idx_tup_read != idx_tup_fetch;
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
or a heap fetch to
any particular index is impractical and likely misleading anyway.)
So how might I find indexes which are bloated and might need reindexing? I
know this behavior less likely in 8.x, but the docs still indicate it is
possible to have index bloat in recent versions of postgres.
it got
this way. Has anyone done chmods on /tmp? It should be 1777/drwxrwxrwt, so a
chmod 1777 /tmp should fix it
for you.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
suitably short when the
secondary is needed. Also a good idea to do test recovers on occassion to
make sure you don't have any corrupt WAL files. If you use rsync, then you
can make the base backup pretty quickly depending on how much of your DB
changes.
--
Jeff Frost, Owner
for client authentication? It
sounds like you have a root.crt in your PGDATA directory, but your clients are
not setup to provide a certificate upon connection and thus the server is
denying access.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostc
.e.
we'll be going to a continuous recovery methodology). Hopefully we'll get
some interest from more folks soon and get some good ideas flowing.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FA
I installing postgre SQL on Windowx XPProduct: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database Server 8.1' (pgsql-8.1) failed to start. Verify that you have sufficient privileges to start system services.
I got this error when I try to install postgresql on windowx XP i am using the ins
die "Could not cp $FULLPATH to $PITRDESTDIR/$FILENAME"
fi
/usr/bin/gzip -f "$PITRDESTDIR/$FILENAME"
#
# Make sure it worked, otherwise roll back
#
if [ $? -ne 0 ]; then
/bin/rm -f "$PITRDESTDIR/$FILENAME"
die "Could not /usr/bin/gzip $PITRDESTDIR/$FILE
.1.3 compiled from source.
PGDATA is in /usr/local/pgsql/data which is a local RAID10 array, and /pg_xlog
is mounted on a local RAID1.
Things that touch the /mnt/pgbackup directory are the pitr base backup scripts
which run twice monthly and the archive_command script.
--
Jeff Fros
duce: put a long
sleep in the archive-command script.
Thanks Tom. I'll try and reproduce on one of the other PG servers I have
available when I have a chance and get back to you if it looks like a possible
bug.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC
On Mon, 15 May 2006, Simon Riggs wrote:
On Mon, 2006-05-15 at 09:28 -0700, Jeff Frost wrote:
I've run into a problem with a PITR setup at a client. The problem is that
whenever the CIFS NAS device that we're mounting at /mnt/pgbackup has
problems
What kind of problems?
10016009A"
May 15 02:07:07 db3 crond(pam_unix)[14632]: session closed for user postgres
May 15 02:07:33 db3 postgres[14702]: [1-1] LOG: autovacuum: processing database
"postgres"
May 15 02:08:48 db3 postgres[14724]: [1-1] LOG: autovacuum: processing
happens. The time delay between
archiver wedging and foreground wedging would then correspond to how
long it took the XID counter to reach the next 32K multiple. (Jeff,
what transaction rate do you see on that server --- is that a plausible
delay for some thousands of transactions to pass?)
This is
On Wed, 17 May 2006, Tom Lane wrote:
The "lurking feeling" scenario above might or might nor be an issue
here, but I can't see how the archiver could be involved at all.
Well, I don't see it either; at this point we're waiting on Jeff to
provide some harder evi
ce, but I'm just getting started.
Currently I'm using pgbench to generate WAL rollover, do you guys have any
other handy testing tools for this sort of job or is this the best tool?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingll
On Wed, 17 May 2006, Jeff Frost wrote:
On Wed, 17 May 2006, Tom Lane wrote:
Did you try generating a test case using a long sleep() as a replacement
for the archive_command script? If there is a PG bug here it shouldn't
be that hard to expose it in a simple test case. I'm up to
On Thu, 18 May 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
I seem to get alot of these:
May 17 21:34:04 discord postgres[20573]: [5-1] WARNING: could not rename file
"pg_xlog/archive_status/00010001.ready" to
May 17 21:34:04 discord postg
On Wed, 17 May 2006, Jeff Frost wrote:
And in the window where I started postgres via pg_ctl, I had this:
cat: pg_xlog/0001000E: No such file or directory
cat: pg_xlog/0001000E: No such file or directory
Hrmmm...my pgbench died with an integer out of range
the test so I can capture the
logging to syslog for you guys as well as the stdout on the pg_ctl console.
More later.
Unfortunately, I'm not really sure this is related to the problems we saw
before. (i.e. the system doesn't get unusually slow or anything, nor do the
connection
On Fri, 19 May 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Do you think the postmaster on 5432 is trying to archive the other
postmaster's WAL files somehow?
Not as long as they aren't in the same data directory ;-). What Simon
was wondering about was whe
ou want me to test a patch since I've already got this test
case setup.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)
restarted?
I looked through /var/log/messages* and there wasn't a restart prior to the
problem in the logs. They go back to April 16. The postmaster was restarted
on May 15th (this Monday), but that was after the reported problem.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fr
n attempting to reproduce the problem?
--
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 in
ilure to see if that could be it.
--
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/reading thro
with the same archive_command script and a CIFS mount just to see what
happens. Perhaps the real root of the problem is elsewhere, it just seems
strange since the archive_command is the only postgres related process that
accesses the CIFS share. More later.
--
Jeff Frost, Owner <[EMAIL
On Sun, 21 May 2006, Jeff Frost wrote:
So the chances of the original problem being archiver related are
receding...
This is possible, but I guess I should try and reproduce the actual problem
with the same archive_command script and a CIFS mount just to see what
happens. Perhaps the real
uggestions or inspirations, I'm all ears!
--
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 c
On Fri, 19 May 2006, Simon Riggs wrote:
On Thu, 2006-05-18 at 10:08 -0700, Jeff Frost wrote:
May 18 08:00:18 discord postgres[20228]: [129-1] LOG: archived transaction log file
"0001007F"
May 18 08:00:41 discord postgres[20573]: [254-1] LOG: archived transactio
[EMAIL PROTECTED] wrote:
> Is there a way to do a selective pg_dump of a table using a select
> where clause? As in ... dump all records where now-col_date < 2 or
> col_date='01-may-2006' etc.. ?
You can transfer the subset of data to another table, e.g.,
create table my_dump as select * from tabl
tom format with
default compression.
I need to get a reasonable dump so I can upgrade this ancient system. Should
I upgrade to the most recent 7.3.x version before doing the dump to have the
most reasonable chance of success?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
10:17am up 1004 days, 7 min, 1 user, load average: 0.00, 0.00, 0.00
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
On Wed, 7 Jun 2006, Jeff Frost wrote:
On Tue, 6 Jun 2006, Tom Lane wrote:
Some cursory trawling in the REL7_3 sources says that this means that
"SELECT DISTINCT loid FROM pg_largeobject" found a large object OID
that then could not be found by an indexscan of pg_largeobject. So
On Fri, 9 Jun 2006, Jeff Frost wrote:
Got the REINDEX completed and found a new error that I haven't seen before:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: Memory exhausted in
AllocSetAlloc(96)
pg_dump: The command was: FETCH 100 IN blobcmt
pg_dumpall: pg
all just call
pg_dump or do I need to change it there too? Thanks for the help Tom. I'll
report back with the status.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---
running a test dump now, so we'll see sometime tomorrow (it takes about 20
hrs with the current setup) if it worked properly or if I find a new problem.
:-)
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-
On Fri, 9 Jun 2006, Jeff Frost wrote:
On Fri, 9 Jun 2006, Tom Lane wrote:
pg_dumpall calls pg_dump, so only one place to fix. I've already
committed the fix in CVS, if you'd prefer to use a tested patch.
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump
On Sat, 10 Jun 2006, Jeff Frost wrote:
I'm running a test dump now, so we'll see sometime tomorrow (it takes about
20 hrs with the current setup) if it worked properly or if I find a new
problem. :-)
You'll be happy to hear that the test dump was successful and actually only
ql-8.1.4 compiled
from the source tarball. Autovacuum is turned on and I'd love for it to be
able to keep up.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-
On Wed, 21 Jun 2006, Jeff Frost wrote:
The DB with the large objects that I had trouble dumping two weeks ago is now
exhibiting some interesting fsm issues. The DB stores lots of large objects
used for medical research statistics and the data is generally input during
the day (9am-3pm
On Wed, 21 Jun 2006, Jeff Frost wrote:
Current limits are: 10 page slots, 2000 relations, using 713 KB.
NOTICE: number of page slots needed (102608) exceeds max_fsm_pages
(10)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a
value o
;s not too much..I wonder if having large objects makes for special
vacuuming fun..or maybe autovacuum can't deal with large objects? I didn't
find anything like that in the docs.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultin
On Thu, 22 Jun 2006, Jeff Frost wrote:
On Thu, 22 Jun 2006, Jim Nasby wrote:
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: free space map contains 3339998 pages in 125 relations
DETAIL: A total of 3341600 page slots are in use (including overhead).
3341600 page slots are required to track all
ing alongside the list of regular tables. Regular tables
* will be entered into the table list even if they appear not to need
* vacuuming; we go back and re-mark them after finding all the vacuumable
* toast tables.
*/
So I guess it does take toast tables into account.
--
Jeff Frost, Owner
-(end of broadcast)---
TIP 5: don't 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
-
t,
Do you already have a MRTG plugin for postgres that you've written and if so,
care to share it with the rest of us? Or better yet, share it with the
mrtg.org folks? I was thinking of writing one, but if you have one already, I
hate to reinvent the wheel.
--
Jeff Frost, Owner &l
u didn't reload the postgresql service after
making the changes or because it is matching another entry first. The
pg_hba.conf is parsed in a top down manner with the first match winning.
Post your pg_hba.conf and we can likely help you. Remember that you must
reload the postgresql serv
crash and has it
been resolved? What is your filesystem?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 6: e
. If you have an older version the terminology
is likely different, but the effect is similar.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)-
terminated:
Daniel,
I would guess this is more appropriate for the -admin list so I cc'd it.
I think you are most likely running out of memory or running up against a
ulimit on memory. I would first check my ulimit settings on the postgres user
and see if they are a bit small.
--
Jeff
insertion has finished. The structure didn't change since a while.
Daniel,
Was this 'free' output before or after the crash? Also, have you combed
through /var/log/messages for anything interesting that happened around the
time of the crash? Which postgresql version is this?
--
Je
../data directory.
Unfortunately, I'm not much of an expert on reiserfs, but what happens when
you try to stat the files that give you the problem? You might also try
stracing the ls -l and see what system error you're receiving.
stat ...postmaster.pid
strace ls -l ...data
--
Jeff Fr
l/bin/mrtg-pg-xact.sh db1`
MaxBytes[db1-xacts]: 125
Title[db1-xacts]: db1 Database transactions per second
PageTop[db1-xacts]: Database transactions per
YLegend[db1]: xacts per second
ShortLegend[db1]: tps
Legend1[db1]: Transactions per second
LegendI[db1]: :
Options[db1]: nopercent
--
Jeff Fr
ry I found
nothing (I haven't spent much time there since the web-site is awfully
slow).
So, I'd like a recommendation.
Mario
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 65
ld chmod 000 the master directory you're
looking at right now and
postgresql could still startup, because it's not
where you think it is.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.p
So, is the working postmaster running in /var/lib/pgsql/data?
Have you taken Tom's advice and run 'VACUUM pg_database' ? Or even just
'vacuumdb -av' ?
On Fri, 28 Jul 2006, Mingzuo Shen wrote:
Thanks Jeff!
No, cannot do that.
Because the folder has only the "
and I realy
don't need failover cluster capabilities.
Mike
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
lete or update old data or was it just
a straight insert?
--
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: I
ACUUM FULL VERBOSE
Actually, you should not have to run VACUUM FULL ever if you vacuum often
enough, that's why I suggest you use pg_autovacuum. You can find it in the
contrib modules for 8.0.x or builtin to the 8.1.x server.
Jeff Frost wrote:
On Wed, 30 Aug 2006, Joe McClintock
tgres) groups=26(postgres)
context=user_u:system_r:unconfined_t
--
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
On Fri, 15 Sep 2006, Michael Fuhr wrote:
On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote:
On Thu, 14 Sep 2006, Michael Fuhr wrote:
Can anybody else with a Linux box test the above command?
On my FC4 machine running 2.6.16-1.2111_FC4:
uid=26(postgres) gid=26(postgres) groups=26
again?
On Sat, 16 Sep 2006, [EMAIL PROTECTED] wrote:
is there any way to correct this problem? please help.
On Fri, 15 Sep 2006, Michael Fuhr wrote:
On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote:
On Thu, 14 Sep 2006, Michael Fuhr wrote:
Can anybody else with a Linux box tes
ved this message by mistake, please immediately notify us by
replying to the message and delete the original message immediately thereafter.
Thank you.
FADLD Tag
**
--
Jeff Frost, Owner &
, bits: 256)
Or are you missing the SSL connection line?
--
Jeff 'Frosty' Frost - AFM #996 - Frost Consulting, LLC Racing
http://www.frostconsultingllc.com/ http://www.motonation.com/
http://www.suomy-usa.com/ http://www.motionpro.com/
http://www.mot
code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.
postgres=#
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting
On Tue, 26 Sep 2006, Jeff Frost wrote:
It seems that for some reason either your server or your client are not
trying to use SSL. Note the: "SSL off" in the error message you received.
Do you have a server.crt in the data directory of the postgres server?
I guess I should have
On Tue, 26 Sep 2006, Tom Lane wrote:
"Jeanna Geier" <[EMAIL PROTECTED]> writes:
[ hostssl works with 'trust' but not 'md5' ]
It's only when I change the connection method to 'md5' that I'm running into
problems -- then I cannot connect from pgadmin or the command line.
As for Jeanna's proble
On Tue, 26 Sep 2006, Jeff Frost wrote:
As for Jeanna's problem, I don't see any password prompt at all in her
example. I've forgotten the details, but wasn't there a password
prompting problem with 8.0.x on Windows?
It worked great with 8.1.4. Let me download 8.0.8 and
On Tue, 26 Sep 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Do you remember if the problem was on the 8.0.8 server side that caused the
lack of prompting?
No, I'm pretty sure it was a client-side issue (and I thought we'd fixed
it by 8.0.8 anyway, so I'm
On Tue, 26 Sep 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Interestingly, I receive the same error when I disable SSL on the server:
If SSL is disabled then hostssl lines in pg_hba.conf effectively become
no-ops --- they can never be matched since no incoming connectio
On Tue, 26 Sep 2006, Jeff Frost wrote:
But, when I put the trust line back with hostssl, I do not get connected as
per her original indication. Of course this is with my 8.1.4 windows server
and not 8.0.8. Is it possible that 8.0.8 was more liberal with the hostssl
vs host interpretation if
On Tue, 26 Sep 2006, Jeanna Geier wrote:
Any thoughts?? Like I said previously, I did build this on Windows from
source so we could use the SSL option.could I have missed something when
I was doing that? (It was my first time and I was following instructions from
the INSTALL docs)
Jean
guess it's also possible
you need to turn on the view hidden and system directories in the explorer
options to see/find in that directory, but I'm not sure.
--
Jeff 'Frosty' Frost - AFM #996 - Frost Consulting, LLC Racing
http://www.frostconsultingllc.com/ http://www.m
rigger _mpscluster_denyaccess_29 ON markets;
DROP TRIGGER
ALTER TABLE summary_target DROP CONSTRAINT markets_summary_target_fk; ERROR:
"markets_pk" is an index
Suggestions as to what I can do to remove this non subscribed table from the
slave?
--
Jeff Frost, Owner <
fo on pg_index here in
the docs: http://www.postgresql.org/docs/8.1/static/catalog-pg-index.html
select i.indexrelid,c.relname from pg_index i, pg_class c where i.indexrelid =
c.oid;
will likely give you what you're after.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
pgpitrha project. We haven't released any tarballs yet, but you
could pull some useful scripts out of CVS.
http://pgfoundry.org/projects/pgpitrha
If this doesn't get you on the right track, perhaps you can define what you
mean by hot backup more precisely.
--
Jeff Frost, Owner
if (!overflow)
{
ereport(LOG,
(errmsg("statistics buffer is
full")));
overflow = true;
}
}
--
Jeff Frost, Owner
On Wed, 8 Nov 2006, Joshua D. Drake wrote:
On Wed, 2006-11-08 at 18:46 -0800, Jeff Frost wrote:
What does the message 'statistics buffer is full' mean? And if I saw lots of
these in my logs what sort of bad things would happen? Presumably this is
related to the planner statistics
essened in 8.2, correct?
--
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 checked our extensive FAQ?
101 - 200 of 366 matches
Mail list logo
