[GENERAL] Movable Type 5 and Postgres
I've posted a short guide on how to get Movable Type 5, Postgres 9, and Tomcat 7.0 working together. http://www.greenskagitvalley.com/blog/movable-type-5-with-tomcat-70x-and-postgres-90.html -M@ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] anyone have Movable Type 5 working with Postgres?
Even though Movable Type 5 has dropped official support for Postgres it still comes with the drivers in order for it to work. I've gotten it setup and working with Postgres, but there is one problem that keeps me from being able to use it. That issue I've explained over on the MT forums: http://forums.movabletype.org/2010/10/cant-use-string-as-an-array-ref-while-strict-refs-in-use.html Is anyone here running Postgres 9.0 and MT5 together? Thanks, -M@ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] anyone have Movable Type 5 working with Postgres?
I've seen mention that it might be possible for MT5 to re-gain Postgres support (they dropped it in version 5) through the use of plugins. Does anyone know of such a thing and/or have an installation working themselves? Would greatly appreciate any info you can share. Thanks, -M@ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] running Apple Mail on Postgres?
This may be a tad off topic, but thought a PG enthusiast might have some insight on this. Apple Mail sits on top of Sqlite. I was wondering if it would be possible to substitute Postgres as the underlying database. I do know how to vacuum Sqlite to speed up Mail, but with the massive amount of email I have I was wondering if Postgres could more easily handle the workload. Thanks, -M@ ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] settings for 8.2.5 on Mac OS X 10.4.11
What are good settings for shared_buffers and max_connections with the above software combo? Out of the box I'm getting the Cannot allocate memory message upon doing a 'make check'. Thanks, -M@ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] change format of logging statements?
With 8.2.4 is it possible to get Postgres to log incoming SQL
statements the same as they look when written? Instead of:
DEBUG: insert into foo (name) values ($1);
DETAIL: parameters: $1 = 'stan'
I'd like to see:
DEBUG: insert into foo (name) values ('stan');
This would be extremely helpful when debugging complex Hibernate
generated queries. I could just copypaste the query into a psql
session and begin playing with it.
Thanks,
-M@
---(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
[GENERAL] Adjacency Lists vs Nested Sets
Does Postgres have any native support for hierarchical data storage? I'm familiar with the Adjacency List technique, but am trying to determine whether or not Nested Sets would make sense for our application or not. I understand that Nested Sets might be better for high read applications, but write heavy applications suffer from poor performance. Any thoughts on the topic? -M@ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] varchar as primary key
I'm investigating the usage of a UUID primary key generator using Hibernate and Postgres. The reason for using a UUID is that we will have an application hosted at different sites in different databases. We will need to aggregate the data back into a single database from time to time and we want to avoid PK collisions. Is there a significant performance difference between using int primary keys and string primary keys in Postgres? Thanks, -M@ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] using Postgres with Sequoia
I am investigating data replication and failover ideas for a Java web application. I would like the ability to have 2 or more Postgres databases that are kept in synch, with the ability to loose all but 1 database and have the application still function. It seems that Sequoia would work nicely for this. Was wondering if anyone here has had difficulties using Sequoia and Postgres together. Would also love to hear success stories about this strategy. Thanks, -M@ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] change format of logging statements?
Postgres 8.2.0 is logging statements with variables like $1, $2, etc. and then on the next line saying: DETAIL: parameters: $1 = '100', $2 = '100', $3 = '1003' Is it possible to get statements logged with the parameters placed into the actual query statement so that its more convenient to copy and paste them into psql while debugging? The reason for this is that Hibernate is creating the queries and I'd like to see exactly what those queries are returning. Thanks, -M@ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] EnterpriseDB
http://www.enterprisedb.com/news_events/press_releases/04_24_06.do Was wondering if anyone had used that to import an Oracle .dmp file and then export a Postgres 8.1 dump file for import into a regular PostgreSQL database. -M@ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] EnterpriseDB
Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1 database. -M@ On May 5, 2006, at 4:56 PM, Terry Fielder wrote: By regular PostgreSQL do you mean a PostgreSQL 7.x install? Terry Fielder [EMAIL PROTECTED] Associate Director Software Development and Deployment Great Gulf Homes / Ashton Woods Homes Fax: (416) 441-9085 Matthew Hixson wrote: http://www.enterprisedb.com/news_events/press_releases/04_24_06.do Was wondering if anyone had used that to import an Oracle .dmp file and then export a Postgres 8.1 dump file for import into a regular PostgreSQL database. -M@ ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] returning a cursor from a function?
I have a create function statement that works with Oracle 8i and I'm trying to create this function in Postgres 8.1.2. CREATE OR REPLACE FUNCTION pr_user( p0 CHAR ) RETURN Types.cursor_type IS rs Types.cursor_type; BEGIN OPEN rs FOR SELECT us.approval_type_code AS us_approval_type_code FROM wbs_users us WHERE upper( us.username ) = upper( p0 ); return rs; END; Could someone lend me a hand here? Thanks in advance, -M@ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] returning a cursor from a function?
Thanks, Michael. Don't know how I missed those. -M@ On Jan 31, 2006, at 10:55 PM, Michael Fuhr wrote: On Tue, Jan 31, 2006 at 10:37:47PM -0800, Matthew Hixson wrote: I have a create function statement that works with Oracle 8i and I'm trying to create this function in Postgres 8.1.2. See the PL/pgSQL documentation, in particular the section on cursors, which has several examples. You might also be interested in the Porting from Oracle PL/SQL section. http://www.postgresql.org/docs/8.1/interactive/plpgsql.html http://www.postgresql.org/docs/8.1/interactive/plpgsql-cursors.html http://www.postgresql.org/docs/8.1/interactive/plpgsql-porting.html -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] Postgres 8.1.2, Java, JDO, and case sensitivity woes
I'm trying to get a large Java application which makes use of an Oracle JDO layer to work with Postgres. Set aside for a moment the discussion of whether or not that is going to work. What I have found is that different parts of this application are referring to a table in all uppercase and in other parts referring to the table all in lowercase. Is there a way to configure Postgres so that it does not treat FOO and foo as two different tables? Thanks, -M@ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Postgres 8.1.2, Java, JDO, and case sensitivity woes
The problem is that the JDO layer is looking for the table name in a system table like so: SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attl en,a.attnum,def.adsrc,dsc.description FROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid) LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname='pg_catalog') WHERE a.attnum 0 AND NOT a.attisdropped AND c.relname LIKE 'FOO' AND a.attname LIKE '%' ORDER BY nspname,relname,attnum That query returns nothing. Changing FOO to foo returns the 4 rows that the JDO layer is looking for. So, on second thought its not a problem with case insensitive table names, its a problem with the JDO layer looking for uppercase table names listed in the system tables even though Postgres table names are lowercase by default. Completely different problems. I renamed table foo to FOO, which makes the above query return correctly, and now I see this in the log, later in the initialization: LOG: statement: PREPARE unnamed AS SELECT ns.helper AS ns_helper, ns.name AS ns_name, ns.foo_id AS ns_foo_id, ns.title AS ns_title FROM foo ns ERROR: relation foo does not exist So, it would seem that table names are case insensitive in select statements, but case sensitive in prepare statements. Can someone confirm or refute that? -M@ On Jan 27, 2006, at 3:59 PM, Roger Hand wrote: testdb=# CREATE TABLE foo (field_one int4); CREATE TABLE testdb=# INSERT INTO foo VALUES (1); INSERT 0 1 testdb=# INSERT INTO foo VALUES (2); INSERT 0 1 testdb=# SELECT * FROM foo; field_one --- 1 2 (2 rows) testdb=# SELECT * FROM FOO; field_one --- 1 2 (2 rows) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Hixson Sent: Friday, January 27, 2006 3:53 PM To: Postgres General Subject: [GENERAL] Postgres 8.1.2, Java, JDO, and case sensitivity woes I'm trying to get a large Java application which makes use of an Oracle JDO layer to work with Postgres. Set aside for a moment the discussion of whether or not that is going to work. What I have found is that different parts of this application are referring to a table in all uppercase and in other parts referring to the table all in lowercase. Is there a way to configure Postgres so that it does not treat FOO and foo as two different tables? Thanks, -M@ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Postgres 8.1.2, Java, JDO, and case sensitivity woes
On Jan 27, 2006, at 4:10 PM, Thomas Kellerer wrote: Matthew Hixson wrote on 28.01.2006 00:53: I'm trying to get a large Java application which makes use of an Oracle JDO layer to work with Postgres. Set aside for a moment the discussion of whether or not that is going to work. What I have found is that different parts of this application are referring to a table in all uppercase and in other parts referring to the table all in lowercase. Is there a way to configure Postgres so that it does not treat FOO and foo as two different tables? Simply don't use quotes, never. Then case will not matter. These queries are being put together by the JDO layer. -M@ ---(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
[GENERAL] importing an Oracle database into Postgres
What's the best way to import an Oracle database into Postgres? I'm using Oracle 8.1 and Postgres 8.1.1. Thanks, -M@ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] importing an Oracle database into Postgres
Thanks, Jim. I've been playing with OraToPG. So far I've found a couple small problems with it that I'll probably solve with some simple Perl, but overall its a very handy tool. I'll try to post a success story when I get this all straightened out. Cheers, -M@ On Dec 28, 2005, at 12:38 PM, Jim C. Nasby wrote: http://archives.postgresql.org/pgsql-advocacy/2005-10/msg00311.php or contrib/oracle are probably your best bet. On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote: What's the best way to import an Oracle database into Postgres? I'm using Oracle 8.1 and Postgres 8.1.1. Thanks, -M@ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] GCC 4.0 on Mac OS X
Just wondering if the Postgres hackers have done any performance measurements on Postgres compiled with GCC 3.x against Postgres compiled with GCC 4.0. I'm wondering whether or not the auto- vectorization stuff in 4.0 provides any performance improvements to Postgres 8.0.x. -M@ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] GCC 4.0 on Mac OS X
On May 20, 2005, at 3:00 PM, Tom Lane wrote: Matthew Hixson [EMAIL PROTECTED] writes: Just wondering if the Postgres hackers have done any performance measurements on Postgres compiled with GCC 3.x against Postgres compiled with GCC 4.0. I'm wondering whether or not the auto- vectorization stuff in 4.0 provides any performance improvements to Postgres 8.0.x. Offhand I'd not expect auto-vectorization to be much help for Postgres, but you never know till you try ... While cruising the vast and global interweb I found myself here http://gnu.ghks.de/software/gcc/projects/tree-ssa/vectorization.html and while that's a bit over my head I gathered that GCC 4.0 would provide more better performance. -M@ ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4
On May 19, 2005, at 5:42 AM, John DeSoi wrote: On May 19, 2005, at 1:34 AM, Matthew Hixson wrote: /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) After upgrading to 10.4.1 and using Michael's parameters to ./ configure I still get the exact same build error. Any Postgres hackers out there interested in logging into my machine and seeing what they can do to fix this? [Wild stabs in the dark to follow] What kind of Mac is it? The error had something to do with cputype. When I installed XCode 2.0 yesterday I noticed it installs gcc 3 and 4. Maybe you could try using gcc 3 and see if it makes a difference. My machine is a 1Ghz G4 Powerbook. This machine was upgraded from 10.3.9 to 10.4 and then brought up to 10.4.1 through software update. I have Xcode 1.1 installed and my gcc is: [EMAIL PROTECTED]:~/$ gcc -v Reading specs from /usr/libexec/gcc/darwin/ppc/3.3/specs Thread model: posix gcc version 3.3 20030304 (Apple Computer, Inc. build 1495) So perhaps I should just upgrade XCode and that'll fix my problem. -M@ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4
On May 19, 2005, at 9:27 AM, Jeff Trout wrote: On May 18, 2005, at 9:27 PM, Matthew Hixson wrote: /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) I had some issues with this error on a few other things on my Tiger box. After I installed Xcode2 things worked fine. Try installing xcode2 and let us know. (And I compiled and run Tiger on my tiger machine here, with xcode2, gcc 4) I just installed Xcode 2 and postgres built successfully. A 'make check' also says all 96 tests passed. Thanks for the help everyone. Keep up the good work. -M@ ---(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] 8.0.3 build error on Mac OS X 10.4
I also thought I saw quite a few more warnings this time than in the past. -M@ On May 19, 2005, at 11:05 AM, Jerry LeVan wrote: For what it is worth... I have 10.4.1 (Tiger) (archived and ) installed on my old 933MHZ QuickSiver. I also have Xcode 2.0 installed. When I compiled 8.0.3 it seemed to generated many more warnings with 4.0 gcc than the older 3.3 gcc. At least that is my recollection... I have installed the rascal and it appears to be working... Jerry ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] 8.0.3 build error on Mac OS X 10.4
8.0.3 does not build for me on Mac OS X 10.4. Anyone else seeing this error, and will it be fixed in the next release? Thanks, -M@ gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith - Wendif-labels -fno-strict-aliasing -DFRONTEND -I. -I../../../src/ include -I../../../src/port -c -o thread.o thread.c ar crs libpq.a `lorder fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe- print.o fe-lobj.o fe-protocol2.o fe-protocol3.o pqexpbuffer.o pqsignal.o fe-secure.o md5.o ip.o wchar.o encnames.o noblock.o pgstrcasecmp.o thread.o | tsort` usage: join [-a fileno | -v fileno ] [-e string] [-1 field] [-2 field] [-o list] [-t char] file1 file2 ranlib libpq.a gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith - Wendif-labels -fno-strict-aliasing -dynamiclib -install_name /usr/ local/pgsql/lib/libpq.4.dylib -compatibility_version 4 - current_version 4.0 -multiply_defined suppress fe-auth.o fe- connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o fe-protocol2.o fe- protocol3.o pqexpbuffer.o pqsignal.o fe-secure.o md5.o ip.o wchar.o encnames.o noblock.o pgstrcasecmp.o thread.o -L../../../src/port - lresolv -o libpq.4.0.dylib /usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0) file: -lSystem is not an object file (not allowed in a library) make[3]: *** [libpq.4.0.dylib] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all] Error 2 make: *** [all] Error 2 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] 8.0.3 build error on Mac OS X 10.4
On May 18, 2005, at 8:21 PM, Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On May 19, 2005, at 10:27 AM, Matthew Hixson wrote: 8.0.3 does not build for me on Mac OS X 10.4. Anyone else seeing this error, and will it be fixed in the next release? I just built 8.0.3 on Mac OS X 10.4.1 just fine. IIRC this isn't the first report of build problems on 10.4, and not the first report of success either. Somebody needs to look into exactly what's going on. (Don't look at me, I have not bought 10.4 yet...) After upgrading to 10.4.1 and using Michael's parameters to ./ configure I still get the exact same build error. Any Postgres hackers out there interested in logging into my machine and seeing what they can do to fix this? -M@ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] renaming sequences
I had a bunch of tables that had v_ prepended to their names. I've renamed all of the tables so that they don't have that prefix anymore so that v_address is now addresses. The name of this table's sequence is still v_addresses_address_id_seq. This is fine except for the fact that I'm using JBoss and it assumes that the table's sequence is addresses_address_id_seq. (Why it needs to read the sequence I have no idea.) So now, every time I try to save an object JBoss is executing sql that is trying to read from a non-existent sequence. Can I rename my sequences and change the tables to point to the new sequence names or do I have to do something like: 1) Rename addresses to addresses_temp 2) Create addresses from scratch so that Postgres creates a sequence named addresses_address_id_seq 3) Select all of the data from addresses_temp into addresses. Thanks, -M@ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] self referencing table structure and constraints
I have a categories table that contains a FK to another category in the same table, creating a hierarchy. At the very top is this row: category_id | name | description | parent_id -+--+-+--- 1 | ROOT | The top level category. | 0 There is no record with category_id 0 because ROOT is at the top of the tree. I'd like to set up a constraint on this table so that every category has to have a parent_id and it would be impossible to delete a category if it had subcategories. The problem is that this root category violates that constraint. Is there a way to setup the constraint so that it constrains every record except for forcing the root category to point at a real parent category? I thought of pointing ROOT to itself, but since we have some recursive code that starts at a given category id and moves up the tree it will hit the ROOT category and loop forever. I'd like to fix this by constraining the database so that even working from psql it would be difficult to damage this table by hand. Are there any widely used techniques for dealing with this type of constraint? Thanks, -M@ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] self referencing table structure and constraints
On Sep 23, 2004, at 6:36 PM, Stephan Szabo wrote: On Thu, 23 Sep 2004, Matthew Hixson wrote: I have a categories table that contains a FK to another category in the same table, creating a hierarchy. At the very top is this row: category_id | name | description | parent_id -+--+-+--- 1 | ROOT | The top level category. | 0 There is no record with category_id 0 because ROOT is at the top of the tree. I'd like to set up a constraint on this table so that every category has to have a parent_id and it would be impossible to delete a category if it had subcategories. The problem is that this root category violates that constraint. Is there a way to setup the constraint so that it constrains every record except for forcing the root category to point at a real parent category? Well, to simply have the root category not error, you could use NULL for the parent_id if you're using a foreign key. Okay, now I just feel silly. For some reason I was thinking that the parent id couldn't be NULL either. Thanks, this is exactly what I needed. -M@ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] data modeler
I'm looking for a data modeler that can look at an existing database schema and generate an ERD. A PDF of it would be nice. I'm using OS X, but a Linux or Windows tool would be acceptable too. I don't need any other features than that right now. Just want to generate something that new developers can look at to more easily become familiar with the schema. Thanks, -M@ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] data modeler
On Sep 23, 2004, at 7:19 PM, Alvaro Herrera wrote: On Thu, Sep 23, 2004 at 07:02:26PM -0700, Matthew Hixson wrote: I'm looking for a data modeler that can look at an existing database schema and generate an ERD. A PDF of it would be nice. I'm using OS X, but a Linux or Windows tool would be acceptable too. I don't need any other features than that right now. Just want to generate something that new developers can look at to more easily become familiar with the schema. Look for autodoc (or postgresql_autodoc) on http://pgfoundry.org. Or maybe at http://www.rbt.ca IMHO the GraphViz output is the most useful. I found this: http://pgfoundry.org/projects/autodoc/ Is the only way to get this software through CVS? Thanks, -M@ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] using Postgres to store many small files
I am currently working on a Java web application. We are making use of the JDBC driver for Postgres 7.4.1. Part of our application allows the administrators to manage a large number of small images, most of them not exceeding 5KB. There is about a gigabyte of these small files. We're currently storing the files on disk and the other information about the file in the database (historical reasons that I won't complain about here). I recently discovered the Hibernate project and was pleasantly surprised how simple it was to store an image in Postgres as a bytea using Hibernate's BLOB support. I'm wondering if Postgres would have any problem handling all of our files if we were to put them into Postgres as bytea data. And how well would Postgres scale as the number of files increased? Our Java application and Postgres are currently running on the same machine, a dual Xeon 2.6Ghz with 1GB of RAM. We are currently not working this machine very hard at all. Thanks, -M@ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] using Postgres to store many small files
I am currently working on a Java web application in which we are making use of the JDBC driver for Postgres 7.4.1. Part of our application allows the administrators to manage a large number of small images, most of them not exceeding 5KB. There is about a gigabyte of these small files. We're currently storing the files on disk and the other information about the file in the database (historical reasons that I won't complain about here). I recently discovered the Hibernate project and was pleasantly surprised how simple it was to store an image in Postgres as a bytea using Hibernate's BLOB support. I'm wondering if Postgres would have any problem handling all of our files if we were to put them into Postgres as bytea data. And how well would Postgres scale as the number of files increased? Our Java application and Postgres are currently running on the same machine, a dual Xeon 2.6Ghz with 1GB of RAM. We are currently not working this machine very hard at all. Thanks, -M@ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL]
On Wed, 25 Apr 2001, Ashley T. Howes wrote: I was wondering if PostgreSQL takes advantage of multiple CPUs when placed in a single Linux box. Or are multiple CPUs utilised as long as the Linux kernel is compiled to take advantage of them? If you compile an SMP kernel Linux will balance processes and threads evenly across the CPUs. One client hitting the database may not see a huge advantage of a multi-processor machine, but the Linux box is also running other processes than the postmaster, even if its the kernel itself. Of course, if two clients hit the box at the same time then each postgres backend process could execute on a different CPU. For a heavily loaded machine I think you would see a measurable difference in using an multi-proc box. -M@ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Client/Server Security question
Hi Lonnie, This is one of the reasons we are moving to an EJB server at work (we're using Oracle there, but they wanted to accomplish the same thing you want to do with Postgres). By exposing specialized interfaces to the db we effectively limit the types of queries that can be run. That might be more overhead than you want to deal with in your application, but for us it makes sense because we have so many different types of applications hitting the db (servlets and JSP pages, Swing applications, perl scripts, C programs, etc...) -M@ -- There are more things in heaven and earth, Horatio, than are dreamt of in your philosophy. On Fri, 20 Apr 2001, Lonnie Cumberland wrote: Hello All, We are developing an application that will allow our websites to talk to our database. In the interest of security, I am wondering if it is possible to turn off some of the functions in the SQL command list such that a user can only communicate to the database through our functions. What I mean is this. We have built a number of "C" extensions and PL/pgSQL proceedures that will work on our database, but I only want to allow an outside query to only one or two of our selected entry points. The webserver interface query statement might, for example, be able to only call "select register_user(...)" or "select login_user()" and NONE of the other PostgreSQL command functions. I only want to allow access to these functions from the outside world, but the server needs to be able to execute all of the original functions without restrictions. Any information on this would be greatly appreciated, Lonnie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[GENERAL] versioning question
Which is the most recent version of Postgres, 7.1 or 7.1rc4 ? Thanks, -M@ -- There are more things in heaven and earth, Horatio, than are dreamt of in your philosophy. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Re: versioning question
Ah, thank you. I wasn't sure what the rc stood for. Thought it might have been additional updates since 7.1 like how the Linux kernel will have ac patchlevels whenever Alan Cox makes small updates. -M@ -- There are more things in heaven and earth, Horatio, than are dreamt of in your philosophy. On Wed, 18 Apr 2001, Mitch Vincent wrote: 7.1 is a release (the latest), 7.1rc4 is a *Release Candidate*. -Mitch Software development : You can have it cheap, fast or working. Choose two. - Original Message - From: "Matthew Hixson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 1:28 PM Subject: versioning question Which is the most recent version of Postgres, 7.1 or 7.1rc4 ? Thanks, -M@ -- There are more things in heaven and earth, Horatio, than are dreamt of in your philosophy. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] re-post
Amy Cheng requested that I post her reply to me back to the list since she did not have a copy of it. -M@ hi, search or browse "functions" and "PL/pgSQL" (and tcl and c/spi), "triggers". enough to start-up ;-) also, there is examples in the source's test directory. but, you are right, not in depth enough. I asked Several times, in different forms, in this list, NOT a SINGLE answer! Seems that nice expert are scarce nowadays. Let me put those questions together anyway, let's see ... the difference between Oralce's PL/SQL and PL/pgSQL (so that we can use the books on PL/SQL), the difference between PL/pgSQL and tcl (note that postgreSQL also support tcl now), does PL/pgSQL support array-like feature? how about tcl in postgreSQL? if I want use OS (i.e. external to dababase), can I use PL/pgSQL or tcl? if in C (spi), is it easy? anyway to get perl involved? From: Matthew Hixson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [GENERAL] stored procedures Date: Mon, 30 Aug 1999 12:58:45 -0700 Could someone point me to a tutorial or HOWTO regarding stored procedures? I know very little about them and need to learn everything I possibly can about them as soon as possible. I looked throught the Postgres docs and couldn't find anything that goes into them in depth. Thank you, -M@ -- Matthew Hixson - CIO FroZenWave Communications http://www.frozenwave.com
[GENERAL] stored procedures
Could someone point me to a tutorial or HOWTO regarding stored procedures? I know very little about them and need to learn everything I possibly can about them as soon as possible. I looked throught the Postgres docs and couldn't find anything that goes into them in depth. Thank you, -M@ -- Matthew Hixson - CIO FroZenWave Communications http://www.frozenwave.com
[GENERAL] PAM module for Postgres?
Hello, I'm searching for a PAM module that is capable of authenticating users against information contained in a PostgreSQL database. Does something like this exist arleady? This is to be used on a Linux system. Any info would be greatly appreciated. Thanks, -M@ -- Matthew Hixson - CIO FroZenWave Communications http://www.frozenwave.com
