[ADMIN] Time Fields

2001-01-22 Thread robert
We have just installed postgres on a completly rebuild linux 6.2 redhat server. The problem is that when we add a data to our time fields it loses one minite and when we add data to our timestamp field it adds 60 seconds. Any ideas would be helpfull Robert VocalScape

[ADMIN] Database size with postgres 7.2

2004-01-08 Thread Robert
I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. Any suggestions? Robert Young ---

Re: [ADMIN] Database size with postgres 7.2

2004-01-08 Thread Robert
Oli Sennhauser wrote: Hi Robert I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. This scrip

[ADMIN] Easy pg_hba.conf question.

2004-01-24 Thread Robert
#x27;auser' can connect to the database. Thanks for your help, Robert Young ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Easy pg_hba.conf question.

2004-01-24 Thread Robert
Bruno Wolff III wrote: On Sat, Jan 24, 2004 at 12:23:44 -0500, Robert <[EMAIL PROTECTED]> wrote: I want to add a line in a pg_hba.conf file so that the user 'auser' can connect to the database 'aDB' via host based authentication: so far for the line I have: hos

[ADMIN] initdb problem (cygwin)

2004-05-16 Thread Robert
parameter "lc_messages": "3079" initdb: failed initdb: removing data directory "/usr/shared/postgresql/data" hope you can help me. thanks, robert ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] pgsql + php3 expert needed. Can you solve this problem?

1998-12-27 Thread Robert Chalmers
, is refusing a connection from the php3 engine to the database. This is the Error message delivered to the Browser, from the document I called "begin.php3", which is at; http://www.chalmers.com.au/~robert/begin.php3 Warning: Unable to connect to PostgresSQL server: connectDB() -- unknown

[ADMIN] Re: [PHP3] pgsql + php3 expert needed. Can you solve this problem?

1998-12-27 Thread Robert Chalmers
Jay 'Whip' Grizzard wrote: > > > > Try changing this to "host=nangno.yourdomain.com" (or whatever). It sounds > like, for some reason, your setup has forgotten how to lookup names quite > right. Unable to connect to PostgresSQL server: connectDB() -- unknown hostname: 203.1.96.5 No go. nothi

[ADMIN] Re: [PHP3] pgsql + php3 expert needed. Can you solve this problem?

1998-12-27 Thread Robert Chalmers
version of each, of the thousands that you mention? And if it's not caused by incompatibilities with Bind-8, and the DNS is working fine - the system is live 24 hours a day - what is the cause? Robert Rasmus Lerdorf wrote: > > This is the Error message delivered to the Brow

[ADMIN] Re: [PHP3] pgsql + php3 expert needed. Can you solve this problem?

1998-12-27 Thread Robert Chalmers
uld like to get back up and running, not to mention a new one I need for the bookshop! So it looks like I will have to get down into the engine to get this baby running. Meantime, if anyone comes up with a shorter, and less dramatic solution Robert > > > -Rasmus -- http://www.ch

[ADMIN] Thanks for the help folks. Solution found. php3+pgsql

1998-12-27 Thread Robert Chalmers
hings to try, it seems to have boiled down to the usual simple things like slightly changed syntax in most obvious places. and nothing to do with dns thank goodness. thanks folks, Robert -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au

Re: [ADMIN] Encrypted connections to Postgres

1999-06-11 Thread Robert Williams
Brian Baquiran wrote: > I'm talking with the boss about Postgres and the conversation turned to > security. What kind of security features does Postgres have? I'm aware of the > host-based authentication in pg_hba.conf. Are the actual connections to the > database (SQL queries and what they retur

[ADMIN] pg_dump ineffective on 6.4.2?

1999-06-11 Thread Robert Williams
I have two servers (Redhat) with identical databases. I upgraded to one of them to 6.4.2 (RH6.0) and restored the database on that machine from a pg_dump created on the other (6.3: RH5.2) machine. Now pg_dump does not function properly on the 6.4.2 machine. I've included listings of the original

[ADMIN] What size is the postgresql-www mirror

1999-06-16 Thread Robert Chalmers
Does anyone have tha actual size in MB of the postgresql-www mirror. and the postgresql-ftp one as well for that matter... I mean, if one was to mirror it, as per the "So you want to be a mirror" page, how much room is needed... thanks Bob

Thanks for the help folks - Re: [ADMIN] 6.5 on FreeBSD 2.2 - any problems?

1999-06-16 Thread Robert Chalmers
the pointers folks - much appreciated. Bob > > Hi Robert... > > I did all my testing on FreeBSD 4.0, without any > problems...regression tests were "as expected" and everything...haven't > tried my 3.2-STABLE machine yet though, that is *after* my holidays... > &

[ADMIN] Access to multiple Databases

1999-09-22 Thread Robert Niess
entry like this: host username dbname 0.0.0.0 0.0.0.0 crypt which would grant access to the database dbname for user username. Is there any possibility to do something like this? -- Robert Niess begin:vcard n:Niess;Robert x-mozilla-html:FALSE org:University of Karlsruhe adr:;;Klosterweg 28

[ADMIN] Advice about -B n_buffers option

2000-04-06 Thread Robert Williams
I have a postmaster process that is crashing periodically. I haven't turned on debugging yet, but I suspect the number of buffers may be low (its 64). Does anyone have some general observations about the importance of having more buffers? -B n_buffers n_buffers is the number of

[ADMIN] How to do this in postgtreSQL?

2000-04-10 Thread Robert Nosko
Hi, In ORACLE I can perform the following query: SELECT tableA.id, title, qty FROM tableA, (SELECT id, count(*) qty FROM tableB group by id) tableC WHERE tableA.id = tableC.id (+) but in PostgreSQL I get error message. How can I perform it in Postgres? thanks, robert

[ADMIN] upgrading

2000-08-29 Thread Robert Kernell
Hi. I am new to a job and am overseeing a postgres system. I will probably have to upgrade sometime. Where can I find step-by-step instructions on how to do this? Thanx! Bob Kernell Research Scientist AS&M email: [EMAIL PROTECTED]

[ADMIN] Temporary files directory

2001-01-23 Thread Robert . Farrugia
partition or harddisk under Linux ? Thanks Robert

[ADMIN] Temporary files directory

2001-01-23 Thread Robert . Farrugia
partition or harddisk under Linux ? Thanks Robert

[ADMIN] Kernel panic error

2001-02-15 Thread Robert . Farrugia
error was given when vacuuming one of the smallest tables in the database. Error index_formtuple: data takes 21268 bytes: too big Anyone has any ideas what is happening ? Thanks Robert

[ADMIN] Re: Kernel panic error

2001-02-15 Thread Robert . Farrugia
akes 21268 bytes: too big". If anyone has any ideas on this, please share them. Thanks for the interest Robert

Re: [ADMIN] Postgres/Postmaster logging and log rotation

2001-03-19 Thread Robert Hentosh
Try the copytruncate directive in the logrotate configuration file. (See 'man logrotate'). This should allow it to work without restarting postgresql. But as the man file says, there is a small chance of losing some log entries. On Wed, Mar 07, 2001 at 10:37:30AM -0500, root wrote: > Be sure

[ADMIN] RServ help

2001-04-20 Thread Robert . Farrugia
Hi to all, I have installed the replication program rserv for postgres, but have not managed to make it replicate changes from master to slave. Anyone has any success ? Are there any documentation sites about rserv ? Thanks alot Robert ---(end of broadcast

[ADMIN] Table Names Mappings

2001-05-02 Thread Robert . Farrugia
Hi, As from 7.1, I noticed that the table names have been replaced by numbers in the database directory. Is there a way to map a number to the correct table name ? Thanks Robert ---(end of broadcast)--- TIP 3: if posting/reading through Usenet

Re: [ADMIN] Change auto-commit?

2005-05-11 Thread Robert Treat
n the database. If you building something from scratch, just issue begins at the start of each connection. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: Have you checked our extensive F

[ADMIN] user specific limit for connections

2005-05-17 Thread KÖPFERL Robert
Hi, is there a way to limit the number of connections for certain users. We have a system with some apps connected and partitioned the connections. So each app has a number of granted conns. However it happened that one app ran ammok and took much more connections that int ought to. Thanks in a

[ADMIN] Stripping raid vs. table spaces

2005-06-09 Thread KÖPFERL Robert
Short question: Is it enugh to have stripping on a disk array? Are table spaces then of less use than the actual stripping? So will just stripping give me more O/I-performance? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to

[ADMIN] Periodic bottle-neck in high load app

2005-06-22 Thread KÖPFERL Robert
Hi, we're running a high load applicatoin (Disks are hard working). While the load is rather constant in it's short term behaviour, we are experiencing a bottle-neck in regular intervals. In such case all connections get used up and pgadmin's "server-status"-Window is totally filled with statemen

Re: [ADMIN] Periodic bottle-neck in high load app

2005-06-23 Thread KÖPFERL Robert
|-Original Message- |From: Joshua D. Drake [mailto:[EMAIL PROTECTED] |Sent: Mittwoch, 22. Juni 2005 19:13 |To: KÖPFERL Robert |Cc: pgsql-admin@postgresql.org |Subject: Re: [ADMIN] Periodic bottle-neck in high load app | | | |> SO: Is there some periodic scheduled activity, postgres does |l

[ADMIN] symlinking pg_xlog

2005-06-24 Thread KÖPFERL Robert
Hi, due to I/O-bottle necks I think of making a symlink from pg_xlog to another physical disk. This is a modification inside the cluster dir. What kind of idea is that? bad one? ---(end of broadcast)--- TIP 2: you can get off all lists at once with

Re: [ADMIN] symlinking pg_xlog

2005-06-24 Thread KÖPFERL Robert
Thanks to all of you. I actually read the chapter but I just remembered to not touch pg's own area pg_* So ... I'll go for it |-Original Message- |From: Tom Lane [mailto:[EMAIL PROTECTED] |Sent: Freitag, 24. Juni 2005 15:50 |To: KÖPFERL Robert |Cc: [ADMIN] |Subject:

[ADMIN] Checkpoints - what happens actually?

2005-06-27 Thread KÖPFERL Robert
Hi, i went across a checkpoint problematic (90% load, near real time app). I've read in pg-documentation what exists about CHECKPOINT and the configuration parameters. But there're still many open questions as: What actually happens if a checkpoint occours? OK, all dirty pages of data files get w

[ADMIN] Figuring out the right block size for a stripe set

2005-06-27 Thread KÖPFERL Robert
Hi, I'm lost. Please give me a hint. I'm currently fighting with myself of whether to use 8k blocks (pg's native) or 64k Blocks (more data) as stripe set size. ...of course to get maximum performance. I want to setup a stripe set over 4 disks on a Solaris Sparc box with a stripe block size in que

Re: [ADMIN] How to compare the schemas ?

2005-06-28 Thread KÖPFERL Robert
diff speaks the wrong language to accomplish that, other elementry parts. There exists a program named pgdiff on gborg. On the other hand there's EMS database comparer http://www.sqlmanager.net/ |-Original Message- |From: Milorad Poluga [mailto:[EMAIL PROTECTED] |Sent: Donnerstag, 23. Ju

[ADMIN] Direct I/O versus OS-Caching

2005-06-28 Thread KÖPFERL Robert
Yeah, as the subject quetiones. What's the better/faster alternative? Enabling OS-file system caching or disabling it and forcing direct I/O? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] Checkpoints - what happens actually?

2005-06-30 Thread KÖPFERL Robert
Empric tests have shown that read rrequests seem to still get proceeded whilst write requests get queued until all dirty pages have been written. That's however just testing and looking. What actually happens is a secret. |-Original Message- |From: KÖPFERL Robert |Sent: Monta

Re: [ADMIN] Postrgre Integrated App Development

2005-06-30 Thread KÖPFERL Robert
Actually, I haven't done such thing, yet. However the intended method or a possible way is this: Manage schema-snapshots and put them in VCS Keep a file of changes with version stamps (also in VCS). Document each change to the db (so SQL commands you issue to change its struct). So one can

[ADMIN] Statement logging per connection

2005-07-18 Thread KÖPFERL Robert
Hi, is it possible to enable statement logging just for certain statements? several tries with SET xxx to yyy resulted in messages like xx can't be set now? When can it be set? I intend to use that via an jdbc connection bu had a try in pgAdmin. ---(end of broadcast)--

[ADMIN] Alter Table vs. Rename/Create/Drop table with plpgsql functions.

2005-08-01 Thread Robert Perry
hanks Robert Perry ---(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 datatypes do not match

Re: [ADMIN] Alter Table vs. Rename/Create/Drop table with plpgsql functions.

2005-08-01 Thread Robert Perry
still come back to it. Thanks Robert Perry On Aug 1, 2005, at 12:48 PM, Mark R. Dingee wrote: Robert, If you have the luxury of taking the production db offline for a few minutes or if you're just making changes in a test environment, this process works: given: create table test

Re: [ADMIN] Alter Table vs. Rename/Create/Drop table with plpgsql functions.

2005-08-01 Thread Robert Perry
Not that happiest of news, but very helpful to actually know it. Thanks On Aug 1, 2005, at 1:12 PM, Jaime Casanova wrote: Secondly does anyone know a way to insert a column instead of appending a column to a table. That way I could just avoid the entire mess. http://archives.pos

[ADMIN] Blocking connection and timeout problem

2005-08-03 Thread KÖPFERL Robert
Hi, I managed to reproduce a locking problem, which is about blocking transactions and dead connections. How can this be avoided? What I did was: 1. Start a transaction on Client A 2. Execute a fcn doing an UPDATE on a certain record on client A 3. Execute a fcn doing an UPDATE on the same record

Re: [ADMIN] Blocking connection and timeout problem

2005-08-03 Thread KÖPFERL Robert
|-Original Message- |From: Tom Lane [mailto:[EMAIL PROTECTED] |Sent: Mittwoch, 03. August 2005 16:38 |To: KÖPFERL Robert |Cc: pgsql-admin@postgresql.org |Subject: Re: [ADMIN] Blocking connection and timeout problem | | |=?iso-8859-1?Q?K=D6PFERL_Robert?= <[EMAIL PROTECTED]>

Re: [ADMIN] hot backup

2005-08-05 Thread KÖPFERL Robert
yes, either by snapshot (Os-feature) or pg_dump -Original Message-From: Steulet Grégory [mailto:[EMAIL PROTECTED]Sent: Mittwoch, 03. August 2005 10:47To: pgsql-admin@postgresql.orgSubject: [ADMIN] hot backup Hi,   I just would like to know if it's possible to dot ho

Re: [ADMIN] Blocking connection and timeout problem

2005-08-05 Thread KÖPFERL Robert
|From: Dario Brignardello [mailto:[EMAIL PROTECTED] |Sent: Mittwoch, 03. August 2005 19:33 |To: KÖPFERL Robert |Cc: pgsql-admin@postgresql.org |Subject: Re: [ADMIN] Blocking connection and timeout problem | | |Assuming you are on a linux box (Not sure if it's stated in your mail, |sorry if I

[ADMIN] Duplicate Key -- Have I missed something

2005-08-06 Thread Robert Perry
    I have a production environment that is running the code that caused this problem about once every 30 seconds or so, with two clients.  It normally runs very well, but I was suddenly hit with a duplicate key violation for a table where the primary key is generated in part from sequence.    How

Re: [ADMIN] Duplicate Key -- Have I missed something

2005-08-06 Thread Robert Perry
new table, but it is just one of those panic things I guess. Making a longs story short. Yes, the problem is existing data and not that new data. Thanks Robert Perry On Aug 6, 2005, at 10:47 PM, Michael Fuhr wrote: On Sat, Aug 06, 2005 at 10:00:10PM -0400, Robert Perry wrote: I h

Re: [ADMIN] VACUMM problem

2005-09-03 Thread Robert Treat
lp you with specifics on most of these items. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Stupid question about triggers

2005-09-10 Thread Robert Treat
chema based on this email. Just my .02. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(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 datatypes do not match

[ADMIN] postgresql cluster on SAN

2005-09-20 Thread Robert Ngo
Hi, Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially have terabytes of data. I am thinking about a solution where a cluster of database server will share

Re: [ADMIN] postgresql cluster on SAN

2005-09-20 Thread Robert Ngo
Robert Ngo wrote: Chris Browne wrote: [EMAIL PROTECTED] (Robert Ngo) writes: Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially have terabytes of

Re: [ADMIN] Disk Access Question

2005-09-21 Thread Robert Treat
of accessing is > PostgreSQL doing to my drives so we can try and resolve some i/o issues. > AFAIK unless your actually doing something,it wont access your data files at all. Note that something is pretty wide here, insert/update/vacuum/analyze and even select will cause file access bu

[ADMIN] postgresql cluster on SAN

2005-09-22 Thread Robert Ngo
Hi, Can i create create a cluster of postgresql server by sharing the database file on a SAN? I am also looking into slony but slony replicate data to each server and my database will potentially have terabytes of data. I am thinking about a solution where a cluster of database server will sh

Re: [ADMIN] Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ?

2005-09-23 Thread Robert Treat
gh -Fc options along with an SQL file > created using "pgdump_all -g " sufficient to recreate > the entire database ? > Assuming your version of pg_dump dumps binary data with an -Fc dump, then yes. (Check the docs if you want to verify) -- Robert

Re: [ADMIN] postgresql cluster on SAN

2005-09-26 Thread Robert Ngo
How about i have one SAN storage for the slony master node and another SAN to be share by slave nodes that only do SELECT? Can Dell|EMC AX100i iscsi san with sata drive serve as storage for postgresql server, will there be problem in I/O performance? Chris Travers wrote: Spiegelberg, Greg wr

Re: [ADMIN] Preventing database access (including valid users in

2005-09-27 Thread Robert Treat
owned by someone who will never be allowed to connect to that database. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[ADMIN] backup software for postgresql

2005-10-02 Thread Robert Ngo
Hi,   Which backup software out there work well with postgresql, I cannot find one with backup agent for postgres.   I am looking for a backup solution that will backup the postgres database from a fiber channel san to a fiber channel tape library, any one here have experience with simi

[ADMIN] postgresql on SAN

2005-10-02 Thread Robert Ngo
Hi,   I am looking at using the iscsi version of Dell|EMC AX100i as the SAN storage for my network, this solution is using 7200rpm sata, Is this SAN suitable to be use as storage space for postgresql. Any one here have experience in setting up iscsi SAN for postgresql database?    

Re: [ADMIN] how do you automate database backups?

2005-11-02 Thread Robert Treat
n, in winders I believe you can use 'task scheduler'. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [ADMIN] Starten Server / SCO OpenServer6 / PostgreSQL 8.0.3

2005-11-02 Thread Robert Treat
nerally it's nothing to be concerned about, but you can google the relevant keywords if you want to learn more. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: Have you

Re: [ADMIN] Vacuum Verbose output

2005-11-02 Thread Robert Treat
e granular also). Duh.. I forgot the workaround here.. TABLESPACES are finally available in PostgreSQL 8. But semaphore problems are still existing and pre-growing files will still help a lot since "growing" the files will be in your "1" process connection timeline. " take

Re: [ADMIN] [DOCS] technical papers

2006-01-07 Thread Robert Treat
some other keywords mentioned in the history (; http://www.postgresql.org/about/history). those should bring back some relevant ideas though the code is probably written from that time. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL --

Re: [ADMIN] Any tools to compare db's

2006-01-11 Thread Robert Treat
e the schema between two databases. As I recall, if you have different schema it just blows up. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 7: don't forget to increase yo

[ADMIN] Need query parameter in logs

2006-02-09 Thread Robert Perry
, $2, $3, $4 ) How can I find out what $1, $2, $3, $4 are short of recompiling the C ++ client code? Thanks Robert Perry ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[ADMIN] Starting in a Windows administrative account

2006-03-20 Thread Davidson, Robert
unable to access the production database (this will not be configured to allow any network users to access postgres). Many thanks, Robert Davidson

Re: [ADMIN] Starting in a Windows administrative account

2006-03-20 Thread Davidson, Robert
look for this or is it more of a "no wine before its time - so don't whine!" situation? Thanks, Robert -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 10:23 AM To: Davidson, Robert; pgsql-admin@postgresql.org Subject: RE: [

Re: [ADMIN] COPY FROM command v8.1.4

2006-09-18 Thread Robert Reeves
Hi, Any update on this ? --robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mr. Dan Sent: Thursday, 14 September 2006 11:14 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] COPY FROM command v8.1.4 Hi Ray, I've tried "it" on

Re: [ADMIN] Finding out free space?

2006-11-14 Thread Robert Treat
is still available on the filing system. > > > > 2. How much space is unused within the data files themselves? > > > > I'd appreciate a pointer on where I should look for this sort of > > information. > > > > > > Regards, > > > > Hans Guijt > &

Re: [ADMIN] Oracle takes the wraps off SME database

2003-10-10 Thread Robert Treat
his news? > http://theregister.co.uk/content/53/33299.html Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Access with a management tool

2003-10-24 Thread Robert Treat
if it's a pg_hba issue, he should get a FATAL "authentication failed"-ish message. I'd check for tcpip_socket=true in postgresql.conf first. Robert Treat On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote: > edit your pg_hba.conf > > regards, > Oli > > -

Re: [ADMIN] Point-in-time data recovery - v.7.4

2003-11-18 Thread Robert Treat
help code PITR please send a message to hackers. Robert Treat On Tue, 2003-11-18 at 09:01, Rafael Martinez Guerrero wrote: > Hello > > I am trying to find out when 'Point-in-time data recovery' functionality > will be available with postgreSQL but I can not find conc

Re: [ADMIN] Point-in-time data recovery - v.7.4

2003-11-19 Thread Robert Treat
rself) Robert Treat On Wed, 2003-11-19 at 02:35, Stef wrote: > Hi all, > > Just another question on all this : > When will postgres have win32 native > support. I've been gathering information > from bits and pieces I found on the net, > but never got an official answer

Re: [ADMIN] Backup/Recovery (BR) question

2003-11-20 Thread Robert Treat
uoting the database name properly. Note the name of the database is DB1 (uppercase) but the error message is talking about db1 (lowercase) If you do // drop database "DB1" // the first database will drop, though you might want to verify if it is really damaged.

Re: [ADMIN] Backup/Recovery (BR) question

2003-11-21 Thread Robert Treat
On Thursday 20 November 2003 18:00, Oli Sennhauser wrote: > Hello Robert > > >If you do // drop database "DB1" // the first database will drop, > >though you might want to verify if it is really damaged. > > Oh sh! It worked. Thanks. I am used to do t

Re: [ADMIN] Cannot read back pg_dump from 7.2 into 7.4

2003-11-24 Thread Robert Treat
A few thoughts: what command are you using to produce the 7.2 dump? what is the exact version of the 7.2 server? Try and see if you can get a good dump using the 7.4 pg_dump against the 7.2 database. Robert Treat On Monday 24 November 2003 08:43, Gerwin Philippo wrote: > Oops, last mess

Re: [ADMIN] Auto commit Off how will it effect us ?

2003-12-08 Thread Robert Treat
for folks to do a test installation and test there apps out just to be on the safe side. Robert Treat On Sun, 2003-12-07 at 03:54, Sai Hertz And Control Systems wrote: > Dear all , > > Permit me to gain some of your most valuable knowledge ... > > Our intrAnet server ha

Re: [ADMIN] Auto commit Off how will it effect us ?

2003-12-09 Thread Robert Treat
On Tuesday 09 December 2003 03:43, Sai Hertz And Control Systems wrote: > Dear Robert Treat , > > First of all accept gratitude for answering the question > > >phppgadmin=# set autocommit = off; > >ERROR: SET AUTOCOMMIT TO OFF is no longer supported > >phppgadmin

Re: [ADMIN] Postgresql on software RAID

2003-12-16 Thread Robert Creager
When grilled further on (Tue, 16 Dec 2003 22:30:04 -0600), Patrick Spinler <[EMAIL PROTECTED]> confessed: > > According to the theory they expound, a database with any significant > write activity whatsoever should never be on raid 5, but instead be on > raid 0+1. > Kind of related and a poin

Re: [ADMIN] Postgresql on software RAID

2003-12-17 Thread Robert Creager
When grilled further on (Wed, 17 Dec 2003 08:45:43 -0700 (MST)), "scott.marlowe" <[EMAIL PROTECTED]> confessed: > > Just wondering, was that on hardware or software RAID5, and if hardware > did it have battery backed cache controllers? Makes a huge difference. I > would never use SW RAID5 for

Re: [ADMIN] Migration from M$ SQL

2004-01-05 Thread Robert Treat
I'd be very surprised if there were. AFAIK the syntax between m$ and postgresql pl's isn't terribly compatible, and I think there are quirks in how the two implementations actually work, so you'll want to test this as well. Robert Treat -- Build A Brighter L

Re: [ADMIN] [SQL] Database diagram

2004-01-26 Thread Robert Creager
When grilled further on (Mon, 26 Jan 2004 18:02:59 +0700), "Chris Travers" <[EMAIL PROTECTED]> confessed: > I have been having trouble with it crashing (segfault) which is surprising > since it is written in Perl (must be a bum CPAN module, but I will have to > wait to figure out which one). Just

Re: [ADMIN] Selects query inside function must read commited data

2004-01-26 Thread Robert Treat
vince the core developers to change this behavior. Robert Treat On Sun, 2004-01-25 at 13:09, Andrew Biagioni wrote: > In the v7.3 docs: > > http://www.postgresql.org/docs/7.3/interactive/transaction-iso.html#XACT > -READ-COMMITTED > <http://www.postgresql.org/docs/7.3/interacti

Re: [ADMIN] Can't connect to phppgadmin

2004-01-26 Thread Robert Treat
(follow-ups should go to pgsql-php which is at least slightly on topic) You need to either find an rpm for suse that gives postgresql support to php (on red-hat systems the rpm is php-pgsql iirc), or recompile your php from source with postgresql support. Robert Treat On Sun, 2004-01-25 at

Re: [ADMIN] [SQL] Database diagram

2004-01-26 Thread Robert Creager
Hey Chris, I just installed version 1.22 from cpan and it fixed the problem. From a CPAN prompt (if you use it) . Cheers, Rob When grilled further on (Mon, 26 Jan 2004 20:17:57 +0700), "Chris Travers" <[EMAIL PROTECTED]> confessed: > I am using DBD::Pg 1.31. That may be the problem. Any su

Re: [ADMIN] reduce downtime when upgrading 7.3 -> 7.4

2004-02-10 Thread Robert Treat
is the only process running, let it take up most of the ram on the box) and you can increase check_point segments as well. HTH Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you ca

[ADMIN] Log query results?

2004-02-10 Thread Robert Creager
Hey All, I'm running 7.4.1 and am having problem when my app starts loading up on the database. I want to verify the data coming back from the queries is correct from the server side (not application side), as then I'll be sure my app is squirrelly (or the db is). I don't see any options in pos

Re: [ADMIN] Log query results?

2004-02-11 Thread Robert Creager
When grilled further on (Wed, 11 Feb 2004 01:03:50 -0500), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > Nothing on the backend side that I can think of. If you're using libpq > then you could use PQtrace, though that&#x

Re: [ADMIN] Upgrading 7.2.4 to 7.4.1

2004-02-21 Thread Robert Treat
You might get better results using 7.4's pg_dump against the 7.2 database... worth a try anyway. Robert Treat On Monday 16 February 2004 07:59, Jarmo Järvenpää wrote: > Dear all, > > I've got an old 7.2.4 DB which I hoped to upgrade to 7.4.1. > The old syntax used for cre

Re: [ADMIN] Panic involving a LC_COLLATE issue

2004-02-21 Thread Robert Treat
rly ciritcal bug in 7.3.3 that can cause server start up failure. It's a corner case, but still a pretty serious one. You should talk to your webhost about getting on 7.3.5 asap. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(e

Re: [ADMIN] PL/pgSQL instalLation problem ??

2004-02-21 Thread Robert Treat
ot; at character 1 > > Did I miss something ? > createlang needs to be run from the shell, not from inside the database, Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: the planner w

Re: [ADMIN] License for PostgreSQL for commercial purpose

2004-03-29 Thread Robert Treat
ct, as again, they could easily contact this project for a letter of clarification if their goal was to protect themselves legally. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(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: [ADMIN] Problem

2004-04-06 Thread Robert Treat
on requires (generally) that your system user be the same as your database user. Since it sounds like this is not what you want, you need to modify your pg_hba.conf file and change the settings as appropriate. (See comments in the file or docs for specifics on the different options) Robe

Re: [ADMIN] Location of a new column

2004-04-12 Thread Robert Treat
t all you can do to put it somewhere else is a sequence with a new > table, copying data and renaming (and fixing constraints). > IIRC this option is available in 7.5. At least I seem to remember some (Chris K-L) posting a patch and it getting committed. You could check t

Re: [ADMIN] Maximum Number Tables

2004-04-15 Thread Robert Treat
whats stored in the tables and how you plan on using them that makes the difference. And even then it's dependent on your hardware more than PostgreSQL itself. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--

Re: [ADMIN] Postgresql Backup & Dump

2004-04-15 Thread Robert Treat
lternatively try dumping using insert commands as this tends to be a little more robust when dealing with problem dumps (though it will be slower) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--

Re: [ADMIN] Tool to compare db schemas?

2004-05-05 Thread Robert Treat
resql.org/project/pgdiff/projdisplay.php If you run across any others please lmk, I think I'm going to need this for a project in the next few days. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)-

Re: [ADMIN] To instal phpPgAdmin

2004-05-20 Thread Robert Treat
On Thu, 2004-05-20 at 00:44, darshan patel wrote: > > I had instal postgresql on suse Linux,now i want to Instal phpPgAdmin so > what is the procedure Go to http://phppgadmin.sourceforge.net/?page=download unpack the source code and read the INSTALL file. Robert Treat -- Build A

Re: [ADMIN] pg_hba.conf

2004-05-21 Thread Robert Treat
the existing entries to include the machine your connecting from) HTH Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 8: explain analyze is your friend

  1   2   3   4   5   >