~
I need to configure postgreSQL in a way that I could run it from a
directory mounted as read only, with separate rw partitions mounted
for the data, logs, . . .
~
What would be the steps to follow and the issues to take into consideration?
~
thanks
lbrtchx
--
Sent via pgsql-general mailing
... better yet; is it possible to configure postgreSQL in a way that
it depends on external variables set via the OS in the same process
in which it is started?
~
lbrtchx
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
On Tue, Jun 3, 2008 at 11:03 PM, Oliver Jowett <[EMAIL PROTECTED]> wrote:
> That's essentially the same as the COPY you quoted in your original email,
> isn't it? So.. what exactly is it you want to do that COPY doesn't do?
~
well, actually, not exactly; based on:
~
http://postgresql.com.cn/docs/
~
I am developing a J2EE application that needs for users to only read
DB tables. All queries are select ones, no updates, no inserts, no
deletes for web users, so I keep this ro DB tables in certain
partitions which I mount as ro
~
For performance reasons I keet the DB in the same box as the ser
On Wed, Jun 18, 2008 at 10:36 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> . . . SQL permissions should be all you need.
>
> -Doug
~
What about the security implications? Is the J2EE server enough to
control access to the DB?
~
Java does not allow for buffer overruns and such hacking venues,
~
I have been searching for a PostgreSQL-derived project with a
"less-is-best" Philosophy. Even though I have read about quite a bit
of PG forks out there, what I have in mind is more like a baseline
than a fork.
~
My intention is not wrapping the same thing in a different package or
code add-ons
~
Well, at least I thought you would tell me where the postgresql-base
is to be found. The last version I found is:
~
http://freebsd.csie.nctu.edu.tw/pub/distfiles/postgresql/postgresql-base-8.3beta2.tar.bz2
~
and I wondered what that is and why there are no postgresql-base
after "8.3beta2"
~
>
On 9/25/11, David Johnston wrote:
> On Sep 25, 2011, at 2:11, Albretch Mueller wrote:
>> Can you or do you know of anyone who has made those kinds of
>> imaginations falsifiable?
>
> No; not worth my effort.
~
;-)
~
>>> That approach strips down on application
On 9/25/11, Karsten Hilbert wrote:
> On Sun, Sep 25, 2011 at 09:41:19PM +0000, Albretch Mueller wrote:
>
>> I am amazed to read that you/the PC community were still running
>> regression tests
>>
>> *in ASCII*:
>>
>> http://www.postgresql.org/
On 9/26/11, Uwe Schroeder wrote:
> In my experience "data formatting" goes both ways, in and out. Out is
> obviously not a major issue because errors don't cause data corruption. In,
> however, is a different issue. Errors in "inwards" conversion will cause
> data
> corruption. So unless you have
Hi,
~
I created a number of csv files which I need to import into PG
tables. On the them looks like this:
~
sh-3.1# head -n 3
/media/hda3/prjx/JPack/REF/LANDMARKS/PROFILES/20080828104627_j2sdk-1_4_2_18-linux-i586.binfls.md5sum.txt
"md5sum","fl"
"d41d8cd98f00b204e9800998ecf8427e",".systemPrefs/.sy
On Thu, Aug 28, 2008 at 5:40 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> You have to create the table first before you can COPY into it.
~
Well, based on how the statement reads I made the wrong assumption of
thinking that PG would be smart enough to make ends-meat with the
data that it ge
Hi,
~
I am trying to get dups from some data from files which md5sums I
previously calculated
~
Here is my mere mortal SQL
~
SELECT md5, COUNT(md5) AS md5cnt
FROM jdk1_6_0_07_txtfls_md5
WHERE (md5cnt > 1)
GROUP BY md5
ORDER BY md5cnt DESC;
~
and this is what I get:
~
jpk=# SELECT md5, COUNT(md5
On Thu, Aug 28, 2008 at 7:50 PM, Adrian Klaver <[EMAIL PROTECTED]> wrote:
> Define easily.
~
OK, let me try to outline the approach I would go for:
~
I think "COPY FROM CSV" should have three options, namely:
~
1) the way we have used it in which you create the table first
~
2) another way in w
Also I know there is a DISTINCT keyword, but I also need to know how
many times the particular data in the column is repeated if it is,
that is why I need to go:
~
SELECT md5, COUNT(md5) AS md5cnt
FROM jdk1_6_0_07_txtfls_md5
WHERE (md5cnt > 1)
GROUP BY md5
ORDER BY md5cnt DESC;
~
Thanks
lbr
> I think you're confusing postgresql with a spreadsheet program.
~
I wonder what makes you think so
~
> There are client programs which will do this for you, perhaps you wan one of
> those?
~
Well, then obviously there is the need for it and you were not
successful enough at convincing these de
thank you Stefan your SQL worked, but still; I am just asking and my
programming bias will certainly show, but aren't you effectivly
"calling" count on the table three times if you go:
~
SELECT md5, COUNT(md5)
FROM jdk1_6_0_07_txtfls_md5
GROUP BY md5
HAVING COUNT(md5) > 1
ORDER BY COUNT(md5) DESC;
> spreadsheet programs (generally; I'm sure there are exceptions) don't have
> the notion of a schema; each cell can hold its own particular type.
~
Oh, now I see what Martin meant!
~
> that's not a traditional part of a database engine.
~
well, yeah! I would totally agree with you, but since I
> The system is smart enough to only do the count() once.
~
But not smart enough to make a variable you declare point to that
internal variable so that things are clearer/ easier ;-)
~
Thanks
lbrtchx
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
> ... are times local or UTC
~
this is a rather semantic, not a syntactic issue that some code could
NOT decide based on the data it reads
~
> Should we assume integer or float?
~
is a dot anywhere in the data you read in for that particular column? ...
~
> Varchar or text?
~
Is the length of th
You can't find any books and if you go to the company they tell you
~
sraoss.co.jp/index_en.php
~
all you find are commercial services offered. No mention of the exam
~
Any suggestions?
~
Thank you
lbrtchx
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
well, I have kept searching for it and found a somewhat funny message
from the sraoss.co.jp guys
[GENERAL] LPI-Japan to start PostgreSQL certfication
and a long thread
[GENERAL] PostgreSQL Certification
which tellingly was quickly hijacked into other topics
on pearsonvue.com/sra/ it says
22 matches
Mail list logo
