oblem to recur, or maybe
it would fix the problem for good.
Cheers,
Jeff
>
ll look like it
was needed, and get fired again the next naptime, so that it could continue
with the truncation attempts. (Rather than waiting for 20% turnover in the
table before trying again). I'm not convinced by this argument. If the
DBA is desperate to get the space back, they can go do vacuum full.
Otherwise, let the space get nibbled away on the ordinary autovac schedule.
Cheers,
Jeff
Then that is the ticket ... I mis-interpreted the Postgres documentation
on the segment files and naming ...
Thank you for the feedback ... It was a very big help and I appreciated
it!!
Thanx!
Jeff
Jeff L'Huillier ( La-Hill-Yer )
Snappy little phrases here just get me in tr
ivedir/%f filenames
are "00010001000D.2012-0411.021245" (.-MMDD.HHMMSS) vs.
just "00010001000D"
I'm assuming the restore process works with the files at hand, sorted by
file create/modify timestamp, and not explicit filename...
Thanx!
this
adversely affect the restore_command and render the %f file coming back
unusable?
Thanx!
Jeff
Jeff L'Huillier ( La-Hill-Yer )
jeff.lhuill...@onstar.com
Snappy little phrases here just get me in trouble
There are so many parameters it is quite easy to
miss one.
-Jeff
-Original Message-
From: Peter Eisentraut [mailto:pete...@gmx.net]
Sent: Sunday, January 01, 2012 7:21 AM
To: Jeff Rule
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] unix domain sockets on Windows.
On lör, 2011-1
Does the postgres server support listening on unix domain sockets on windows?
It seems to me that they do not, but this is not called out directly in the
documentation.
Listen_address in postgresql.conf
listen_addresses = '' # what IP address(es) to listen on;
Mac and Linux have a different notion of what
en_US collation means (I couldn't find any standard anywhere to say that
one was right and the other was wrong). So, that risks index corruption.
Regards,
Jeff Davis
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To mak
Try starting
it by hand with pg_ctl as the postgres user:
pg_ctl -D /path/to/data/dir start
and see if it outputs anything useful to the console.
--
Jeff Frost, Owner
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
--
Sent via
/check_postgres/check_postgres.pl.html#fsm_pages
On Mon, 6 Oct 2008, Barbara Stephenson wrote:
HI Jeff,
Thank you for the link to explain FSM however I understand the concept where
it would be faster to know where to store data based on an insert or an
update but the results of the last few lines
t be. You can also start up psql and
issue:
show dynamic_library_path ;
to see if it's says anything other than $libdir.
Probably worthwhile to also do a 'show config_file;' to see which
postgresql.conf the running server is using.
--
Jeff Frost, Owner <[EMAIL PROTECTE
5: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> psql:pg_buffercache.sql:18: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> psql:pg_buffercache.sql:19: ERROR: current transacti
1000 (500ms or 1s) so that you log slow queries. Note
that 500ms is just an example, set it to a value you consider slow so that it
will log your slow queries. Then, after you've gathered some
data, run it through pgfouine. http://pgfouine.projects.postgresql.org/
--
Jeff Frost,
On Sun, 31 Aug 2008, Alvaro Herrera wrote:
Jeff Frost wrote:
I guess this isn't entirely accurate, as the above script returns 35883,
but vacuum verbose returns:
INFO: free space map contains 111435 pages in 10005 relations
Well, what this means is that not every single table has u
Jeff Frost wrote:
> Alvaro Herrera wrote:
>> Jeff Frost wrote:
>>
>>
>>> Tom, is there an easy (or hard) way to count relations from all DBs by
>>> using the system catalogs?
>>>
>>
>> Just do a count(*) from pg_class where
Alvaro Herrera wrote:
> Jeff Frost wrote:
>
>
>> Tom, is there an easy (or hard) way to count relations from all DBs by
>> using the system catalogs?
>>
>
> Just do a count(*) from pg_class where relkind in ('r', 't', 'i'),
On Tue, 26 Aug 2008, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
No I actually mean that this part:
Current limits are: 60 page slots, 1 relations, using 4587 kB.
NOTICE: max_fsm_relations(1) equals the number of relations checked
HINT: You have at least
On Tue, 26 Aug 2008, Carol Walter wrote:
On Aug 26, 2008, at 3:09 PM, Jeff Frost wrote:
Looks like vacuum verbose doesn't report the number of relations necessary
on version 8.2.7. It just reports the max_fsm_relations value instead:
INFO: free space map contains 113311 pages in
_relations".
VACUUM
postgres=# show server_version;
server_version
8.2.7
Does it do this in more recent versions of 8.2 or 8.3?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-
e the dropdb command. Of course I'd still recommend you rename
the DB till you're sure the restore was successful.
Tena Sakai
[EMAIL PROTECTED]
-----Original Message-
From: Jeff Frost [mailto:[EMAIL PROTECTED]
Sent: Fri 8/22/2008 10:28 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql
Jeff Frost wrote:
> Tena Sakai wrote:
>>
>> > If you want to restore all the databases that were in this
>> > postgresql installation at the time of the backup, then the
>> > best thing to do is drop all those DBs before attempting the
>> > restore.
y to upgrade. I'm not sure if you mentioned
what version you were using in your original post.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
e COPY statements you need, then feed those through psql.
I think we need more info about what you're trying to accomplish though.
-Original Message-
From: [EMAIL PROTECTED] on behalf of Tena Sakai
Sent: Fri 8/22/2008 3:56 PM
To: Jeff Frost
Cc: pgsql-admin@postgresql.org
Subject:
On Fri, 22 Aug 2008, Tena Sakai wrote:
Many thanks, Jeff.
I am now clued in as to what "postgres" means in the
context of "psql -f infile postgres". Also, thanks
for a tip for stdout and stderr redirection.
What I am still a bit shaky is whether or not I should
issue
all the create database commands necessary for restoring every
database that was dumped.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
--
Sent via pgsql-admin mailing list (pgsql-admin@postgr
postgres
or
ps aux | grep postgres
depending what ps variant your system includes.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
--
Sent via pgsql-admin mailing list (pgsql-admin@postg
kartik wrote:
Hello there,
Can anyone tell me the differences between postgresql 8.1 and
postgresql 8.3.3
Thanks
Waiting for your reply
Sure, just have a look here:
http://www.postgresql.org/docs/8.3/static/release-8-3.html
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
s
postgres 2663 2525 0 May02 ?00:02:12 postgres: wal writer process
postgres 2664 2525 0 May02 ?00:07:16 postgres: autovacuum
launcher process
postgres 2665 2525 0 May02 ?00:04:56 postgres: stats
collector process
--
Jeff Frost, Owner <[EMAIL PROTECTED]&g
Carol Walter wrote:
Hi, Again.
I tried this and got the same message. It is as follows:
-bash-3.00$ /opt/csw/postgresql/bin/pg_ctl -D
/dbpdisk/postgres/prod_823 -m fas
t stop
pg_ctl: PID file "/dbpdisk/postgres/prod_823/postmaster.pid" does not
exist
Is server running?
Are there other ide
want to get the databases
vacuumed before I start trying to create and load a new database. I'm
concerned that there won't be enough index space for the system to
sort and copy the indices.
What's the error? All I see in this email is a warning about
max_fsm_pages and that sho
t from which
you're connecting, reload postgresql, then use ALTER ROLE to set the password
back to something you know. Finally, change you pg_hba.conf back to its
previous value then reload postgresql again.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC ht
avior different inside a plpgsql function?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscri
> Are there scripts to automate this look at stats?
> Or could one draw graphs from that values, to visualize how well the db
> is? E.g., if you could calculate a % value, you could make RRD stats to
> see it's change over time. Is there any project on this?
I don't know about rrd graphing it,
On Fri, 28 Mar 2008, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
A look at the code revealed that the temp tables were created via normal
methods, so I'm curious to know if there is a bug regarding temp tables not
going away on Postgresql-8.2.x after the connection is cl
was fine.
A look at the code revealed that the temp tables were created via normal
methods, so I'm curious to know if there is a bug regarding temp tables not
going away on Postgresql-8.2.x after the connection is closed?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting
On Wed, 27 Feb 2008, Tena Sakai wrote:
Hi Jeff,
What does your .pgpass look like?
*:5432:canon:postgres:winkwink
There's the problem. That says, any host, port 5432, canon database, postgres
user, password. But pg_dumpall needs to connect to all the databases
including template
On Wed, 27 Feb 2008, Tena Sakai wrote:
Hi Jeff,
You cuaght me with a fine point.
but I didn't see HOME being exported.
I have changed the script accordingly:
And the result/my claim remains the same as before:
pg_dumpall: could not connect to database "template1":
e home directory of the relevant user. You
need to set up your PATH and HOME manually, and cd to your home directory
before sourcing .bashrc for this to work.
. ~/.bashrc *might* work, but it's better to be specific (:
hth,
Steve
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Fros
On Wed, 27 Feb 2008, Tena Sakai wrote:
Hi Jeff,
I bet the $HOME environment variable isn't
being set by your cron implementation.
Try putting an echo $HOME in your script and
see if it's defined.
I did. Here's the result:
+
PGUSER: postgres
PGDATABASE: canon
PG
.
I am asking if you have any suggestion in a
similar fashion.
I am all ears.
Just use the .pgpass file. Here's the documentation page for 8.2:
http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://ww
On Wed, 27 Feb 2008, Tena Sakai wrote:
Hi Jeff,
Thanks for your reply, but I think you might
have missed an earlier thread. I am afraid
I have tried what you suggest. Below's my
previous post.
filename=`date +%G%m%d.%w`.gz
/usr/local/pgsql/bin/pg_dumpall > $filename
Here'
ame FROM information_schema.tables
WHERE table_type = 'BASE TABLE')) ss
ORDER BY tablesize+indexsize+toastsize+toastindexsize DESC;
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7
On Thu, 27 Dec 2007, Alvaro Herrera wrote:
Jeff Frost wrote:
That's a drag as I have quite a few clients who graph the xacts/sec with
MRTG. Most of these clients have read heavy workloads and it would be great
to be able to graph read vs write xacts, but a drag if you have no
visibility
On Thu, 27 Dec 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
On Thu, 27 Dec 2007, Tom Lane wrote:
But note that as of 8.3, SELECT-only transactions won't acquire an
XID and hence won't advance the counter. So if you're thinking of
writing code that dep
new XID counter won't advance unless there's at least one
INSERT/UPDATE/DELETE in the transaction? Does it also update for SELECTs that
call a function which does some write activity?
Is there a new counter (or old one that I don't know about) that keeps track
of the SELECT-only
s to another syslog
server.
For your situation, perhaps send PG logs to eventlog, then look for
Windows software to forward eventlog to a remote syslog. I know
something like that exists, but I've never actually used it.
Better yet, if your XP box has the resources, install the free VMw
On Nov 25, 2007 8:24 AM, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Why is it not allowed to call pg_start_backup when WAL archiving is off?
> Wouldn't this be useful as a discrete file system backup without PITR
> capability?
Because a file system level backup is no good unless the database is
index in Informix.
Thanks,
Jeff
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
e backup of login
roles in postgresql.
I know how to take database backup. It is giving me all the schemas in the
selected database, but not creating the login roles required when restoring
the database
Thank you
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consu
On Fri, 31 Aug 2007, Jeff Frost wrote:
On Fri, 31 Aug 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Why does it request it twice?
I think the reason is that the rollforward cycle is
fetch next segment into RECOVERYXLOG
process segment
On Fri, 31 Aug 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Why does it request it twice?
I think the reason is that the rollforward cycle is
fetch next segment into RECOVERYXLOG
process segment
unlink RECOVERYXLOG
and only when the "
On Fri, 31 Aug 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
It seems like everything is happy, except it seems to ask for the 4F
log file more than once.
IIRC that's standard procedure. Is there a reason your recovery_command
can't support it?
Really? If
ry, postgres exits with signal 6 just the same.
Conversely, using a default postgresql.conf file in the 'broken' directory
leaves it just as broken.
The master can start/stop just fine with no problems.
What else to look at? I do have a core file, back trace can be found here:
ht
> I wish that was the case the linux version has to be installed locally. If
> you are running Winders you can connect remotely but we don't want to do
> that.
Maybe you could use pgpool or something similar to allow it to think it's
connecting locally and still move it off the actual postgresq
you want to try something like:
COPY foo FROM '/tmp/foo' WITH CSV QUOTE AS '\'';
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
-
The configuration files are suppose to work
just fine. I just need to install the new version.
Lance,
That's correct. You can just stop the old version, install the new version
and start it up, no dump/restore necessary.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consul
y need to know, a REINDEX changes the relfilenode, so you
can see the creation time of the file in the data directory
corresponding to the current indexes of the table. That will probably be
the last time REINDEX was run.
Does that help?
Regards,
Jeff Davis
---
On Tue, 24 Apr 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
Well, finally got this system upgraded to 8.1.8, but unfortunately, that did
not resolve this. Is there any reasonable way to see where this function is
spending it's time?
I've grown enamored of
On Fri, 16 Mar 2007, Jeff Frost wrote:
On Fri, 16 Mar 2007, Jeff Frost wrote:
On Fri, 16 Mar 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
... Interestingly, when you
strace the backend, it doesn't appear to be doing too much...here's some
sample output:
ls -lh on the db dump.
Anyway
of checking a size of a given database I have tried
the sql using select pg_database_size ('dbaname'); but no joy.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-790
reated the file.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL projec
x27;s likely been put in there
by pgadmin. As a test - move .pgpass to .pgpass.old and try to connect via
psql -U postgres -d myDataBase again.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 6
OID
AND c.relkind = 'S'
;
--
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: explain analyze is your friend
On Fri, 16 Mar 2007, Jeff Frost wrote:
On Fri, 16 Mar 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
... Interestingly, when you
strace the backend, it doesn't appear to be doing too much...here's some
sample output:
select(0, NULL, NULL, NULL, {0, 1000
On Fri, 16 Mar 2007, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
... Interestingly, when you
strace the backend, it doesn't appear to be doing too much...here's some
sample output:
select(0, NULL, NULL, NULL, {0, 1000}) = 0 (Timeout)
semop(3932217, 0x7fbfffd150
_count;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION populate_page_view_clickstreams() OWNER TO postgres;
On Fri, 16 Mar 2007, Shoaib Mir wrote:
Are the stat collector and autovacuum processes in good shape?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 3/16/07, Jeff
I can share the function code tomorrow when people are awake again
in case we have something especially silly in there.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
/ best regards,
Josef Springer
(Gesch?ftsleitung/Management)
[Postal]
Address
[EMAIL PROTECTED]
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]
Office
+49 (0)89 600 6920
[Phone]
Fax
+49 (0)89 600 69220
[Web]
Web
http://www.joops.com
[JOOPS]
-- the software company --
--
Jeff Frost,
Yes, pgadmin3 uses .pgpass to store its connection info - so that's your
likely culprit.
On Thu, 1 Mar 2007, Rob van der Linde wrote:
I had a .pgpass file in the home directory of the client PC. It's
possible PgAdmin III or some other program created it.
--
Jeff Frost, Owner
ld be appreciated.
Rob,
The local OS user on the server should have no effect on postgres connectivity
when connecting via the network.
Do you by chance have a .pgpass file in the home directory of the OS user
you're using to run psql?
Also, did you reload postgresql after you made th
but I need to configure in my
language.
Thanks in advance.
Jeff Frost escreveu:
BTW, this was for an RPM installed version of postgresql. As Shoab
mentions in another mail, if you have compiled postgresql from
tarball, you'll have to cd into the contrib/tsearch2 dir and make &&
make
BTW, this was for an RPM installed version of postgresql. As Shoab mentions
in another mail, if you have compiled postgresql from tarball, you'll have to
cd into the contrib/tsearch2 dir and make && make install before you can do
this stuff.
On Thu, 1 Feb 2007, Jeff Frost wrote
squery('spiderman');
Hopefully that helps...
On Thu, 1 Feb 2007, Alexander B. wrote:
Hi,
I need to install tsearch2, but I couldn't find a procedure (step-by-step).
Could you recomend some site or some steps to install.
I used PG 8 on Suse and Debian, and I installed postgres by source.
Thanks in advance.
___
Yahoo! Mail - Sempre a melhor op??o para voc?!
Experimente j? e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Wed, 17 Jan 2007, Ray Stell wrote:
On Wed, Jan 17, 2007 at 01:18:06PM -0800, Jeff Frost wrote:
On Wed, 17 Jan 2007, Ray Stell wrote:
Why is there pg_dumpall instead of a pg_dump with some flag?
pg_dumpall does all DBs plus the globals, but I'll have to let one of the
developers a
ginal
8.1.3, that I've done before, but I'm unclear as to the meaning of what you're
saying at the moment. Please enlighten me.
Jeff Frost <[EMAIL PROTECTED]> wrote: Andrew,
If you're moving between major versions, a dump/restore is necessary. The
proper procedure is:
nding part of what you wrote. Unless you mean the
upgrading, I'm not certain what you mean by 'replace' in your example.
Should I be trying to have both copies of Postgres running at once or
something like that? And if so, how would I do that?
Jeff Frost <[EMAIL PROTECTED]>
And of course, I should have made mention of the docs here:
http://www.postgresql.org/docs/8.1/interactive/migration.html
because it likely explains it better than I am. :-)
On Wed, 17 Jan 2007, Jeff Frost wrote:
You have to dump the original 7.4.9 version of the database and restore that
t I'm supposed to be dumping? If you mean making a copy of the original
8.1.3, that I've done before, but I'm unclear as to the meaning of what you're
saying at the moment. Please enlighten me.
Jeff Frost <[EMAIL PROTECTED]> wrote: Andrew,
If you're moving betwe
gs - Yahoo! Music Unlimited.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 4: Have you searched o
http://www.postgresql.org/about/donate
<http://www.postgresql.org/about/donate>
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
--
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: explain analyze is your friend
ave a constantly-increasing maximum value as rows are added and updated; such
a column will probably need more frequent statistics updates than, say, a
column containing URLs for pages accessed on a website. The URL column may
receive changes just as often, but the statistical distribution of its v
hen is the last time you ran ANALYZE? That's what the -z option does. If
you're only vacuuming once daily, you should definitely analyze with the -z
flag as well.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650
On Thu, 21 Dec 2006, Arnau wrote:
And as result I got a file of 2.2GB. The improvement has been quite big but
still very far from the 10-15 minutes that Jeff says or the Thomas'3 minutes.
Just FYI, if you were reporting the DB size by the size of the compressed dump
file, then that&
al Xeon with 4 GB of ram and with a RAID 5. Probably it has the
default values. Any suggestion about what parameters I should change to speed
it up?
Have a look at:
http://www.powerpostgresql.com/PerfList
and
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
--
Jeff Frost, Ow
w how exactly do this.
Arnau,
2GB and it takes 12 hours? What sort of server is this running on? Does your
postgresql.conf have all default values perhaps? I routinely dump DBs that are
4-8GB in size and it takes about 10-15 minutes.
--
Jeff Frost, Owner <[EMAIL PROTECT
tiple smaller
files for processing.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(end of broadcast)---
TIP 4: Have you searched ou
On Fri, 17 Nov 2006, Tom Lane wrote:
Jeff Frost <[EMAIL PROTECTED]> writes:
I believe you must list all 4 octets of the subnet.
Oh, duh. The comments in inet_aton() show that it is interpreting
"10.6" in what most people nowadays would find a surprising way:
the right of this must be zero in the given
IP address.
Which tells me the 0s have to be there.
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---(
k here for support though:
http://www.pgadmin.org/support/
Looks like they have a FAQ and a support mailing list. Good luck!
On Tue, 14 Nov 2006, adey wrote:
Thanks very much Jeff.
I'm sorry, I'm not very strong on Unix and will need to give my sysadmin
some instructions.
Is the daemon
> pgAdmin isn't a tool???
> How can I install the feature Jobs and how can I schedule some
procedure?
>
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
--
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?
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
if (!overflow)
{
ereport(LOG,
(errmsg("statistics buffer is
full")));
overflow = true;
}
}
--
Jeff Frost, Owner
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
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
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 <
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
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
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, 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
1 - 100 of 366 matches
Mail list logo