[ADMIN] Are you running v7 on Debian?

n into a snag. Thanks! -Nick ----- Nick Fankhauser Business: [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ Personal: [EMAIL PROTECTED] http://www.infocom.com/~nickf

Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

Can't help with the search engine, but the answer to your question is: psql . I'd recommend starting with the tutorial in the docs for questions like this. http://www.postgresql.org/docs/7.3/static/tutorial-start.html I can also confirm that the search engine in the docs area (http://www.postgres

[ADMIN] Specific questions about wraparound and vacuum

tions are occurring? If so, how to I deal with template0? Thanks. -Nick -- ------ Nick Fankhauser [EMAIL PROTECTED] http://www.doxpop.com 765.965.7363 765.962.9788 (Fax) Doxpop - Public Records at Your Fingertips.

Re: [ADMIN] Specific questions about wraparound and vacuum

On 8/8/07, Nick Fankhauser <[EMAIL PROTECTED]> wrote: > the largest containing rows. Oops- I meant to say "...the largest containing 56 million rows". One other question- when I'm vacuuming, I always get the warning: WARNING: some databases have not been vacuum

Re: [ADMIN] Specific questions about wraparound and vacuum

On 8/8/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Nick Fankhauser" <[EMAIL PROTECTED]> writes: > > One other question- when I'm vacuuming, I always get the warning: > > > WARNING: some databases have not been vacuumed in transactions > > HINT:

Re: [ADMIN] Specific questions about wraparound and vacuum

IL PROTECTED]> wrote: > On Wed, Aug 08, 2007 at 12:07:14PM -0400, Nick Fankhauser wrote: > > 2) If a regular (non-full) vacuum will not reset the XID. Will a > > dump/restore take care of wraparound? We have done this in the past for > > space reclamation because we seem to

[ADMIN] Intentionally splitting data in a table across files.

nyone have an idea about how to address this need in a different way using existing tools? -Nick ----- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - htt

RE: [ADMIN] newbie question

> Here is the file. Please give me more suggestions. Actually, I think the best place to set this would be in the config file. The right place depends on which version you are running. If your version is lower than 7.1, put a line in postmaster.init that looks like this: PGALLOWTCPIP=yes If

Re: [ADMIN] Starting postmaster with the option -i

Raquel- I believe that by v7.1, this could be placed in the postgresql.conf file. (Found in /etc/postgresql on our Debian Linux box.) the line to add is: tcpip_socket = 1 check out this page for details: http://www.postgresql.org/idocs/index.php?runtime-config.html It's probably not starting

[ADMIN] Can't get postmaster to restart after removing WAL files

nt. Any ideas? TIA- -Nick ----- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - http://www.doxpop.com/ ---(end of broadcast)--- TIP 6: Have you searc

How much space should I allocate for WAL files? (was: RE: [ADMIN] Can't get postmaster to restart after removing WAL files)

ers.home.net/rthall3 > > - Original Message - > From: "Nick Fankhauser" <[EMAIL PROTECTED]> > To: "pgsql-admin" <[EMAIL PROTECTED]> > Sent: Tuesday, September 11, 2001 7:16 AM > Subject: [ADMIN] Can't get postmaster to restart after

Re: [ADMIN] Can't get postmaster to restart after removing WAL files

problem if I'm too stingy on my space allocation. Thanks Robert & others for your help with this! -Nick ----- Nick Fankhauser Business: [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court record

[ADMIN] Another WAL question

archiving or deleting old ones? TIA, -Nick ----- Nick Fankhauser Business: [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - http://www.doxpop.com/ Personal: [EMAIL PROT

Re: [ADMIN] Another WAL question

> In 7.1.3 and 7.2, there are only 2-3 WAL files kept because there is no > need to keep them after a checkpoint. This answers my original question- it sounds like after 3, they get recycled or deleted, so if I reserve 48Mb (3*16) for these, I should be OK. ...Right? > Is there any need to hav

[ADMIN] Can't get postmaster to restart after removing WAL files

nt. Any ideas? TIA- -Nick ----- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop - Court records at your fingertips - http://www.doxpop.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] PostgreSQL->JDBC->Tomcat->Apache resource uses

istakes that you can help me avoid? I've looked at Tony Grant's article on his version of this setup, & I'm trying to digest Bruce Momjians's big "PostgreSQL Internals" article, but so far, I haven't found these particular questions addressed. Thanks everyon

Re: [ADMIN] Importing large data files into PostgreSQL

Liz- Without looking at a chunk of the datafile it is hard to tell what may be wrong, but here are a copy of ideas: If you haven't already looked here, look at this page in the docs: http://www.postgresql.org/idocs/index.php?sql-copy.html try manually inserting a few rows into your table, and

Re: [ADMIN] File structure in 7.1.3

anks- -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behal

Re: [ADMIN] to many connection

the conf file elsewhere, but then have a link from the data directory. Maybe the links are missing if this is the case. -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko &

Re: [ADMIN] authentication problems

If you can't ping localhost, or it doesn't resolve to 127.0.0.1, then you know the problem is at the operating system/network level & postgres and JDBC are probably just fine. -Nick - Nick Fankhauser Business

Re: [ADMIN] buffer overflow (I'm getting it too!)

I have no answer to this, but I'll add my experience to the question. I'm getting the same message, but in my case it is not consistent. It is always during a cron job that does a vacuum analyze in the middle of the night, but not every time the job runs. If I do the same thing interactively (the

Re: [ADMIN] buffer overflow (I'm getting it too!)

Thanks Stephan- we'll quit worrying about the messages unless they coincide with other problems. Regards, -Nick > They should be safe (mostly a debugging message). IIRC, there were > known bugs in earlier versions that happened on the reset, but that these > were fixed and noone has found any

Re: [ADMIN] What is the default password for the user postgres..

for more: http://www.postgresql.org/idocs/index.php?client-authentication.html#PG-HBA. CONF Hope this helps. -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consultin

Re: [ADMIN] setting up ODBC

Jodi- Take a look at the section titled "Configuring Postgresql for JDBC" on this page: http://www.fankhausers.com/postgresql/jdbc/#driver_install Although the instructions are intended for JDBC, I believe the IP connection part is the same. -Nick -Original Message- From: [EMAIL PROT

Re: [ADMIN] table test

The nature of your question has more to do with table structure than database administration, so I'd suggest going to the pgsql-sql or pgsql-general lists in the future- you might get better answers there. -Nick -- Nick

Re: [ADMIN] Permission Denied When i am Trying to take Backup

pparently don't have such an option on the version I'm running.) > -Original Message- > From: Moovarkku Mudhalvan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 10, 2001 7:01 AM > To: Stephan Szabo; Nick Fankhauser > Cc: Laurette Cisneros; [EMAIL PROTECTED]

Re: [ADMIN] What may be the url we need to use to connect the Postgres Database with Java

nf file, and set up authorization in pg_hba.conf (search on these filenames in the interactive documentation for more. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co.

Re: [ADMIN] Visio

t. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubsc

Re: [ADMIN] Visio

-Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with th

Re: [ADMIN] table test

I did not understand the question. Can you restate your purpose or tell us more about what you are trying to achieve? (No entendía la pregunta. ¿Puede usted exponer su propósito en forma modificada o decirnos más sobre lo que usted está intentando alcanzar?) -Nick (with the aid of http://www.go

Re: [ADMIN] Shared Memory

Chris: The quick answer is here- a little more than halfway down the page. http://www.postgresql.org/idocs/index.php?kernel-resources.html Regards, -Nick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Ruprecht > Sent: Saturday, December

Re: [ADMIN] Data partitioning

needs? -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Ravindra Wankar

Re: [ADMIN] user passwords

You might want to take a look at your pg_hba.conf file to see if the auth-method is "trust". Details are here: http://www.postgresql.org/idocs/index.php?client-authentication.html#PG-HBA. CONF -Nick -- Nick

Re: [ADMIN] Allowing TCP/IP connections

I think this may have been answered earlier due to mailing list oddities, but just in case: Change this: #tcpip_socket = false to this: tcpip_socket = true You may also need to make some changes in pg_hba.conf to authorize the connection from a particular host. Although this page is aimed at

Re: [ADMIN] Allowing TCP/IP connections

I think this may have been answered earlier do to mailing list oddities, but just in case: Change this: #tcpip_socket = false to this: tcpip_socket = true You may also need to make some changes in pg_hba.conf to authorize the connection from a particular host. Although this page is aimed at J

Re: [ADMIN] unknown index

This my be simpler than the answer you were after, but... If you're getting something like "cannot insert duplicate key into unique index fred", you could type: "\d fred" at a psql prompt to learn what column(s) fred refers to. You can learn even more by digging into the system tables, but I'll l

Re: [ADMIN] granting all to user

There's no command to essentially grant on all to a user, but it's pretty easy to write a select that produces a bunch of grant statements for you based on the system tables. then you log the results & run them... -Nick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PRO

Re: [ADMIN] granting all to user

I should have just given you this example in my earlier reply- this is how I quickly get a batch of grant statements- you can probably modify it for your needs: select 'grant select on '||relname||'to "www-data";' from pg_class where relname not like 'pg%'; -Nick > -Original Message-

Re: [ADMIN] client connection problem

ust -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behal

Re: [ADMIN] drop column?

mp; then copy from the old to new using "insert into table newtable (col1,col2) values (select col1,col2 from oldtable);" -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ont

Re: [ADMIN] Increasing Shared Memory - on MacOS X

Chris- This thread from Darwin might help you identify someone who is in the know about shared memory: http://www.darwinfo.org/devlist.php3?number=1385 -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283

[ADMIN] Database is slow, vacuum hangs

sts I should do to learn what happened before trying a restart? I'm running PGSQL 7.1.3 on Debian Linux 2.4.14 Thanks- -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko &

Re: [ADMIN] Database is slow, vacuum hangs

> Is the vacuum actually running (accumulating any CPU time)? Or is it > just waiting on a lock held by one of those other guys? After a little blip at startup, it stops using CPU. Here's a snippet of the "ps": 21966 pts/0S 0:00 /bin/sh /usr/lib/postgresql/bin/vacuumdb temp 21971 pts/

[ADMIN] long vacuum

orking hard at something... I'm running PGSQL 7.1.3 and Debian Linux 2.4.14 on an Athlon 1.4Ghz box with 512MB RAM & IDE drives. Any thoughts appreciated- I'm trying to decide whether I should cancel the vacuum & do an autopsy. -NF -

[ADMIN] Optimizing a condition based on an a very unequally distributed value.

that I want to test for, which could be either [ = 'NO' ] or [ != 'YES' ]? Thanks! -NickF -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ -

Re: [ADMIN] Optimizing a condition based on an a very unequally distributed value.

Thanks for the answer! ...but now I have more questions: Is it true that if I use this condition in a join that further constrains the results, this might use the index? Does PGSQL know that few or many rows will be returned because of data gathered from the last vacuum? What do you mean by "tu

Re: [ADMIN] slow inserts

Jodi- Have you tried turning autocommit off & doing a single commit after the load? -NickF -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter Sent: Wednesday, March 20, 2002 2:19 PM To: Postgres Admin List Subject: [ADMIN] slow inserts I am c

Re: [ADMIN] pg_dump max file size exceeded

Pipe it into gzip: pg_dump db_name|gzip>dbname.sql.gz NickF -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.on

Re: [ADMIN] PgSQL postmaster.opts

idocs/index.php?runtime-config.html You should also consider the upgrade to a newer version of postgresql- the advantages are significant. -NickF -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray

[ADMIN] A plan returned by explain doesn't make sense to me

arrange my query to help the planner come to the same conclusion, and most puzzling, why does the planner choose an index that involves actor_id? Many thanks to those of you who read through all of this! Any suggestions? -Nick -------

[ADMIN] error in my last post

d it will be correct. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

Re: [ADMIN] A plan returned by explain doesn't make sense to me

> That seems strange to me also, particularly if the index column ordering > is indeed actor_id,case_id and not the other way round Tom- Actually, it *is* the other way around- I didn't realize that could make a difference. Here's the line that creates it: create unique index actor_case_assign

Re: [ADMIN] A plan returned by explain doesn't make sense to me

Tom Lane wrote: > The only reason the planner should choose a single-column index over > using the first column of a multi-column index is that the latter index > is likely to be physically larger and thus require more I/O to access. > So, there's no penalty in the cost calculations other than the

Re: [ADMIN] New User - options and other "get going" questions.

le: /etc/init.d/postgresql restart 5)Initialize the database location: (su - postgres; initlocation PG_STAGING) 6)Create the database: (createdb staging -D PG_STAGING) Regards, -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone

[ADMIN] Will an outer join on two indexed fields use the indexes?

ill be more efficient? Thanks! -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--

[ADMIN] More question about plans & explain (long)

the field? I guess that's enough questions for now. If you've made it this far, thanks for reading all of this! I look forward to hearing your thoughts. -Nick -- Nick Fankhauser [EMAIL PRO

[ADMIN] A *short* planner question

I know I'm about to become a pest, but I promise, this is a short one! Before doing the explain below, I specifically did a verbose analyze & noted that the results seemed in line with what I expected. I'm on v7.1.3 of PGSQL Here's the query that runs too slow: (It takes about 30 seconds on a 1.

Re: [ADMIN] A *short* planner question

d add a bit of code to my load process that will populate this field with upper(actor_full_name). It's a bit of a kludge, but should work until the day that you get to adding stats for function indexes. Thanks for the help. -Nick ------

Re: [ADMIN] A *short* planner question

re detailed stats and hopefully would make a better > estimate of the number of matches. 7.2 on our development box is on the middle-priority TODO list. (2-4 weeks.) I'll provide feedback when we get there. As always, thanks for the help! -Nick -------

Re: [ADMIN] string PK vs. interger PK

much so they must be close. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ -Original Message

Re: [ADMIN] JDBC and servlet

osing connections really drags your performance down quickly! Regards, -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services

Re: [ADMIN] Bad plan

Brian- I'm not sure if this will help the performance, but I believe this statement is equivalent: update v set nl=nl+1 where exists (select 'x' from l where l.sid = v.id and l.did = 123456); -Nick --

Re: [ADMIN] JDBC and servlet...

-test the second issue would be to do an "su - www-data" while running your tests from the command line. Hope this helps! -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.97

Re: [ADMIN] Connection problem

pg_hba. -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -Original Message- > From: [EMAIL PROTECTED] > [mailto

[ADMIN] An Analyze question

48) -> Seq Scan on local_case_type (cost=0.00..12.22 rows=522 width=48) ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] An Analyze question

> Could we see the queries? (No, I do not remember your view definitions.) Sure! I'll append the details below. (I was hoping we had correctly guessed the cause & you wouldn't need details...) > Offhand I would think that 7.2 is smart enough to deal with this We're on 7.1.3. We're working to

Re: [ADMIN] An Analyze question

> select attname,attdispersion,s.* > from pg_statistic s, pg_attribute a, pg_class c > where starelid = c.oid and attrelid = c.oid and staattnum = attnum > and relname = 'actor_case_assignment'; > > in each database? Here are the results: The "Before" database: attname | attd

Re: [ADMIN] An Analyze question

> In the "after" case you are showing "18105XS" as the most common > actor_id, with a frequency of 11.2% of the entries. Where'd that > come from? Is it correct? I believe this is correct, and the reason I've not been getting poor performance on the old database is that the stats are not up to

[ADMIN] Avoiding transaction ID wrap

ry? -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgr

Re: [ADMIN] Permission on tables

on that the servers are separated. You could test the connectivity & authorization from X to Y by trying (from X) psql -hY regards, -Nick ----- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 doxpop -

Re: [ADMIN] Permission on tables

work either, > which I find strange. It would seem that life is MUCH easier if Apache and > Postgres are installed on the same host, but that's not the case... > > I'm reinstalling the apache machine now anyway, because I don't like the > way RH installed the rpm'

Re: [ADMIN] ALTER TABLE for field modify...

ints: http://www.postgresql.org/idocs/index.php?sql-createtable.html regards, -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http:/

[ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

are appreciated. Regards, -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--- TIP 3: if posting/r

Re: [ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

Tom- Thanks! your diagnosis was correct & the repair worked. -Nick & Ray > I'm beginning to think there is something seriously messed up about your > installation. The simplest theory is that the indexes on pg_attribute > are corrupted. ... > You should be able to recover using REINDEX

Re: [ADMIN] [JDBC] Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)

Gordon- This looks like a subject for the PSQL-ADMIN list. I'll forward it over there, & you should also look there for the response. I know that one of the 7.1->7.2 issues is that unicode chars were not checked/rejected by 7.1 if there was no multibyte support in the compile, but you seem to hav

[ADMIN] Is it safe to increase pg_attribute.atttypmod ?

at will come back to haunt us later? -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---(end of broadcast)--- TIP 5: Have you checke

Re: [ADMIN] Is it safe to increase pg_attribute.atttypmod ?

Tom, Joe: > Yup, that's the standard hack. Thanks very much! This saved us hours. -Nick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] cannot find attribute 1 of relation (second occurrence.)

time, the only coincidence I can think of was updating pg_attribute.atttypmod for several records last night. Could this have caused my problem? Any other ideas? Thanks everyone! -Nick ------ Nick Fankhauser [EMAIL PROT

Re: [ADMIN] cannot find attribute 1 of relation (second occurrence.)

Tom- No Problem- we'll do that. Is there a table that contains the mapping from the database object names to the actual filenames? -Nick > Next time it happens, would you shut down the > postmaster and make a copy of pg_attribute and its indexes (the physical > files) to send to me, before you

Re: [ADMIN] two databases

s on a different machine, you'd want to add the IP address(es) & mask & change local to host. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Soft

Re: [ADMIN] how to install postgresql!!

Try: ls -al /tmp make sure the permissions on /tmp are: drwxrwxrwt >please answer in chinese That's a skill I don't have- I hope you can work with this... -Nick ------ Nick Fankhauser [EMAIL PROT

Re: [ADMIN] LIKE operator and indexes

Marc- I've just gone through some similar query optimizing work, and I can confirm that LIKE can definitely use an index if the initial characters are supplied as in the example you sent. -Nick -- Nick Fankhauser [

Re: [ADMIN] What err ???

li As Coluna FROM >Clientes WHERE RazaoSocial Like '%A%' Regards, Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

Re: [ADMIN] What err ???

o move them to postgresql, or simply how to make the run better in access? Maybe if you restated the question you'd get some better responses. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.

Re: [ADMIN] What err ???

issues. (Like my silly questions!) -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---

Re: [ADMIN] Err sum number with Date ?

x.php?functions.html You may also want to learn how to create your own functions in case there is no equivalent: http://www.postgresql.org/idocs/index.php?sql-createfunction.html -Nick -- Nick Fankhauser [EMAIL PROTECTED]

Re: [ADMIN] Divide Date with integer

.org/idocs/index.php?sql-expressions.html Regards, -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ -Or

Re: [ADMIN] set permanent date style

> Cc: Martin Teoh; [EMAIL PROTECTED] > Subject: Re: [ADMIN] set permanent date style > > > "Nick Fankhauser" <[EMAIL PROTECTED]> writes: > > in postmaster.conf, add a line that looks something like this: > > PGDATESTYLE=ISO,European > > I do not beli

Re: [ADMIN] Importing Database

-Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[E

Re: [ADMIN] Missing or Erroneous pg_hba.conf file

onf to you off-list, and you can use it as a starting point to edit again, (using a unix editor this time ). Or alternately, you can probably use a dos->unix filter on the old file. Regards, -Nick ------ Nick Fankhauser [EM

[ADMIN] Are statistics gathered on function indexes?

usand rows really are returned indicates that the index would still be a good choice. Is there a way to make the planner favor index scans a bit more? (Other than the drastic set enable_seqscan to off.) Thanks -Nick -- Ni

Re: [ADMIN] Are statistics gathered on function indexes?

10:37 PM > To: [EMAIL PROTECTED] > Cc: pgsql-admin > Subject: Re: [ADMIN] Are statistics gathered on function indexes? > > > "Nick Fankhauser" <[EMAIL PROTECTED]> writes: > > [see subject] > > Nope, they ain't. I agree they should be. > > > Can s

Re: [ADMIN] Change date format

You can set it either within the session, or set a default. For details, check this page in the docs: http://www.postgresql.org/idocs/index.php?sql-set.html (Look for DATESTYLE) Regards, -Nick -- Nick Fankhauser [EMAIL

Re: [ADMIN] db connection fails

file locations may vary by OS flavor, but in Debian, you can find a log in /var/log/postresql.log. You may have to turn on logging in postgresql.conf. -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax

Re: [ADMIN] db connection fails

o, take a look at your pg_hba.conf file. Info on how to set it up can be found here: http://www.postgresql.org/idocs/index.php?client-authentication.html -Nick ------ Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax

Re: [ADMIN] db connection fails

--Original Message- > From: Mark Tessier [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 02, 2002 1:27 PM > To: Nick Fankhauser > Cc: [EMAIL PROTECTED] > Subject: Re: [ADMIN] db connection fails > > > > > > Have you tried doing a network connection with your > "a

Re: [ADMIN] Oracle data -> PostgreSQL

http://techdocs.postgresql.org/ (Look about halfway down the page) -Nick > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Camargo > Sent: Wednesday, July 03, 2002 1:57 AM > To: [EMAIL PROTECTED] > Subject: [ADMIN] Oracle data -> PostgreSQ

Re: [ADMIN] PostgreSQL data -> Oracle

Back in the days when I used Oracle, there was something called SQL*Loader that allowed you to read a flat ASCII file into an Oracle table. If I were doing this, I think I'd do a pg_dump of the data, filter the dump file to remove the "copy" commands & then use SQL*Loader or it's newer equivalent

Re: [ADMIN] unsubscribe me for heavens sakes!!!!!!!!!

TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of ashwini sridhar > Sent: Tuesday, July 09, 2002 8:51 PM > To

[ADMIN] logging queries

if this is possible & if so, what runtime settings are needed? Thanks -Nick -- Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services ht

  1   2   >