Re: [GENERAL] psql: FATAL: Ident authentication failed for user "postgres"

Got it about cc'ing. Actually, I restarted postgres using: /etc/init.d/postgresql restart Any other suggestions? From: Chris [mailto:[EMAIL PROTECTED] Sent: Mon 5/19/2008 8:34 PM To: Dan Joo; pgsql-general@postgresql.org Subject: Re: [GENERAL]

Re: [GENERAL] psql: FATAL: Ident authentication failed for user "postgres"

r besides the pg_hba.conf file? Thanks for your help, Dan From: Luigi Castro Cardeles [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 5:53 AM To: Dan Joo Subject: Re: [GENERAL] psql: FATAL: Ident authentication failed for user "postgres" hi, what's your mac

Re: [GENERAL] psql: FATAL: Ident authentication failed for user"postgres"

Hi Karsten, The only non-commented lines are: [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#' local all all trust hostall all 127.0.0.1/32 trust hostall all ::1/128

Re: [GENERAL] psql: FATAL: Ident authentication failed foruser"postgres"

: Re: [GENERAL] psql: FATAL: Ident authentication failed foruser"postgres" On Tue, May 20, 2008 at 08:50:16AM -0700, Dan Joo wrote: > The only non-commented lines are: > > [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#' > > local all all

Re: [GENERAL] psql: FATAL: Ident authentication failedforuser"postgres"

authentication failedforuser"postgres" On Tue, May 20, 2008 at 09:47:55AM -0700, Dan Joo wrote: > Is there a command that I can use to find out which file PG is looking > into for the settings in pg_hba.conf? Could it be that the config file > is not even titled "

[GENERAL] FAQ correction for Windows 2000/XP

rol Panel applet for ODBC management. The answer should read: "Go to Programs -> Administrative Tools -> Data Sources and Add the PostgreSQL Unicode driver". Hope this helps, Dan Dascalescu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you

[GENERAL] postgres connection problem via python pg DBI

Hi all, I have a problem connecting to postgres via the python pg module ONLY from the cgi-scripts. The command is: db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None) >From the commandline the connection works great, but from a cgi-script it barfs with the following m

Re: [GENERAL] postgres connection problem via python pg DBI

Just solved it. For others, here is the solution. setsebool -P httpd_can_network_connect_db 1 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Joo Sent: Thursday, June 05, 2008 4:18 PM To: pgsql-general@postgresql.org Subject: [GENERAL] postgres connection problem

Re: [GENERAL] Table X its full, what can i do now?

x asasaxax wrote: CREATE SEQUENCE "public"."teste_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 32767 START 1 CACHE 1 CYCLE; What can i do to be able to continue inserting rows on this table? Thanks a lot. Make the max value of your sequence larger. A lot l

[GENERAL] PITR - warm standby switchover question

I've followed the implementation instructions at 24.4.2: http://www.postgresql.org/docs/current/static/warm-standby.html And I've used the archive/restore commands from the example in F23.2: http://www.postgresql.org/docs/current/static/pgstandby.html This all works great. The primary backs up t

Re: [GENERAL] PITR - warm standby switchover question

Excellent! Thanks. One other quick question... What would happen if I didn't delete the recovery.conf file? Is that step just to prevent accidentally restarting the server with it there? On Tue, Apr 14, 2009 at 6:26 PM, Erik Jones wrote: > > On Apr 14, 2009, at 3:47 PM, Dan

[GENERAL] recover corrupt DB?

is looking for. Is this DB toast? Or is there something I could do to get the DB back into a state where it will start, without losing everything? Thanks, Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] recover corrupt DB?

em fine, but bits and pieces of documentation I've seen for pg_resetxlog also recommend initdb, and starting over. Is that necessary? Thanks, Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] recover corrupt DB?

> These reports seem to come up a bit, with disk full issues resulting in > the need to pg_resetxlog, dump, and re-initdb, but I wouldn't be too > shocked if they all turned out to be on xfs or something like that. > My particular disk-full condition was on ext2. Nothing exotic. Also, the proces

[GENERAL] Checkpoint Tuning Question

here anything I can do to prevent (or minimize) the performance impact of the checkpoint? Thanks, Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Checkpoint Tuning Question

On Wed, Jul 8, 2009 at 12:50 PM, Tom Lane wrote: > Dan Armbrust writes: >> However, once the checkpoint process begins, I get a whole flood of >> queries that take between 1 and 10 seconds to complete.  My throughput >> crashes to near nothing.  The checkpoint takes betwee

Re: [GENERAL] Checkpoint Tuning Question

On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane wrote: > Dan Armbrust writes: >> With checkpoint_segments set to 10, the checkpoints appear to be >> happening due to checkpoint_timeout - which I've left at the default >> of 5 minutes. > > Well, you could increase both

Re: [GENERAL] Checkpoint Tuning Question

itional slow queries logged while the checkpoint process runs. My takeaway is that starting the checkpoint process is really expensive - so I don't want to start it very frequently. And the only downside to longer intervals between checkpoints is a longer recovery time if the system crashes?

Re: [GENERAL] Checkpoint Tuning Question

> However, the latest report says that he > managed that, and yet there's still a one-or-two-second transient of > some sort.  I'm wondering what's causing that.  If it were at the *end* > of the checkpoint, it might be the disk again (failing to handle a bunch > of fsyncs, perhaps).  But if it rea

Re: [GENERAL] Checkpoint Tuning Question

r system into a state where I could build postgres (I was using the binary install) I built a 8.3.4, using your patch - but I didn't see any change in the behaviour. I see hiccups that appear to be the same length as I saw on the binary build of 8.3.4. Thanks, Dan -- Sent via pgsql-general maili

Re: [GENERAL] Checkpoint Tuning Question

> Hm, I'm not sure I believe any of that except the last bit, seeing that > he's got plenty of excess CPU capability.  But the last bit fits with > the wimpy-I/O problem, and it also offers something we could test. > Dan, please see what happens when you vary the wal_buffer

Re: [GENERAL] Checkpoint Tuning Question

> So this thought leads to a couple of other things Dan could test. > First, see if turning off full_page_writes makes the hiccup go away. > If so, we know the problem is in this area (though still not exactly > which reason); if not we need another idea.  That's not a good perma

Re: [GENERAL] Checkpoint Tuning Question

;m happy to test things if you send me patches or custom code. Thanks, Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Checkpoint Tuning Question

On Mon, Jul 13, 2009 at 3:53 PM, Dan Armbrust wrote: >> So this thought leads to a couple of other things Dan could test. >> First, see if turning off full_page_writes makes the hiccup go away. >> If so, we know the problem is in this area (though still not exactly >> which

[GENERAL] array syntax and geometric type syntax

weird cases are below. If someone could explain what the SQL parser is really looking for, and what the "best" or "most correct" way is, I would be grateful. Thanks, Dan Examples: db=# create temporary table x (p point); CREATE TABLE Can't use

Re: [GENERAL] array syntax and geometric type syntax

n does not do any evaluation of what's inside, e.g. SELECT '{1,2,1+2}'::INT[]; doesn't work, but SELECT ARRAY[1,2,1+2]::INT[]; works fine. Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Column info without executing query

information back from the query . Would something like that be possible in postgres ? Regards Dan ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatyp

Re: [GENERAL] Column info without executing query

it has worked before at least http://archives.postgresql.org/pgsql-odbc/2004-09/msg00046.php //Dan ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] text to point conversion not working. ( cannot cast type text to point )

similar error: column "col" is of type point but expression is of type text If the above task can be performed some other way, perhaps I don't require string concatenation -- Dan Libby ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] query takes 65 times longer if I add 1 column (explain attached)

I've got a query that takes a very long time to execute if I add anadditional column to the SELECT clause. Here is Query A, the slow one.  I've numbered the rowsof the EXPLAIN for convenience.psql=# explain analyze SELECT timestamp, src_ip, dst_ip, id,   string_one, string_two FROM table_one LEFT J

Re: [GENERAL] query takes 65 times longer if I add 1 column (explain attached)

What have you got work_mem set to?The default, 1024.  The fact that the estimates diverge so far from reality can no doubt beblamed on the horridly bad rowcount estimates: 3 rows estimated vs 179 actual for table_one, and 128592 estimated vs 4202 actual fortable_two.  Have you ANALYZEd these tables

[GENERAL] Data conversion tools?

res DB. Short of installing an older Postgres DB that PGAdmin II will work with - does anyone else know of a tool that can do what I want? Is there a script of some sort that I can run that would go through a set of tables and lowercase everything? Thanks, Dan --

[GENERAL] `must be superuser to COPY to or from a file' - using perl DBI - approaches to work around this

suggest why it is possible to create a database but not COPY to/from a file as a non-superuser? thanks Dan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] `must be superuser to COPY to or from a file' - using perl DBI - approaches to work around this

Thanks for that. On Mon, 2009-10-12 at 20:21 -0400, Stephen Frost wrote: > * Dan Kortschak (dan.kortsc...@adelaide.edu.au) wrote: > > $dbh->do("COPY chromosome_data FROM '".chromosomes(\%options)."' CSV"); > > > Does anyone have any suggestions

Re: [GENERAL] `must be superuser to COPY to or from a file' - using perl DBI - approaches to work around this

Thanks again. On Mon, 2009-10-12 at 21:14 -0400, Stephen Frost wrote: > > Seems like the way to go, though it will be significantly slower > than > > psql or superuser reads (a couple of tables have ~10s-100sM rows). > > Erm, really? You've tested that and found it to be that much slower? Sorry

[GENERAL] how to ensure a client waits for a previous transaction to finish?

Hi, this is a bit of a noob question. I am using PGSql to perform some large analyses, with the clients being a sequentially run set of perl scripts (one to set up and populate tables and then down stream scripts to query the database for the results). During manual testing everything works, but

Re: [GENERAL] how to ensure a client waits for a previous transaction to finish?

Yes, they are separate perl files (I'm thinking that perhaps this wasn't the best way to do it now, but for the moment I'm going to have to stick with it). In the case of the manual testing it's jus a matter of command line calls. The automated runs call each script as part of a PBS torque script

Re: [GENERAL] how to ensure a client waits for a previous transaction to finish?

Thanks for that, that should help me sort it out. I haven't used the autocommit option in pgdbi. I'll have a look to see if DBI::do has an option to wait for command completion. cheers On Mon, 2009-12-07 at 16:12 -0500, Tom Lane wrote: > It's not. What you want is to COMMIT and make sure you've

Re: [GENERAL] how to ensure a client waits for a previous transaction to finish?

Thanks to everyone who has answered this. The short answer is that torque is not behaving the way I expected and not the way I have ever seen it behave in the past. The I/O binding of these jobs may have something to do with this, but I will look into it further. cheers On Mon, 2009-12-07 at 13:2

Re: [GENERAL] how to ensure a client waits for a previous transaction to finish?

ently because it is not attached to a terminal (this has caused problems for others on that list with sqlite and mysql). Can anyone confirm/refute this? And if it is the case, is there something that I can do about it? thanks again. Dan On Mon, 2009-12-07 at 18:33 -0500, Merlin Moncure wrote: >

Re: [GENERAL] how to ensure a client waits for a previous transaction to finish?

kes ~40-60 hours, and unfortunately the test case takes about 20-30 minutes - I suspect that this problem would not arise with more convenient tests). cheers Dan On Wed, 2009-12-09 at 00:22 -0500, Tom Lane wrote: > That seems unlikely. My best guess at this point is that for some > reason t

Re: [GENERAL] how to ensure a client waits for a previous transaction to finish?

hat I initially thought you were refering to in your first post.) This would essentially be a soft lock. thanks again Dan On Wed, 2009-12-09 at 00:28 -0500, Merlin Moncure wrote: > Advisory locks are basically only useful if the locker of the resource > maintains a database session (that is

[GENERAL] PGCon 2010

Hello folks, PGCon 2010 will be held 20-21 May 2010, in Ottawa at the University of Ottawa. It will be preceded by two days of tutorials on 18-19 May 2010. We are now accepting proposals for talks. If you are doing something interesting with PostgreSQL, please submit a proposal. You might be

[GENERAL] Update view/table rule order of operations or race condition

and 3 from insert_options). The first 3 have null vals and the second 3 have the correct vals. It should be: options_id | options_name | quantity | price | discount +--+--+---+-- 1 | Test | | | 2 | Test 2 |1 | 2 |3 Any ideas why this is or if there is another approach? Thanks, Dan

Re: [GENERAL] Update view/table rule order of operations or race condition

I think I found the problem with this. The rule: CREATE OR REPLACE RULE insert_options AS ON INSERT TO options DO INSTEAD (INSERT INTO a (a_id, type_id, name) VALUES (new.options_id, 6, new.options_name); UPDATE a_item SET val = new.quantity WHERE a_item.a_id = new.options_id

Re: [GENERAL] Update view/table rule order of operations or race condition

On Mar 9, 2010, at 11:00 AM, Tom Lane wrote: Dan Fitzpatrick writes: The rule is creating a new value from the sequence a_a_id_seq for "new.options_id" on each UPDATE call. How do I use the variable new.options_id in the three update statements without incrementing the sequ

[GENERAL] timestamp convert to date

sion give an error ? It would be really nice with the possibility to use infinity with the date type. Regards //Dan

Re: [GENERAL] timestamp convert to date

ks now. Is there a description or manual page on how to install a beta in paralell with my 8.3.10 installation ? regards //Dan 2010/4/30 Tom Lane > Dan S writes: > > I did a test but it looks like date doesn't support infinity as a value. > > Try 8.4 or later. > >regards, tom lane >

[GENERAL] Recreating constraint triggers

Ds and counts, etc, have changed, and that'd just cause other issues. If someone can provide any assistance or info, that'd be tops! Thanks! Dan Herbert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Recreating constraint triggers

> Ouch.  Are you running Slony by any chance? Nope, just a stock install. Both servers are running CentOS. > Do you have *any* idea what caused this? Nothing definitive unfortunately. Looking back through SVN logs for code updates there was mention of disabling triggers to perform a large delete

Re: [GENERAL] More vacuum troubles

| > A vacuum without the analyze gives the error | > ERROR: No one parent tuple was found | | I think you might be getting bit by the same bug that was biting Alfred | Perlstein a month or so back. Try 7.0.3 and see if it's any better... | if not, let me know and we'll probe deeper. | | (Marc

Re: [GENERAL] More vacuum troubles

| | (Marc hasn't officially announced 7.0.3 yet, but to the best of my | | knowledge the release-candidate tarballs currently available from our | | FTP server will be it.) | | I've upgraded to 7.0.3, now I get... | | c2net=> vacuum verbose analyze some_table; | NOTICE: --Relation some_table--

Re: [GENERAL] More vacuum troubles

; | | The very next vacuum I do produces the exact same response. The next one | after that though continues.. And as another side note :) ... vacuum some_table (without the analyze) completes quite happily. Cheers, -Dan -- Man is a rational animal who always loses his temper when he is

Re: [GENERAL] More vacuum troubles

... Actually, the above is rather untrue. vacuum some_table without the analyze gets farther along than with analyze, however it eventually spits back the original error of ERROR: No one parent tuple was found Sorry for running around in circles. :-) Cheers! -Dan -- Man is a rational animal

[GENERAL] DB and Table Permissions

Is there a reason why _any_ user can create a table on a database? Even if they do not own or have any permissions to it? I don't think that should happen. Is there a specific reason why it does? -Dan Wilson

Re: [GENERAL] unique indexes

= a.attnum or i.indkey[5] = a.attnum or i.indkey[6] = a.attnum or i.indkey[7] = a.attnum ) ORDER BY index_name, tab_name, column_name; This was adapted from the psql source. Hope it's what you need. -Dan Wilson - Original Message - From: "Jason Davie

Re: [GENERAL] unique indexes

Tom, Thanks for the update on this query. I'm not positive where I found this query, but I'm pretty sure it was for a v6.5x something. Anyway, thanks. phpPgAdmin has been updated. -Dan - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Dan

[GENERAL] Why PostgreSQL is not that popular as MySQL?

27;m now convinced that PostgreSQL is the way for me to go, this was a long uphill battle driven by my respect for people who had different backgrounds than I, and my xenophilia for different ways of thinking. That momentum in the coder populace at large is going to take a while to overcome. Dan

[GENERAL] Trigger/Function problem

http://www.postgresql.org/users-lounge/docs/7.0/user/c40874340.htm And I get the exact same error (except of course the function name is different). So I'm assuming that it's a problem in my system configuration... I may be wrong. I don't know how to fix this or even where to begin. I do have plpgsql installed as a language. I'm running PG 7.0.2 on standard RedHat 7 ... not sure of the Kernel. Thanks for your help, -Dan

Re: [GENERAL] Trigger/Function problem

If you look at my function definition, you can see that this is not within the function body. This is the testing of the trigger which produces the error. It's just a plain old SQL statment that initiates the trigger. -Dan - Original Message - From: "Robert B. Easte

Re: [GENERAL] Trigger/Function problem

That was it! Thanks Tom. I just put this functionality into phpPgAdmin and of course it is taking the newline char from the browser's OS. Thanks for all your help! -Dan > "Dan Wilson" <[EMAIL PROTECTED]> writes: > > I get the following error: > > NOTIC

Re: [GENERAL] newbie question:

ALTER USER postgres WITH PASSWORD '[enter password]' http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm - Original Message - From: "Leon van Dongen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 18, 2000 1:56 AM Subject: [GENERAL] newbie question

Re: [GENERAL] Auto incrementing fields. How?

Use the column type of SERIAL in your create table statement. This will automatically create a sequence and default for the given column. http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createsequence.htm for more on sequences. - Original Message - From: "Harry Wood" <[EMAIL P

Re: [GENERAL] grant a db

Just recently added this functionality to phpPgAdmin. You can now update the ACL of all the objects (tables, sequences, views) of a database at the same time. This will be part of the next release (2.2.1) which should happen this week sometime. Look for the announcement. -Dan - Original

[GENERAL] NEXTVAL function Bug

' not found test_db=# I know I could just do a: insert into "mixed_Case" (mix_var) values ('not working') But this is for phpPgAdmin and so due to certain issues, I need to have the nextval function work as it would without a mixed case table name. Is this expected behavior? -Dan

[GENERAL] phpPgAdmin 2.2.1 Released!

/download/download.php Tar: ftp://ftp.greatbridge.org/pub/phppgadmin/stable/phpPgAdmin_2-2-1.tar.gz Zip: ftp://ftp.greatbridge.org/pub/phppgadmin/stable/phpPgAdmin_2-2-1.zip ChangeLog: http://pgdemo.acucore.com/ChangeLog -Dan Wilson phpPgAdmin Development Team [EMAIL PROTECTED] PS. If you would like to

Re: [GENERAL] User Privileges

SELECT relacl FROM pg_class WHERE relname = '[table name]' The relacl column contains specific information that must then be parsed to determine the users which have access to a the table and the privileges granted. Example: {"=","dan=arw","group developers

[GENERAL] Selective Auto-Timestamp [using triggers?]

Rajit Singh writes: > The thing is, I also want to be able to update the timestamp field > if I want to... Here's my solution: CREATE FUNCTION updated_stamp () RETURNS OPAQUE AS 'BEGIN IF NEW.updated ISNULL THEN NEW.updated := ''now''; END IF; RETURN N

[GENERAL] exit status 26

Can someone tell me what a postmaster process exiting with status = 26 means? FWIW, I'm doing a COPY table FROM stdin with about 14 million records to trigger this. Thanks, -Dan -- Man is a rational animal who always loses his temper when he is called upon to act in accordance wit

Re: [GENERAL] exit status 26

| > Can someone tell me what a postmaster process exiting with status = 26 | > means? FWIW, I'm doing a COPY table FROM stdin with about 14 million | > records to trigger this. | | That means it got a signal 26. Since you didn't mention what platform | you are on, I'm not going to guess what s

Re: [GENERAL] exit status 26

| > Signal 26 on FreeBSD is SIGVTARLM. | | We don't ever set a virtual timer alarm, either. Is it possible that | you are running the postmaster with a ulimit-style limit on total | process runtime? No, I've tested this and postmaster is being started in an unlimited enviornment. The code

[GENERAL] getting number of rows updated within a procedure

' DECLARE v_number_of_rows int; BEGIN update bigtable set email_confirmed = 1 where user_group = 1234; -- and here, I want to know the number of rows updated v_number_of_rows := *what?*; END; ' LANGUAGE 'plpgsql&

[GENERAL] Re: A pg_dump error.

Then copied from the renamed tables to the new tables. Then I tried the dump, which failed. Then I removed the renamed tables. Then the dump worked. Hope that helps. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ FreshPorts - http://freshports.org/ NZ Broadband - htt

[GENERAL] Re: getting number of rows updated within a procedure

On 15 Jan 2001, at 8:44, J.H.M. Dassen (Ray) wrote: > On Sun, Jan 14, 2001 at 23:27:06 +1300, Dan Langille wrote: > > I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have a > > question: At various times, it does UPDATEs. Is there a way to tell if >

Re: [GENERAL] System tables

eries. phpPgAdmin can be downloaded from: http://www.greatbridge.org/project/phppgadmin -Dan > I'm working on a project which needs to introspect the structure of a > database. I need to fish out table names, attribute names and > type, and foreign keys. > > I had a pok

[GENERAL] 'enum' equivalent?

Steve Leibel writes: > I'm converting a mysql database to postgres. Is there an equivalent > for the enum data type? No, but you can put the enum data in a separate table and join them. This also makes the operation of adding entries to the enum list better defined. Dan

Re: [GENERAL] Connection pooling

Gilles DAROLD writes: > With Apache/mod_perl it is very simple to enable DB connection > persistance. > > in your perl script : > > use vars qw($dbh); > > $dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd); Even better, Apache::DBI will pool across Perl programs, and you don't have to change any

[GENERAL] Weird View behavior

+-(0 rows)   Now what is going on?!?!?  That just plain old doesn't make sense!   Thanks for any help!   -Dan

Re: [GENERAL] php as stored procedures

languages with different strengths. I think Perl does certain things better than PHP but PHP has strengths that Perl probably can't compete with. But for the most part, AFAIK, anything you can do in Perl, you can also do in PHP. -Dan

Re: [GENERAL] pg_dump shell or php?

Here's a simple PHP script that I use. You can backup only certain databases or the whole server. I'm actually planning on making this part of the phpPgAdmin package. You can specify how many days you want the backup files to remain. -Dan #!/usr/

Re: [GENERAL] Re: [HACKERS] Re: Re: grant privileges to a database [URGENT]

e is a way the gurus can accomplish that. -Dan - Original Message - From: "Mike Miller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February

Re: [GENERAL] Re: PostreSQL SQL for MySQL SQL

us it requires an additional call to the database. -Dan

[GENERAL] Trapping NOTICE using PHP

Is there any way to trap the NOTICE output (specifically in PHP)? I would like to impliment an EXPLAIN feature in phpPgAdmin and have been unsuccessful in finding a way to do this because all the information returned by EXPLAIN is in a NOTICE. Any ideas? -Dan

[GENERAL] Re: Tuple is to big

Actually, you should take a look in the documentation. It specifically states that the maximum size for any tuple is 8k (unless compiled otherwise). If you want to store something larger, consider using the large objects feature. Dan Bodoni Endre wrote: > I have a little trouble with

[GENERAL] Re: Row ID and auto-increment?

any form on foreign key or table lookup/join is a bad idea! They should mainly be used when trying to distinguish between similar values in a table (ie: in case some fields are the same, the oid will always be unique). Hope this helps Dan Raymond Chui wrote: > If I create a table like &g

Re: [GENERAL] order of clauses

: SELECT a.x/b.y FROM vals a, (SELECT y FROM vals WHERE y > 0) b WHERE (a.x : / b.y) > 1; How much of a performance hit is there when using a select in the FROM clause? Is it even noticeable? How much better is it to create a static view? -Dan

[GENERAL] A How-To: PostgreSQL from Tcl via ODBC

A friend asked me to figure out how to access PostgreSQL from Tcl via ODBC. For posterity, here's the step by step "how I did it" that I emailed to him. I don't know Tcl, this was just about getting the compile options correct and doing the proper sysadminning to make things work. Comments, sugge

Re: [GENERAL] Re: A How-To: PostgreSQL from Tcl via ODBC

memory) you'll need pretty recent CVS sources. One of the bugs I had to track down even though my original CVS update was only a few weeks old. Dan

[GENERAL] Bug in my ( newbie ) mind?

fix.prefix order by random() limit 1) || ... would be more likely to work (modulo some casting and such). Dan

Re: [GENERAL] Grant on Database?

ppgadmin) has this built into it. It will automatically get the list of tables, sequences and views and run a grant statment on them. Second pointer. GRANT will take multiple "relations" seperated by commas: GRANT ALL ON table1, table1, seq1, seq2, view1, view2 TO my_user; -Dan

Re: [GENERAL] version issue?

date_part('year', date 'today') - 2 UNION SELECT first_name, last_name, middle_name, u.uid, end_year FROM user_info u, current c WHERE u.uid = c.uid ORDER BY UPPER(user_info.last_name); ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns Is this a bug in b

Re: [GENERAL] version issue?

- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> : "Dan Wilson" <[EMAIL PROTECTED]> writes: : > I have the following query running on two different servers. It works on : > 7.0.3 and gives the following error on 7.1beta4. : : > ERROR: A

Re: [GENERAL] version issue?

Excellent! That worked! Thank you once again Tom! I was under the impression that you couldn't use an alias in the ORDER BY. Obviously, I was mistaken. Thanks, -Dan - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> : "Dan Wilson" <[EMAIL

Re: [GENERAL] Re: Anyone can create tables!

Wel guys, thanks for the advice. I guess my own custom CGI would work, or something similar. Your help has been greatly apreciated. I was merely trying to find out if its possible to do it any other way, and you guys have already given me some stuff to think about. Cheers! Dan Lincoln Yeoh

[GENERAL] MetaData

Renaud Tthonnart writes: > Could someone give me some explaination about the metatable(s) of > PostgreSQL? > Where is it and is there to find in it? A good way is to start psql with "-E", it'll then show you the queries it makes from the metatables when you do thin

[GENERAL] Alter column length

x27; where attrelid = (select oid from pg_class where relname = '[table_name]'); - Will doing this cause any problems? -Dan ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] PGVote : a simple polling/voting PostgreSQL-based system

sed anything in the instructions. Downloads from: http://pgvote.unixathome.org/downloads/ Feedback can be left at: http://pgvote.unixathome.org/phorum/ Thanks -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Are we backwards on the sign of timezones?

appears to be consistent with the SQL99 spec. -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Are you frustrated with PostgreSQL

stgreSQL? Would you recommend it over MySQL? Yes. Yes. Friends don't let friends use MySQL. > 5. How often do your PostgreSQL run into problem or crash? Are most of > the problem caused by PostgreSQL itself? I have never seen a PostgreSQL crash. Most if not all

[GENERAL] Getting input from email...

like "[EMAIL PROTECTED]", but what would I need to do to get it into the database? Something in sendmail? Use procmail? Any ideas? --Dan --- Daniel G. DelaneyThe Louisville Times Chorus [

<    1   2   3   4   >