Re: [ADMIN] [PERFORM] Postgres log(pg_logs) have lots of message

2013-04-11 Thread Jeff Janes
oblem to recur, or maybe it would fix the problem for good. Cheers, Jeff >

Re: [HACKERS] [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables

2013-04-11 Thread Jeff Janes
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

Re: [ADMIN] 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename

2012-04-11 Thread L'Huillier, 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

Re: [ADMIN] 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename

2012-04-11 Thread L'Huillier, Jeff
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!

[ADMIN] 9.0.4/7 WAL Archiving: archive_command add date-time to cp of filename

2012-04-11 Thread L'Huillier, Jeff
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

Re: [ADMIN] unix domain sockets on Windows.

2012-01-05 Thread Jeff Rule
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

[ADMIN] unix domain sockets on Windows.

2012-01-01 Thread Jeff Rule
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;

Re: [GENERAL] [ADMIN] Streaming Replication limitations

2011-04-14 Thread Jeff Davis
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

Re: [ADMIN] Postgres will no longer startup

2009-02-08 Thread Jeff Frost
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

Re: [ADMIN] Recommend dba maintenance tasks on a regular bases

2008-10-06 Thread Jeff Frost
/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

Re: [ADMIN] Errors installing contrib

2008-09-19 Thread Jeff Frost
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

Re: [ADMIN] Errors installing contrib

2008-09-19 Thread Jeff Frost
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

Re: [ADMIN] Recommend dba maintenance tasks on a regular bases

2008-09-12 Thread Jeff Frost
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,

Re: [ADMIN] vacuum verbose relations reporting

2008-08-31 Thread 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

Re: [ADMIN] vacuum verbose relations reporting

2008-08-31 Thread Jeff Frost
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

Re: [ADMIN] vacuum verbose relations reporting

2008-08-26 Thread Jeff Frost
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'),

Re: [ADMIN] vacuum verbose relations reporting

2008-08-26 Thread Jeff Frost
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

Re: [ADMIN] vacuum verbose relations reporting

2008-08-26 Thread Jeff Frost
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

[ADMIN] vacuum verbose relations reporting

2008-08-26 Thread Jeff Frost
_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-

Re: [ADMIN] restoring from dump

2008-08-23 Thread Jeff Frost
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

Re: [ADMIN] restoring from dump

2008-08-22 Thread Jeff Frost
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.

Re: [ADMIN] restoring from dump

2008-08-22 Thread Jeff Frost
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

Re: [ADMIN] restoring from dump

2008-08-22 Thread Jeff Frost
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:

Re: [ADMIN] restoring from dump

2008-08-22 Thread Jeff Frost
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

Re: [ADMIN] restoring from dump

2008-08-22 Thread Jeff Frost
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

Re: [ADMIN] Who's attached to the database?

2008-07-03 Thread Jeff Frost
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

Re: [ADMIN] Query

2008-06-27 Thread Jeff Frost
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]>

Re: [ADMIN] Continuing issues... Can't vacuum!

2008-05-23 Thread Jeff Frost
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

Re: [ADMIN] Continuing issues... Can't vacuum!

2008-05-23 Thread Jeff Frost
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

Re: [ADMIN] Continuing issues... Can't vacuum!

2008-05-23 Thread Jeff Frost
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

Re: [ADMIN] Can't reinstall b/c don't know the very long installation password

2008-05-16 Thread Jeff Frost
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

[ADMIN] updating table with foreign keys cause locking of referenced row/table?

2008-04-10 Thread Jeff Frost
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

Re: [ADMIN] Tuning

2008-04-08 Thread Jeff Frost
> 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,

Re: [ADMIN] Strange issue with vacuum and temp tables

2008-03-28 Thread Jeff Frost
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

[ADMIN] Strange issue with vacuum and temp tables

2008-03-28 Thread Jeff Frost
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

Re: [ADMIN] trouble with pg_dumpall

2008-02-27 Thread Jeff Frost
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

Re: [ADMIN] trouble with pg_dumpall

2008-02-27 Thread Jeff Frost
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":

Re: [ADMIN] trouble with pg_dumpall

2008-02-27 Thread Jeff Frost
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

Re: [ADMIN] trouble with pg_dumpall

2008-02-27 Thread Jeff Frost
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

Re: [ADMIN] trouble with pg_dumpall

2008-02-27 Thread Jeff Frost
. 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

Re: [ADMIN] trouble with pg_dumpall

2008-02-27 Thread Jeff Frost
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'

Re: [ADMIN] How much space do database objects take up in data files

2008-02-13 Thread Jeff Frost
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

Re: [ADMIN] What's the XID?

2007-12-27 Thread Jeff Frost
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

Re: [ADMIN] What's the XID?

2007-12-27 Thread Jeff Frost
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

Re: [ADMIN] What's the XID?

2007-12-27 Thread Jeff Frost
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

Re: [ADMIN] Enable Syslog on Postgres

2007-11-29 Thread Jeff Larsen
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

Re: [ADMIN] pg_start_backup without WAL archiving

2007-11-25 Thread Jeff Larsen
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

[ADMIN] Indexes for Foreign Keys?

2007-10-29 Thread Jeff Larsen
index in Informix. Thanks, Jeff ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [ADMIN] Taking backup of login roles in postgresql 8.2

2007-10-24 Thread Jeff Frost
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

Re: [ADMIN] pitr replica dies on startup

2007-08-31 Thread Jeff Frost
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

Re: [ADMIN] pitr replica dies on startup

2007-08-31 Thread Jeff Frost
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 "

Re: [ADMIN] pitr replica dies on startup

2007-08-31 Thread Jeff Frost
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

[ADMIN] pitr replica dies on startup

2007-08-31 Thread Jeff Frost
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

Re: [ADMIN] How to monitor resources on Linux.

2007-08-29 Thread Jeff Frost
> 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

Re: [ADMIN] How to import CSV file?

2007-08-28 Thread Jeff Frost
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 -

Re: [ADMIN] Upgrade from 8.1.4 to 8.1.9

2007-06-24 Thread Jeff Frost
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

Re: [ADMIN] [GENERAL] Time of previous REINDEX execution..

2007-05-08 Thread Jeff Davis
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 ---

Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-05-03 Thread Jeff Frost
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

Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-04-23 Thread Jeff Frost
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:

Re: [ADMIN] Checking a size of a given database

2007-04-17 Thread Jeff Frost
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

Re: [ADMIN] security question

2007-04-04 Thread Jeff Frost
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

Re: [ADMIN] security question

2007-04-04 Thread Jeff Frost
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

Re: [ADMIN] sequences

2007-04-04 Thread Jeff Frost
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

Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-03-16 Thread Jeff Frost
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

Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-03-16 Thread Jeff Frost
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

Re: [ADMIN] pl/pgsql function spikes CPU 100%

2007-03-16 Thread Jeff Frost
_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

[ADMIN] pl/pgsql function spikes CPU 100%

2007-03-16 Thread Jeff Frost
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

Re: [ADMIN] Can not restore a dumped database

2007-03-08 Thread Jeff Frost
/ 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,

Re: [ADMIN] pg_hba.conf stuff

2007-02-28 Thread 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

Re: [ADMIN] pg_hba.conf stuff

2007-02-28 Thread Jeff Frost
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

Re: [ADMIN] ADMIN Install Tsearch2 - new dic

2007-02-02 Thread Jeff Frost
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

Re: [ADMIN] Install Tsearch2

2007-02-01 Thread Jeff Frost
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

Re: [ADMIN] Install Tsearch2

2007-02-01 Thread Jeff Frost
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

Re: [ADMIN] Upgrade/Installation problem: Version 7.4.9 to version

2007-01-17 Thread Jeff Frost
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

Re: [ADMIN] Upgrade/Installation problem: Version 7.4.9 to version

2007-01-17 Thread Jeff Frost
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:

Re: [ADMIN] Upgrade/Installation problem: Version 7.4.9 to version

2007-01-17 Thread Jeff Frost
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]>

Re: [ADMIN] Upgrade/Installation problem: Version 7.4.9 to version

2007-01-17 Thread Jeff Frost
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

Re: [ADMIN] Upgrade/Installation problem: Version 7.4.9 to version

2007-01-17 Thread Jeff Frost
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

Re: [ADMIN] Upgrade/Installation problem: Version 7.4.9 to version

2007-01-17 Thread Jeff Frost
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

Re: [GENERAL] [ADMIN] OUTER JOIN IS SLOW

2006-12-23 Thread Jeff Frost
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

Re: [ADMIN] Problem with large table not using indexes (I think)

2006-12-23 Thread Jeff Frost
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

Re: [ADMIN] Problem with large table not using indexes (I think)

2006-12-23 Thread Jeff Frost
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

Re: [ADMIN] Suggestions needed about how to dump/restore a database

2006-12-21 Thread Jeff Frost
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&

Re: [ADMIN] Suggestions needed about how to dump/restore a database

2006-12-19 Thread Jeff Frost
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

Re: [ADMIN] Suggestions needed about how to dump/restore a database

2006-12-19 Thread Jeff Frost
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

Re: [ADMIN] how do I load a 8.0.8 database with unicode encoding

2006-11-28 Thread Jeff Frost
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

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Jeff Frost
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:

Re: [ADMIN] remote connections to Windows based server

2006-11-17 Thread Jeff Frost
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 ---(

Re: [ADMIN] Use Jobs

2006-11-13 Thread Jeff Frost
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

Re: [ADMIN] Use Jobs

2006-11-13 Thread Jeff Frost
> 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 --

Re: [ADMIN] statistics buffer is full

2006-11-08 Thread Jeff Frost
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?

Re: [ADMIN] statistics buffer is full

2006-11-08 Thread Jeff Frost
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

[ADMIN] statistics buffer is full

2006-11-08 Thread Jeff Frost
if (!overflow) { ereport(LOG, (errmsg("statistics buffer is full"))); overflow = true; } } -- Jeff Frost, Owner

Re: [ADMIN] Script for hotbackup

2006-11-07 Thread Jeff Frost
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

Re: [ADMIN] Question

2006-11-07 Thread Jeff Frost
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

[ADMIN] error: markets_pk is an index

2006-11-03 Thread Jeff Frost
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 <

Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

2006-09-26 Thread Jeff Frost
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

Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

2006-09-26 Thread Jeff Frost
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

Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

2006-09-26 Thread Jeff Frost
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

Re: [ADMIN] pg_hba.conf: 'trust' vs. 'md5' Issues

2006-09-26 Thread Jeff Frost
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   2   3   4   >