Re: [GENERAL] In memory Database for postgres

[Andrej Ricnik-Bay]

2008/11/18 aravind chandu <[EMAIL PROTECTED]>:
> Hello,
Hi!

>   I guess most of you guys heard about In Memory Database.I have
> a small question regarding it.I need to create an In Memory Database for
> postgresql through which I have to perform various operations on postgresql
> database(queries,procedures,programs using pqxx API etc...).I didn't have
> any idea of how to start and where to start this issue.Please comment on
> this issue,so that it will be really helpful to me .
The fact aside that it's a "bad idea" (tm): you could have the data files
reside in a RAM disk.  Which OS are you planning to do this on?


> Thanks,
> Avin.
Cheers,
Andrej




-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] [OT] newsreader issue? (Was: bytea encode performance issues)

[Andrej Ricnik-Bay]

On 04/08/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> One last thing.  I'd rather my emails just get dropped silently if
>  that's the minimum someone can do.  Use a valid email address that
>  goes to /dev/null and I'll be happy.  You may miss a few things sent
>  directly to you, but since that's not what you want anyway, it's no
>  big loss, right?
Aye ... dodgy spam-protection methods like that really suck.

-- 
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] [OT] newsreader issue? (Was: bytea encode performance issues)

[Andrej Ricnik-Bay]

On 04/08/2008, Lew <[EMAIL PROTECTED]> wrote:

>  Was the message to which you responded posted to the newsgroup?  It isn't
> appearing in my newsreader.
>
>  Who wrote the message you quoted (you failed to cite the source)?
He was quoting Alban Hertroys, and it appeared on the general mailing list
(I didn't even know there was a Newsgroup).

There seems to be a problem with your mail address, however ... ;}

-- 
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] Problems Restarting PostgreSQL Daemon

[Andrej Ricnik-Bay]

2008/7/28 Rich Shepard <[EMAIL PROTECTED]>:
>  Thank you. I think that for some reason using pg_ctl to start the
> postmaster is no longer working here. As I have time, I'll look into why.
Can you do a 'locate pg_ctl|xargs ls -l' and see whether you have more than one
installed, and if so, which one comes first in the PATH?

> Rich
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Problems Restarting PostgreSQL Daemon

[Andrej Ricnik-Bay]

On 27/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:

>   Well, that's the problem, Andrej. I have that script, and it worked fine
>  with postgres-6.x through -8.1, but failed to correctly start the
> postmaster  after the system reboot.
I thought we had established that this issue was caused by
the current instance pointing at the old installs data directory?


>   I can try twiddling with the script; it calls pg_ctl, and that should
>  work, but apparently something broke last week.
That should be quite easy to tweak, really ... my current script
(slightly modified from the one in contrib/startup-scripts) is attached...
You may need to change the dirs in the script yet a bit.

>  Thanks,
>
>  Rich
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm


rc.postgres
Description: Binary data

-- 
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] Problems Restarting PostgreSQL Daemon

[Andrej Ricnik-Bay]

On 27/07/2008, Tom Lane <[EMAIL PROTECTED]> wrote:
> Startup scripts invariably run as root, so 'su' isn't going to ask
>  for a password...
And it's nothing to worry about because the script he's using
is suing to the postgres user anyway ...


> regards, tom lane
Cheerw,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Problems Restarting PostgreSQL Daemon

[Andrej Ricnik-Bay]

On 27/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:

>  Andrej,
Hi Rich,

>   I found the thread in the archives for June of this year.
>
>   Re-reading the posted results of running initdb I tried a different
>  approach to starting the server. Instead of using pg_ctl I used 'postgres
> -D
>  /var/lib/pgsql/data &' (while logged in as user postgres, of course.) That
>  cleaned up a bad shutdown (when I had to reboot the system after it hung),
>  fixed the missing socket, and replaced the .pid. So, it's up and running
>  once again.
>
>   My question is how best to modify the startup script so the postmaster
>  fires up when the system is rebooted. I don't see an option to 'su' to
>  specify the postgres user's password so I can script this. Have you any
>  recommendation?
Since Slackware doesn't use the SysV style of inits but default the
easiest way for you to achieve an automatic start-up of postgres
on reboot would be to add something like
if [ -x /etc/rc.d/rc.postgres ]; then
  /etc/rc.d/rc.postgres start
fi
to your /etc/rc.d/rc.local


>  Thanks,
>
>  Rich
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Problems Restarting PostgreSQL Daemon

[Andrej Ricnik-Bay]

On 23/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:

>  Andrej,

Hi Rich,

>  Unless others consider this topic to be not appropriate for the list, I
>  don't mind a public conversation. I thought that I attached the script to
>  my original message; regardless, here's the attribution:

You did - my bad. I usually ignore attachments on mailing-lists,
and did so with yours.


>   I upgraded postgres manually, not creating and using a Slackware package.
>  It worked just fine until yesterday's reboot.

Now there's an interesting piece of information :) How long
ago did you upgrade it?
>From which version of pg to which version did you upgrade,
and how did you go about it?  Chances are indeed that the
postmasters logfile (/var/log/postgres) may hold crucial
information as Tom suggested.


>  Thanks,
>
>  Rich

Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Problems Restarting PostgreSQL Daemon

[Andrej Ricnik-Bay]

On 23/07/2008, Rich Shepard <[EMAIL PROTECTED]> wrote:

>   When I run the Slackware script, '/etc/rc.d/rc.postgresql start' (script
>  attached), I'm shown a process ID and told the daemon is already running.
>  For example:
Since there are no official Slackware postgres packages
I'd like to ask where that script came from :) and how you
installed postges in the first place.  Happy to communicate
of the list if you prefer that.


>  TIA,
>
>  Rich
Cheers,
Andrej

-- 
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] plperl installation

[Andrej Ricnik-Bay]

On 15/07/2008, JD Wong <[EMAIL PROTECTED]> wrote:
> Hey all I'm want to use plperl but directory does not exist and I did not
> specifically enable it during installation.  -Does anybody know how to
> install it post-install?
Which OS is this on?  If it's Linux, which distro? And how did you install,
from source?

> Thanks
> -JD
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Need some help

[Andrej Ricnik-Bay]

On 01/07/2008, Jamie Deppeler <[EMAIL PROTECTED]> wrote:
> trying to install Postgresql 8.3  and i keep getting these errors
>
>  libodbc.so is needed
>  libodbcinst.so is needed
>
>  Hopefully someone can help me
I'll hazard a guess and assume you're using some sort
of Linux :} ...which distro are you using, how are you
installing postgres?


Cheers,
Tink

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Bottom Posting

[Andrej Ricnik-Bay]

On 29/05/2008, Bob Pawley <[EMAIL PROTECTED]> wrote:

> ... get their point across up front without making me wade through
> previous posts which I have already read.
Good for you :}

>  I can understand the concept of bottom posting
No one advocates bottom-posting here. It's all about intersparsed
with relevant bits left standing.


>  The concept of most lists should be "the free exchange of ideas in the most
> efficient manner possible".
Which is per agreement on the list intersparsed. Which also allows people
only just hopping onto the train of thought to get a good understanding
of what a thread is about without having to read the lot top to bottom.
May not match your individual preference, but then that's not what the
list is about, either.


>  Bob
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Open Source CRM - Options?

[Andrej Ricnik-Bay]

On 28/05/2008, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>  > How does Zope/Plone fit in there as an alternative in your opinion? :)

> Do you really want the answer to that? :P

Of course!  I know a few people who swear by it (and I've never had
to use it ...)



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Open Source CRM - Options?

[Andrej Ricnik-Bay]

On 28/05/2008, Kevin Hunter <[EMAIL PROTECTED]> wrote:
>  > And its python :)
> That's actually a bigger plus than folks may realize because all three
>  communities (Django, Postgres, Python) share the
>  "do-it-the-right-way,-not-just-the-quickest/easiest-way" mentality.  (At
>  least in my experience.)  From an overall quality perspective, this is a
>  huge win for all involved.  And if you're developing, you will
>  appreciate the chat rooms/mailing lists/community-in-general for all
>  three for just this reason.

How does Zope/Plone fit in there as an alternative in your opinion? :)


>  Kevin
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Stored procedures in C

[Andrej Ricnik-Bay]

On 24/04/2008, Emiliano Moscato <[EMAIL PROTECTED]> wrote:
> I have to do some stuff writing stored procedures for Postgres in C. I saw
> the oficial documentation but it was hard for me to find out how to do a
> simple function, let's call it "query()" , that receives a string and uses
> this string to do a query and return the results. Has anyone some examples?

You don't mentioned where else you looked - did you come across these?

http://linuxgazette.net/139/peterson.html

http://www.faqs.org/docs/ppbook/x15284.htm

http://www.observercentral.net/~selkovjr/postgres/tutorial/html/exttut-getstart.html



> Thanks in advance...
> Regards,
>
> Emiliano

Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Survey: renaming/removing script binaries (createdb, createuser...)

[Andrej Ricnik-Bay]

On 01/04/2008, Steve Crawford <[EMAIL PROTECTED]> wrote:
>  One advantage of using a consistent prefix is that when you have
>  forgotten the exact name of a rarely used command and you are using a
>  shell with readline support, "pg_" will bring up a list of
>  available commands.
For any value of shell IN {bash, tcsh, zsh}.
sh (default on solaris) and ksh won't, and neither will cmd.exe

But I (as a user of bash) see your point.


>  Cheers,
>
> Steve
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Schema design question

[Andrej Ricnik-Bay]

On 29/03/2008, Ben <[EMAIL PROTECTED]> wrote:
> I'm working on a project which requires me to keep track of objects,
>  each of which can have an arbitrary number of attributes. Although
>  there will be many attributes that an object can have, the data types
>  of those attributes won't be all that varried (int, float, text,
>  boolean, date, etc.).

And a somewhat unorthodox suggestion for the list ... would it
be worthwhile considering a different storage mechanism all
together, like maybe an LDAP directory type of thing?  The query
language is admittedly very limited.

Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Survey: renaming/removing script binaries (createdb, createuser...)

[Andrej Ricnik-Bay]

On 28/03/2008, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
>  Agree, except I would prefer "pg" instead of "pgc".
>
>  With "pg" I am sure that the comand is "generic to the extreme", so I don't
>  have to assume what does "c" stand for.  Control?  Create?  Client?  or 
> Command.
>
>  Also its about 33% shorter. ;-)

And it's been taken for about 35 years by a Unix command called "page".
>From its man-page.

PG(1)User Commands   PG(1)



NAME
   pg - browse pagewise through text files


I really find this whole discussion quite silly;  it's about someone's
personal preference?  Don't get me wrong, I'm a lowly user when it
comes to pg, and not a member of the hacker-community.  But I've
been using postgres for a good number of years now (since v7, I think)
and have become quite accustomed to the names of the tools in
use, have never observed any clashes with other tools, and as a
Linux/Unix sys-admin type of person never had a problem with
mistaking createuser for useradd or adduser.

And I'll stick by the old maxim:  if it ain't broken, don't fix it.


>Regards,
>
>  Dawid

Cheers,
Andrej

>  PS: And I feel it feels more natural to say "pg createuser" than "pgc
>  create user", but that's solely my "typing impression".

And it's noticeably shorter to just type createuser ;} ... which worked a
treat for many many moons.


Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Survey: renaming/removing script binaries (createdb, createuser...)

[Andrej Ricnik-Bay]

On 27/03/2008, Zdeněk Kotala <[EMAIL PROTECTED]> wrote:
>  1) What type of names do you prefer?
>  ---
>  a) old notation - createdb, createuser ...

a)  Never seen any clashes with other tools in terms of names.
 And the old sys-admin creed: don't fix it if it ain't broken.


>  2) How often do you use these tools?
>  ---
>  a) every day (e.g. in my cron)
>  b) one per week
>  c) one time
>  d) never

e) occasionally


>  3) What name of initdb do you prefer?
>  -- --
>  a) initdb
>  b) pg_initdb
>  c) pg_init
>  d) pg_ctl -d  init  (replace initdb with pg_ctl new functionality)
>  e) What is initdb? My start/stop script does it automatically.

a) initdb


>  4) How do you perform VACUUM?
>  -
>  a) vacuumdb - shell command
>  b) VACUUM - SQL command
>  c) autovacuum
>  d) What is vacuum?

c, b, a ... in this order.


Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] table size and storage location

[Andrej Ricnik-Bay]

On 25/03/2008, chuckee <[EMAIL PROTECTED]> wrote:

> Thanks but I still get the error 'ERROR:  relation "capture" does not exist'
>  when trying these two alternative functions you mention above. There is
>  definitely a table called 'capture' in my database!
Are you sure you're connected to the right database
when running that?



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] How to "use" database?

[Andrej Ricnik-Bay]

On 25/03/2008, Anton Andreev <[EMAIL PROTECTED]> wrote:
> Hi,
Hi,

>  How to use a database I have just created  in a script that  I am
>  executing in Pgadmin3 on Windows?
>  I can not use "USE Northwind;" or "\connect Northwind;"?
Hard to say w/o knowing the script.  Does it just create tables,
or does it supposedly create a database as well?


>  Cheers,
>  Anton
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Need help to migrate pqSQL db 8.0.3 to 8.2.6

[Andrej Ricnik-Bay]

On 26/03/2008, Tri Quach <[EMAIL PROTECTED]> wrote:
> Hi Andrej,
Hi Tri!

>  I am running on Linux, Red Hat 3.
>  I have hard time to use pg_dump command.  Can you give me the syntax of
>  pgdump?
Not a syntax-problem; to use pg_dumpall you need to be
the postgres (superuser).

su - postgres
pg_dumpall > dbfile

If you'd rather run it individually for each DB become the
user who owns the respective DB.


>  Thank you for your help.
>
> Tri.
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Need help to migrate pqSQL db 8.0.3 to 8.2.6

[Andrej Ricnik-Bay]

On 25/03/2008, Tri Quach <[EMAIL PROTECTED]> wrote:
> Hi All,


> I installed pqsql 8.2.6 on a new server.  I need to migrate the data from
> pqSQL db 8.0.3 on the old server to 8.2.6 on the new server.  Can anyone
> provide me a document how to migrate?
It's part of the package.  Read the INSTALL document that comes with
postgres, it has an UPGRADE section.  In a nutshell you want to use
pg_dump (or pg_dumpall, depending on how many databases you
have loaded) ... you can either save the files, install the new version
and import them, or you can (if you start the newer version on a
different port than 5432 and have it use a different base directory)
have both versions running at the same time.

What OS & version are you running PG on? And if you can, use 8.2.7


> Thank you for your help.
>
> Tri
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] [postgis-users] how many min. floating-points?

[Andrej Ricnik-Bay]

On 22/03/2008, John Smith <[EMAIL PROTECTED]> wrote:
>  > > please don't cross-post my cross-post. if i wanted to post it to the
>  > > postgresql list, i would have ;)

>  > That seems to be quite a silly request, considering you were asking for
>  > assistance on public lists.

> no seriously! if i wanted to post it to the postgresql list, i would
>  have. thanks but no thanks.
>  jzs

You did.  I can't see what would make you think you hadn't.

Here's the relevant header part from you original message:
8<8<8<8
Date: Thu, 20 Mar 2008 14:02:12 -0400
From: "John Smith" <[EMAIL PROTECTED]>
To: "PostgreSQL General" 
Subject: [GENERAL] [postgis-users] how many min. floating-points?
Cc: "PostGIS Users Discussion" <[EMAIL PROTECTED]>
8<8<8<8

Re: [GENERAL] [postgis-users] how many min. floating-points?

[Andrej Ricnik-Bay]

On 21/03/2008, Colin Wetherbee <[EMAIL PROTECTED]> wrote:
> Dunno about that.  On the PostGIS list, he said:
>
>  "i got an old box supporting only 1 floating-point"
>
>  Maybe he means an FPU? *boggle*
Maybe floating-point registers on the FPU?

So many options!


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] postgre vs MySQL

[Andrej Ricnik-Bay]

On 14/03/2008, Steve Crawford <[EMAIL PROTECTED]> wrote:
>  > What can I say?  96% of personal computers run some form of
>  > windows.  Does that mean it's a superior product to a PC running
>  > Linux, or a Mac w/  MacOS?
>  > I'd say "no" (actually more like "NOOO!"), because windows doesn't let
>  > me do 80% of the things that I do (need to do) with my PC.
>  >
>  > >From the fact hat the user-base is so massive, can I deduce that
>  > windows is superior in terms of security or easy maintenance?
>  > My personal experience says "No, no way".

> Whoa! Sure glad I read this thread. I was about to buy a Bentley but now
>  that I know that sales figures are the sole measure of quality I can see
>  that the Kia is clearly a superior vehicle.

Heh. :}

A silly question in this context:  If we know of a company that does use
PostgreSQL but doesn't list it anywhere ... can we
tahttp://www.securecomputing.com/techpubsRC.cfm?pid=85ke the liberty
to
publicise this somewhere anyway?

E.g. the  control center (
http://www.securecomputing.com/techpubsRC.cfm?pid=85 )
uses postgres, the only official attribution (I've seen the binaries in the
file-system) is that their product uses port 5432 in the manual.



Cheers,
Andrej

P.S.: This is all really starting to belong to advocacy :}



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] postgre vs MySQL

[Andrej Ricnik-Bay]

On 14/03/2008, rrahul <[EMAIL PROTECTED]> wrote:
>  Thanks to all you wonderful people out their. I don't know if its your love
>  for Postgres or nepothism that makes it look far superior than mysql.
>  But why does the client list dosen't tell that?
>  I see Mysql bosting for Google,Yahoo, Alcatel..
>  What about Postgres the list is not that impressive.
What can I say?  96% of personal computers run some form of
windows.  Does that mean it's a superior product to a PC running
Linux, or a Mac w/  MacOS?
I'd say "no" (actually more like "NOOO!"), because windows doesn't let
me do 80% of the things that I do (need to do) with my PC.

>From the fact hat the user-base is so massive, can I deduce that
windows is superior in terms of security or easy maintenance?
My personal experience says "No, no way".

What then?  Could it be marketing or the sad results of a avalanche
effect? Geee, there's a thought.


>  cheers,
>  Rahul.
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Dump format for long term archiving.

[Andrej Ricnik-Bay]

On 14/03/2008, brian <[EMAIL PROTECTED]> wrote:
> The version you dump it from is unlikely to be difficult to find ten
>  years from now. I'd just make sure to append the pg version to the
>  archive so it's obvious to any future data archaeologists what's needed
>  to breathe life back into it.
Let me play devils advocate here ...

While the source for PG 8.x will be around there's no guarantee
that future enhancements to gcc (or whatever commercial compiler
you'll be using) will still allow you to compile it w/o potentially long-
winded modifications to the original source.

My gut-feeling is that trying to keep data as a "moving target", with
some redundancy in terms of storage and hardware, and updating
the appropriate means every few years (financial life-cycle?) is a
sensible method  :}


Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Trigger to run @ connection time?

[Andrej Ricnik-Bay]

On 12/03/2008, Kynn Jones <[EMAIL PROTECTED]> wrote:

> If one can set up this insert operation so that it happens automatically
> whenever a new connection is made, I'd like to learn how it's done.  But if
> not, then I don't see how performing the insert "manually" every time one
> connects would be any easier than simply executing the perl_setup()
> procedure directly.
After having thought about this for a few seconds  you
could conceivably use some OS/DB integration to achieve this.
Just make sure postmaster writes new connections to a log,
monitor that log from a script, and if it sees a "connect" have
that insert a value into "special table" of yours that then can
do the trigger you looked for?   Of course I may not have quite
understood how that  "this procedure adds useful definitions,
mostly subs, to Perl's main package.  This needs to be done
for each connection" is meant to work.


Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] split pg_dumpall backups per database

[Andrej Ricnik-Bay]

On 11/03/2008, Luca Ferrari <[EMAIL PROTECTED]> wrote:
> Hi all,
>  is it possible to instrument pg_dumpall to produce separate sql files for 
> each
>  database it is going to backup? I'd like to keep separate backups of my
>  databases, but using pg_dump can lead to forgetting a database.

You could use the method described here for a single database:
http://archives.postgresql.org/pgsql-general/2008-02/msg00343.php

Just slap a wrapper around it (untested),  out.sql being the name of
the dump-file:

for i in  $(awk '/^CREATE DATABASE/ {print $3}' out.sql); do dump.sh
${i} out.sql  ${i}.sql; done

Of course you won't be getting the creation of specific roles or
anything that way.


>  Thanks,
>  Luca
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] PHPs PDO, apache and "never ending sessions"

[Andrej Ricnik-Bay]

On 07/03/2008, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>  > A bit of poking around with ps and lsof showed me that a PHP
>  > application I closed days ago (no browser open) was still active
>  > tying up backend sessions;  the problem went away when I
>  > restarted my apache.  Is this "normal behaviour"?  How do I
>  > deal with it under normal circumstance, am I just supposed
>  > to increase the number of allowed connections and not worry
>  > about apache holding sessions open even after the "client"
>  > has long gone?

> It depends on how you are connecting. For example if you are doing this:
>
>  PDO::ATTR_PERSISTENT => true
>
>  Then... yeah :). You really shouldn't use a language layer for
>  persistent connections though. Use pgbouncer or pgpool.
Thanks Joshua.  It was indeed set to true;  I was playing with
the "hatshop" database and application from the "Beginning
PHP and  PostgreSQL E-Commerce" Apress book. And  found
that config.php has "define('DB_PERSISTENCY', 'true');". Thanks
for pointing me in the right direction.


>  Joshua D. Drake

Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PHPs PDO, apache and "never ending sessions"

[Andrej Ricnik-Bay]

Hi,

Not sure whether this is the right place to ask (probably isn't)
but I've seen much mention of PHP and some of PDO on this
list ...

I'm currently playing with the above, today I got a message
"FATAL:  connection limit exceeded for non-superusers"
even though there were no sessions I was aware of open.

A bit of poking around with ps and lsof showed me that a PHP
application I closed days ago (no browser open) was still active
tying up backend sessions;  the problem went away when I
restarted my apache.  Is this "normal behaviour"?  How do I
deal with it under normal circumstance, am I just supposed
to increase the number of allowed connections and not worry
about apache holding sessions open even after the "client"
has long gone?

Versions of products in question:
apache2 2.2.8 (Unix)
PHP 5.2.5
postgres 8.3


Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

-- 
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] Requiring a password

[Andrej Ricnik-Bay]

On 06/03/2008, Ralph Smith <[EMAIL PROTECTED]> wrote:
> I guess I'm missing something.
>
> Question part A)
>
> Even after reloading and restarting the DB, which shouldn't be necessary,
> smithrn still gets in w/o any password checks.
> How come?
Impossible to answer w/o knowing any entries in your pg_hba.conf


> Question part B)
>
> I have SSL on, and all the client boxes also have it.
> If I change HBA, how will / would I change my login?
> As it is now, a particular user connects to a particular DB w/o any password
> prompt.
> e.g.:  psql -U username dbname
To the best of my knowledge the authentication shouldn't
be affected by the transport ...


> Thank you!
>
>
> Ralph Smith
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Trouble running PostgreSQL server / Server must be started under certain locale.

[Andrej Ricnik-Bay]

On 28/02/2008, Olmec Sinclair <[EMAIL PROTECTED]> wrote:
>  Anyway, I uninstalled and installed using the ubuntu package manager. I
> tried again this morning - removing 8.2 and then reinstalling 8.2 again...
> still won't start.
Are you seeing any error messages?  W/o more detail it's impossible
to even start trying to support you.
What does /var/log/postgresql/postgresql-8.2-main.log say?

>  I'm sure I can work through this (I seem to remember having a starting
> issue before) but the data locale thing is a worry.
That, too, is indeed.  Now ... gutsy doesn't have 8.3 officially yet
(I don't think).  What other repositories did you tie in with your apt?


>  Cheers (from Christchurch)
>
>  Olmec
Cheers,
Andrej

---(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: [GENERAL] Trouble running PostgreSQL server / Server must be started under certain locale.

[Andrej Ricnik-Bay]

On 28/02/2008, Olmec Sinclair <[EMAIL PROTECTED]> wrote:
Hello again!

And please remember to hit reply-to-all so everyone on the
list sees what you're saying.  Also please note that top-posting
is frowned upon here. :)

>  I am running postgres on Ubuntu 7.10 (recent convert from windows) and I
> think my previous version of postgresql was 8.2

>  Last night I un installed 8.3 and reinstalled 8.2 but now I can't get that
> to start so I'm not making much progress. The problem is I don't really
> know what I am doing :)
By which means did you do the installation/un-install of both versions?
What data-directory is/was which version using?



>  I am learning slowly though.
>
>  Olmec
Cheers from sunny Wellington,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Trouble running PostgreSQL server / Server must be started under certain locale.

[Andrej Ricnik-Bay]

On 27/02/2008, Olmec Sinclair <[EMAIL PROTECTED]> wrote:
Hi Olmec,

>  I have encountered a similar situation that came about when I
> upgraded to postgres 8.3. Now it won't start stating that:

>  The server must be started under the locale : which does not
> exist any more
>
>  (it looks like the locale is set to {blank} ???)
>
>  Not sure what I should do here. Removing mostprest to an older version
> might be the way to go?
That was Richards suggestion for Geoff who had the
problem.  What OS are you running PostgreSQL on?


> Olmec Sinclair
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Understanding ps -ef "command" column

[Andrej Ricnik-Bay]

On 23/02/2008, David Jaquay <[EMAIL PROTECTED]> wrote:
> When I do a ps -ef, in the command column, I see:
>
> postgres: postgres dbname 10.170.1.60(57413) idle
This doesn't resemble any "ps -ef"  output I've ever seen.
What OS is this on, what's the version of ps?


Cheers,
Andrej

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Are indexes blown?

[Andrej Ricnik-Bay]

On 17/02/2008, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> But this is kind of sitting there, hogging the command prompt. Is
> there any way I can let it go on in the background?

Ouch ... no, that's entirely my fault, wasn't quite awake I
guess, and hadn't thought it through completely ... that's
not going to give us the desired result...

Try this:

for z in `seq 1 3600`; do top -b -d 1 -n 1| awk -f top.awk; done | tee topoutput

Not sure whether it's going to give us the desire granularity of time...


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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] Where is the system-wide psqlrc on RHEL4?

[Andrej Ricnik-Bay]

On 10/02/2008, Dean Gibson (DB Administrator) <[EMAIL PROTECTED]> wrote:
> It's not installed in the base/server/libs RPMs.  I had to search the
> uninstalled PostgreSQL RPMs for it, and then (temporarily) install the
> "devel" RPM to run it.  For CentOS 4.4 & RHEL4, the system-wide psqlrc
> is in /etc/sysconfig/pgsql/
Another alternative (quick & dirty) would have been to
strace -o whereisit psql
and
grep psqlrc whereisit


> -- Dean
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Reload only specific databases from pg_dumpall

[Andrej Ricnik-Bay]

On 05/02/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote:
And a more generic version :}

8<8<8<8<8<8<8<8<
#!/bin/bash
# split.sh:  a shell script and wrapper for some (g)awk to extract a single
#database out of a dumpall file - a quick and ugly hack, as
#usual no other warranty as that it worked with my test-case. :}
#
# It relies on GNU awk > 3, may work with nawk/mawk, but I didn't test that.
# The old traditional awk as shipped with Solaris as the default will most
# definitely barf on this one.
#
# The reason for the writing out of the awk-script to /tmp is the invocation;
# I couldn't figure out a way to pass the filename to the BEGIN part other
# than via a variable, and I couldn't stand the thought of having to enter
# it manually on the command line twice. :} And I didn't like the idea of
# writing/saving two separate scripts - shoot me :D
#
# It creates two temporary files that it hopefully wipes after a
# successful run.

# hacked up by andrej
function usage {
echo "Usage: $0 databasename inputfile outputfile"
echo ""
echo "   where database is the name of the database you want to isolate"
echo "   out of the dump-file, inputfile is the file generated by
pg_dumpall"
echo "   from which you want to extract a single database, and
outputfile is"
echo "   the target file you want to write the extracted data to"
echo ""
}

if [ $# -ne 3 ]; then
usage
exit 1
fi


database=$1
input=$2
output=$3
pid=$$
temp=/tmp/awk.prog.$pid
cat > $temp <<\END
BEGIN{
  system( "fgrep -in \"\\connect \" " file "> /tmp/outPut" )
  while( getline line < "/tmp/outPut" > 0 ){
count++
numbers[count]=line
  }
  for (i=1; i<=count;i++ ){
if ( numbers[i] ~ db ){
  start = gensub(/([0-9]+):.+/, "\\1", "g",  numbers[i])
  stop = gensub(/([0-9]+):.+/, "\\1", "g",  numbers[i+1]) - 1
}
  }
  matchdb="CREATE DATABASE "db".+;"
}
{
  if( $0 ~ matchdb  ){
print
  }
  if(( NR >= int(start) ) &&( NR <= int( stop ) ) ){
print
  }
}
END

sed -i "s/outPut/outPut.$pid/" /tmp/awk.prog.$pid
awk -v file=$input -v db=$database -f /tmp/awk.prog.$pid $input > $output
rm /tmp/awk.prog.$pid /tmp/outPut.$pid
8<8<8<8<8<8<8<8<



Cheers,
Andrej

---(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] Reload only specific databases from pg_dumpall

[Andrej Ricnik-Bay]

Or, for the heck of it:
sed -n -e '/DATABASE smarlowe/p' -e  '141,334p'  test.sql > clean.sql

;}



Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Postgres with daemontools or similar

[Andrej Ricnik-Bay]

On 05/02/2008, Chuck D. <[EMAIL PROTECTED]> wrote:


> would never know if there was an issue.  I was also looking into monit.
I don't know what others recommend, but I'd be violently opposed to
the automatic re-starting for the very reason you mention above.
Monitoring it via monit, nagios or which other tools you have at hand
sounds very sensible to me, and I'd go with that for sure.


> What is the best way to monitor the postmaster and notify or restart on
> problems?  What solutions have other SysAdmin's incorporated successfully?
Nagios here, with e-Mail and pager alerts.  Monitoring the postmasters
presence and the ability to connect to 5432 


Cheers,
Andrej




-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] "pg_ctl: cannot be run as root"

[Andrej Ricnik-Bay]

On 05/02/2008, Stefan Schwarzer <[EMAIL PROTECTED]> wrote:
> But strange enough, I only can start the postgres server from time to
> time, normally when I have freshly restarted the machine. Now for
> example, I did some changes to the postgresql.conf file, and when
> trying to restart the postgres server, I get this:
...
> PS: Running Leopard on MacPro.
I don't know MacOS very well, and it's been a while that I last
had my hands on MacOS X (>2 years).  Are you saying that
you use MacOS as user root by default, rather than as a non
privileged account?


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Is PostGreSql's Data storage mechanism "inferior"?

[Andrej Ricnik-Bay]

On 01/02/2008, Tony Caduto <[EMAIL PROTECTED]> wrote:
> The part about the BSD license is bogus. A BSD license is the most
> desirable of any Open Source license and gives you the right to use
> PostgreSQL in your commercial apps without worry.
While I'm a big fan of the BSD license (for varied reasons) I think that
OpenSource hardliners like RMS would argue that the BSD license is *NOT*
in the true spirit of OpenSource *BECAUSE* of what you list as a bonus
of it ... the locking down of benefits reaped from OpenSource not getting
back into the stream.


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

[GENERAL] Members-choice award at LinuxQuestions.org

[Andrej Ricnik-Bay]

Hi Guys,

Apologies for the cross-post, I already posted this in advocacy a
few days ago, and am hoping for a slightly better exposure here.

Over at http://www.linuxquestions.org a members-choice award for
2007 is currently going on.  Every year I see a great influx of people
signing up solely for the purpose of voting for firebird ... to counter-
balance that I thought we could maybe get some people to vote for
the best OpenSource RDBMS instead? :}   Not that firebird wins (most
of the time MySQL does :/), but I'd sure like to see more votes for
Postgres in that poll.

http://www.linuxquestions.org/questions/2007-linuxquestions.org-members-choice-awards-79/database-of-the-year-610185/


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] How to automate password requests?

[Andrej Ricnik-Bay]

On 11/01/2008, Marten Lehmann <[EMAIL PROTECTED]> wrote:

> is there no way to specify the password directly? I don't like to create
> a separate file because all config is done in a shell script. I could
> set a certain environment variable with the password, but does pgadmin
> read a password from such a variable? If yes, what is its name?
This is generally a bad idea, because on many systems one can
see the environment variables with which a process was started
in ps' output.
It shouldn't be too hard for your config-script to echo the proper
parameters into ~/.pgpass . You best forget about the thought
of having a shell variable with the password ;}


> Regards
> Marten
Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] Hijack!

[Andrej Ricnik-Bay]

On 12/15/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
L > Leif B. Kristensen wrote:
O > I  > me too.
L > t  >
  > '  > On Wednesday 12. December 2007, Gregory Stark wrote:
  > s  >> "Alvaro Herrera" <[EMAIL PROTECTED]> writes:
>>>> Thomas Kellerer wrote:
  > n   Joshua D. Drake, 11.12.2007 17:43:
  > o  > O.k. this might be a bit snooty but frankly it is almost 2008. If
  > t  > you are still a top poster, you obviously don't care about the
  >> people's content that you are replying to, to have enough wits
  >  to
  > t  > not top post.
  > h   I personally find non-trimmed bottom postings at lot more
  >  annoying
  > e   than top-postings. But then that's probably just me.
  >>>> It's not just you.  Much as I am annoyed by top-posting, I am much
  > w  >>> more so by people who top-post at the bottom.  Hey, did I say
  > o  >>> something stupid?  No -- think about it.  These guys do exactly the
  > r  >>> same thing as top-posters, except it is much worse because the
  > s  >>> actual text they wrote is harder to find.
  > t  >>>
  >>>> --

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Import LDAP data to a Postgres database

[Andrej Ricnik-Bay]

On 12/6/07, Marco Curtolo <[EMAIL PROTECTED]> wrote:
>  Hi, my question is this: it is possible to query, using SQL, an LDAP server
> and put these data to a table of a Postgres database (under linux) ???
I don't know of any LDAP server implementations that can
be queried via SQL, and getting LDAP tree data into any
RDBMS can be done, but it won't be trivial once you get
to tree objects that have more than one value per attribute,
i.e. you'll have to map those attributes into separate tables.




> Thanks to all.
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Sharing static data among several databases

[Andrej Ricnik-Bay]

On Nov 19, 2007 12:29 PM, Robert James <[EMAIL PROTECTED]> wrote:
> Comedy aside, this makes a lot of sense:
> The shared data has nothing private in it at all - it's chemical info.
> Sharing it is no worse than sharing the application code, or the OS's
> libraries.  It's the customer's data which needs to be isolated.
I appreciate that.  But realistically if you had locked information isolation
down via permissions and appropriate views the information for each
customer would be as safe as it would using separate databases or
even servers.


Cheers,
Andrej

P.S.: I assume this was meant to go to the list, not to me as an individual;
try reply-all for this list.
-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] Sharing static data among several databases

[Andrej Ricnik-Bay]

On Nov 19, 2007 11:39 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> [ shrug... ] If your lawyers insist on that, wouldn't they also object
> to all customers linking to the same copy of the shared data?  They
> should, if they know what they're about.
You're implying that that lawyers understand what database, schema
and shared data are ... ?


> regards, tom lane
Cheers,
Andrej

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Syntax error in a large COPY

[Andrej Ricnik-Bay]

On 11/8/07, Collin Kidder <[EMAIL PROTECTED]> wrote:

> I'm with Thomas. I think that, while inline posting is a good thing,
> bottom posting is dead stupid and wastes my time.
Just as bad as top-posting, really.

> It is far easier to
> follow a thread with top posting as the relevant text is right there at
> the top ready to be read.
The relevant bit being what?  Two lines dangling loosely
at the top of a mail?

You omitted the crucial bit here:
"It is far easier FOR ME WITH MY CURRENT MAIL CLIENT
to follow a thread with top posting ..."
If that's good enough reason for you to ignore RFCs and
complain about the habit on this list, by all means, there's
no point in arguing. But we can flog the dead horse some
more 


> No, just not everyone agrees with your viewpoint on this topic. Top
> posting has it's place and some of us prefer it.
But they could just adhere to the "law of the land", or "when in
Rome, ... " practice instead of kicking off fuss.  And with my
"mail client" top-posting has no place.  Let's just stick to good
old standards.

[ ... offensive material removed ... ]
> And so... with that my view is out there. I hate bottom
> posting. But I for one will do it to keep the peace.
You were actually using the appropriate interleaved quoting
style, not bottom posting (minus the 'trimming', mind you).
At least get your terminology right. ;D



Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Npsql is much faster than ODBC ?

[Andrej Ricnik-Bay]

On Nov 7, 2007 2:40 PM, Rainer Bauer <[EMAIL PROTECTED]> wrote:

> That's nice to hear. But I respect licences as they are and the ODBCng driver
> is licenced under the GPL.
That doesn't mean that you're not allowed to use it with commercial
applications;  it just means that you need to be happy to provide the
source for it on request.

> Rainer
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Using Postgres as a "embedded" / SQL Lite database on Windows

[Andrej Ricnik-Bay]

On 10/25/07, Craig Hawkes <[EMAIL PROTECTED]> wrote:

> There will really be two targets, replacing the existing single user
> solutions, and providing a larger solution with multi-user etc. There is
> however large base of similar code between these solutions, and it would be
> perferable if they could use the same back-end engine or something very
> simliar. I know some people will aruge that you should use the right tool
> for the job, and I guess I am tring to see if there is a right tool which
> will work for both these.
I guess you could be looking at an intermediate abstraction layer
that will allow your application to communicate with whatever database
that newly added tier can talk to.

> My main/only real hesiation with Postgres is around supporting non IT users,
> mainly around installation. I am keen to here peoples comments on this, and
> what steps could be taken to mitigate these.
The "immediate" option that springs to mind would be to offer
consultancy and installation support.


> Thank you for your comments
> Craig
Cheers,
Andrej

P.S.: Please, do not top post :} ... see my sig for reasons.



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Photos from the PostgreSQL Conference Fall 2007

[Andrej Ricnik-Bay]

On 10/23/07, Adrian Klaver <[EMAIL PROTECTED]> wrote:

> I figured the name tags took care of that.
Some of them I can't decipher, on several photos they're not visible at all...

Wish I had 20/20 vision. :}

> Adrian Klaver
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] Photos from the PostgreSQL Conference Fall 2007

[Andrej Ricnik-Bay]

On 10/22/07, Daniel Browning <[EMAIL PROTECTED]> wrote:
> The PostgreSQL Conference Fall 2007 was informative, fun, and well-executed.
> Thanks to Selena Deckelmann, Joshua Drake, and everyone else who made it
> happen. Here are my photos of the event:
>
> http://db.endpoint.com/pgcon07/
Now if one could put names to those faces ... :}


> Daniel Browning
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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] Importing MySQL dump into PostgreSQL 8.2

[Andrej Ricnik-Bay]

On 10/13/07, wido <[EMAIL PROTECTED]> wrote:
> hi! but what happens when somebody sent you a dump file and you can't
> convert the tables? all i have is a 116MB sql file, and i won't
> convert it by hand :P
And chances are no one on the list will do it for you,
either, specially not when you stick out your tongue
at them ...

Use sed or awk, then, or write a perl script...

Others have done similar things, and made their work available.
Have a search on freshmeat or gborg.


Cheers,
Andrej

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Default Ubuntu post-install Qs (PG v7.4)

[Andrej Ricnik-Bay]

On 10/11/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
>
> 1)  Am I right when I assume an init.d type of start/kill scenario is used?
Aye


> 2)  The ps -ef shows the process:
>  /usr/lib/postgresql/7.4/postmaster -D
> /var/lib/postgresql/7.4/main
>  postgres:  stats buffer process
>  postgres:  stats collector process
> I see no logfile explicitly defined.  Where is that specified?
Have a look in
/etc/postgresql/7.4/main/postgresql.conf


> 3)  In /var/log/postgresql I am getting logging, but not enough.  How can I
> get more details?
See above.  Specifically postgresql.conf


> Thank you!
>
> Ralph Smith
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] using COPY, .CSV and ¿catalog?

[Andrej Ricnik-Bay]

On 10/1/07, pere roca ristol <[EMAIL PROTECTED]> wrote:
>   Hi everybody,

>   I want to enter a .CSV file using COPY comand and plpgsql.
>   It enters latitude,longitude and some data. In the CSV data there is no
> field (such as "user_name" or current_time) that allow distinguish future
> queries for different users (ex: select x,y from table where user_name=z;
> after entering lat,lon I would like to update the_geom in  another table
> using the lat,lon of ONLY this user).

>   I could update this kind of data ("user_name") using php but next user
> could not enter his data by COPY (it only lets fill the destination table if
> ALL the fields are the same as the CSV or text file).
I'm not a 100% certain I understand what you're trying
to achieve, but to me this looks like a mis-use?  Why
not use the relational features of your RDBMS and just
pick a location from a table created once via a unique
value you assign during (or after) the COPY?



>   Thanks,
>   Pere
Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] an other provokative question??

[Andrej Ricnik-Bay]

On 9/9/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:

> Hey!  Some of us just figured out how to pronounce PostgreSQL properly.
Postgreh SeeQuell??

/me ducks

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Debian problem...

[Andrej Ricnik-Bay]

On 9/12/07, Tino Wildenhain <[EMAIL PROTECTED]> wrote:

> Alternatively you could use XFS but I'm not sure if it performs
> better on failing hardware. I guess not.
Actually I've seen anecdotal evidence that XFS with its
aggressive write-caching has caused data-loss in the
event of power-failures.

I'm not certain how sensible Reiser, which is optimised
for efficiency with small files, would be for a postgres
data directory in terms of performance.  ext3 or jfs
maybe?


> Regards
> Tino
Cheers,
Andrej

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Hardware recommendation: which is best

[Andrej Ricnik-Bay]

On 9/12/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> Just to confirm -- why do you say "[Opteron] will have 2X as many
> disks"? In the dual-Opteron setup above I have 2 hard disks with
> RAID1, whereas in the single-Xeon quad-core setup I have 4 disks with
> RAID 10.
He didn't say that.  Read his comment again.  He said
the opteron may have a lead in terms of CPU/RAM performance,
but that the ASUS will have double the disk which may more than
make up for that.


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Ubuntu libraries needed

[Andrej Ricnik-Bay]

On 9/11/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
> I have a new install of 7.4 Ubuntu, and I'm looking for some advice on where
> to get the libraries I need for the source configure and install to work.
> Does anybody know off the top of their head where to look?
You're not missing libraries (maybe you are, you haven't gotten
that far yet).  Check config.log to find what exactly the script
was trying to do when it failed.


> Thanks!
cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Query with "like" is really slow

[Andrej Ricnik-Bay]

On 9/8/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:

> > Heisenberg would agree!
> I'm not entirely sure what Schrödinger would think about it.
He'd kill Heisenberg's cat?

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Data Warehousing

[Andrej Ricnik-Bay]

On 9/3/07, Rob Kirkbride <[EMAIL PROTECTED]> wrote:

> I am on a Linux platform but I'm going to need some pointers regarding
> the cron job. Are you suggesting that I parse the dump file? I assume I
> would need to switch to using inserts and then parse the dump looking
> for where I need to start from?
The question is: how complex is the data you need to
extract?  I guess where I was heading was to run a
select with the interval Scott described from psql into
a file, and then copy-from that into the analysis database.

However, if the structure is more complex, if you needed
to join tables, the parsing of a dump-file may be an option,
even though (always retaining a weeks worth) might make
that into quite some overhead.


Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Data Warehousing

[Andrej Ricnik-Bay]

On 9/3/07, Rob Kirkbride <[EMAIL PROTECTED]> wrote:

> We're using hibernate to write to the database. Partitioning looks like it
> will be too much of a re-architecture. In reply to Andrej we do have a
> logged_time entity in the required tables. That being the case how does that
> help me with the tools provided?
>
> Might I have to write a custom JDBC application to do the data migration?
That would be one option :}

If the server is on a Unix/Linux-platform you should be able
to achieve the result with a reasonably simple shell-script
and cron, I'd say.


> Rob
Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Data Warehousing

[Andrej Ricnik-Bay]

On 9/3/07, Rob Kirkbride <[EMAIL PROTECTED]> wrote:

> So basically I need a dump/restore that only appends new
> data to the reports server database.
I guess that will all depend on whether or not your
data has a record of the time it got stuck in the cluster
or not ... if there's no concept of a time-stamp attached
to the records as they get entered I don't think it can be
done.


> Thanks
>
> Rob
Cheers,
Andrej

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Install on 32 or 64 bit Linux?

[Andrej Ricnik-Bay]

On 8/29/07, Ralph Smith <[EMAIL PROTECTED]> wrote:
> Hello,
Hi



> Are there any recommendations on whether to install onto 32 vs 64 bit Linux?
> We're going to be using virtual machines.
In addition to Ron's question I'd be curious to hear about
the hardware platform and intended use of the database.

So far my gut tells me that high-performance databases
(or Linux/Unix servers with high average work-loads) don't
really offer themselves to virtualisation that well, specially
when you throw lots of disk I/O into the equation.


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] PG Seg Faults Performing a Query

[Andrej Ricnik-Bay]

On 8/22/07, Bill Thoen <[EMAIL PROTECTED]> wrote:
> How would you suggest I try to track down this problem?
> Any suggestions?
postgres version?
Operating system?
Anything in the log(s)?


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] I get a error msg when i try to connect to the DB

[Andrej Ricnik-Bay]

On 8/18/07, Rajaram J <[EMAIL PROTECTED]> wrote:
> Hi

> Yes I restarted postmaster after that but the problem still persists.
OK, Only looked at your file just now.  Those  are
meant to be the IP of your client.  You weren't meant
to put questionmarks into the file.

> Regards
> Rajaram
Cheers,
Andrej

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Enterprise Wide Deployment

[Andrej Ricnik-Bay]

On 8/14/07, john_sm <[EMAIL PROTECTED]> wrote:
> Hey guys, for an enterprise wide deployment, what will you
> suggest and why among - Red Hat Linux, Suse Linux and
> Ubuntu Linux, also, do you think, we can negotiate the
> support pricing down?
For all it's worth:  my personal experiences with RH support
were shocking, to say the least, and I can't fathom why
anyone would want to pay for it.

If you have in-house linux expertise, choose whatever they're
familiar with.  If you don't - find a local company that can give
you support and use what they're familiar with.  Just my 2 cents.


Cheers,
Andrej

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] I get a error msg when i try to connect to the DB

[Andrej Ricnik-Bay]

On 8/18/07, Rajaram J <[EMAIL PROTECTED]> wrote:
> Hi
>
> I tred this option but still i get the same message. Any more options that i
> can try.
And after that change you restarted the postmaster?


> Regards
> Rajaram J
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Postgresql INSERT speed (how to improve performance)?

[Andrej Ricnik-Bay]

On 8/14/07, Lim Berger <[EMAIL PROTECTED]> wrote:

> INSERTing into MySQL takes 0.0001 seconds per insert query.
> INSERTing into PgSQL takes 0.871 seconds per (much smaller) insert query.
>
> What can I do to improve this performance? What could be going wrong
> to elicit such poor insertion performance from Postgresql?
MySQL might not be writing the data straight out
to disk ... just a guess.


> Thanks.
Cheers,
Andrej

---(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] Automation Using Databases.

[Andrej Ricnik-Bay]

On 8/13/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
> There's a table in which data gets inserted. a simple table insert.
> I really can't leak out the purpose of the tool because I'm not supposed to
Well ... if you guys don't say what you're doing how
do you expect to get feedback of others who may be
doing the same thing?  Secret squirrels doesn't work
for me - sorry.


Cheers,
Andrej

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Automation Using Databases.

[Andrej Ricnik-Bay]

On 8/13/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:

> A record gets inserted in a table, trigger is fired (after insert) and this
> tirggers calls a function written in perl.
What kind of event inserts the record?  And what's the purpose of
the whole "automation tool"?

> Thanks alot in advance
> Jas
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Allowing LAN connections

[Andrej Ricnik-Bay]

On 8/9/07, Jonas Gauffin <[EMAIL PROTECTED]> wrote:
>  I've installed postgresql 8.2 on a windows vista machine and are trying to
> connect to it from another one.
> the server has ip 192.168.1.100 and the client 192.168.1.102
Before people start wrecking their brains on the postgres end
have you established that the VMs can see each other on the
network at all?

And ruled out Vista security playing tricks on you?



Cheers,
Andrej

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [SQL] Restricting columns by users

[Andrej Ricnik-Bay]

On 8/8/07, Ranieri Mazili <[EMAIL PROTECTED]> wrote:

> Exist something like it for postgresql?
I thought that's what views are for 


> Thanks
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/5/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> [...]
> 3. Mac OSX is ugly. I know I just made a bunch of people poo in their
> leather pants but it is. It is really ugly. I want clean, out of my way,
> customizable interface that works the way "I" work. Not the way the kool
> aide drinking fan boys of apple work.
And they're a complete nightmare to maintain or cater for in
a heterogeneous environment.  In my last employment I was
praying that they would just disappear from the surface of
the earth :D ... even Windows was easier to set-up./deal with
there  mind you, it *was* and AD shop, mostly.  Linux tied
in quite nicely.  The Macs ... AD integration, network integration
in general, stupid features around web-browsing, ...

/me shudders ...


> And with that beautiful flame... out!
>
> Sincerely,
>
> Joshua D. Drake
Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/3/07, Ben <[EMAIL PROTECTED]> wrote:
> > I'm curious:  which aspect of hardware administration
> > on a Linux box would require X (to be running)?  If I *really*
> It's not that it can't be done, it's that having a window environment can
> make things easier. (I find 24x80 pretty cramped, and I like large
> scrollback buffers.)
So I make my xterm on my workstation be 134x80, with a
line buffer of 8000 and then ssh into the server :}


> But like most computer efficiency questions, this whole thread tangent
> boils down to how much overhead you want your computer to dedicate to
> making your life easier at the expense of whatever else it was supposed to
> be doing.
True that.  Same for how many potential vulnerabilities
I'm willing to introduce for the sake of convenience. Not
that I'd find it convenient to drive the 40Km to the data-
centre to get physical access to the servers, mind you.


Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/3/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:

> they do, but experience has shown it is prudent to be able to
> administrate the hardware directly from the box.
I'm curious:  which aspect of hardware administration
on a Linux box would require X (to be running)?  If I *really*
needed applet such-and-such I could still run it easily, with
less overhead and w/o the X server even being installed on
the big iron from my desktop ...

ssh -X [EMAIL PROTECTED] whizbangGUItool

> I expect trend of desktop style management to continue
> (for the record, I would really prefer these devices to present
> html interfaces vs. java).
I'm afraid you're right - and it was what I dislike(d) most about
Oracles products.  The fact that 10g ships with the actual database
on a CD, and the admin stuff on DVDs.  Friggin nightmare.



> I'm actually recently converted from the 'anti-x' camp.  This is
> because I'm now using linux on a desktop and found it to be remarkably
> efficient but also was recently in a situation where I regretted not
> having it installed.  I completely understand and sympathize with the
> other side of the argument however.  I just don't care anymore, maybe
> I'm getting old :-).
Nuh mate, that's not old, it's inefficient (and too lazy to know
the ropes, relying on an "intuitive GUI")  ;} ...
/me ducks



> merlin

Cheers,
Andrej


-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
> What I do is install Gnome, "just in case" I need it for some reason
> (ie: opening many terminal windows at a higher res that I can alt+tab
> between).
ssh and/or screen ...


> Madi
Cheers,
Andrej



-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > > I think most of the virtual memory used by X is actually the map of the
> > > graphics card's memory AFAIK, so it's not as significant as you think.
> > That machine has an on-board chipset (i845) and has only 8MB
> > shared memory allotted to the card 
> You don't seem familiar with the meaning of VIRT in the memory
> allocation listing there.
That'll be Alvaro, maybe?  I'm quite aware of it, I just pointed out to him
that the VSIZE is NOT the devices memory mapping.

And I still think that running X on a server is unnecessary,
wasteful and potentially harmful.  The less you run, the less
can go wrong, the less potential exploits you have.


Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
> >   4735 root  18   0 52524 7204 4304 S  0.0  0.4   0:00.01 httpd
> >  4820 root  15   0  141m 6648 3140 S  0.0  0.4   0:00.64 X
> I think most of the virtual memory used by X is actually the map of the
> graphics card's memory AFAIK, so it's not as significant as you think.
That machine has an on-board chipset (i845) and has only 8MB
shared memory allotted to the card 


Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:

> A server with a GUI sitting on a login screen is wasting zero
> resources.  Some enterprise management tools are in java which require
> a GUI to use so there is very little downside to installing X, so IMO
> a lightweight window manager is appropriate...a full gnome is maybe
> overkill.  Obviously, you want to turn of the 3d screen saver :-)
So you don't consider RAM a resource? :)

I just went and rebooted my workstation, here's a top from
just after the reboot, with the box idling on the xdm login prompt.

top - 15:40:35 up 2 min,  1 user,  load average: 0.79, 0.60, 0.24
Tasks:  65 total,   1 running,  64 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   1800544k total,95164k used,  1705380k free,10408k buffers
Swap:   738856k total,0k used,   738856k free,53576k cached

  PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
  4735 root  18   0 52524 7204 4304 S  0.0  0.4   0:00.01 httpd
 4820 root  15   0  141m 6648 3140 S  0.0  0.4   0:00.64 X
  4739 nobody16   0 52660 5476 2540 S  0.0  0.3   0:00.00 httpd
  4740 nobody16   0 52660 5476 2540 S  0.0  0.3   0:00.00 httpd
  4741 nobody16   0 52660 5476 2540 S  0.0  0.3   0:00.00 httpd
  4742 nobody20   0 52660 5476 2540 S  0.0  0.3   0:00.00 httpd
  4743 nobody21   0 52660 5476 2540 S  0.0  0.3   0:00.00 httpd
  4756 postgres  18   0 35832 3696 3244 S  0.0  0.2   0:00.12 postmaster
 4762 root  16   0  4052 2872 1260 S  0.0  0.2   0:00.17 bash
  4737 root  18   0 10272 2640 1848 S  0.0  0.1   0:00.00 smbd
  4635 root  15   0  5920 2036 1400 S  0.0  0.1   0:00.03 cupsd
  4823 root  15   0  3748 1932 1452 S  0.0  0.1   0:00.01 xdm
  4646 root  15   0  6496 1896  920 S  0.0  0.1   0:00.00 sendmail


Also note that at that stage the X process has had the most
CPU cycles as well (which might be different if I could let it idle
for much longer - but I need to answer this e-Mail :D and gmail
doesn't work with lynx).


> merlin
-- Cheers,
Andrej

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Ron Johnson <[EMAIL PROTECTED]> wrote:

> > As an alternative viewpoint, I've been running the latest postgres on
> > Mac OS X Server 10.4, and it's been great for me.  It was my first time
> > using a server, and my first serious use of postgres (although I have
> > had a lot of previous unix experience.)  All the power of unix, all the
> > ease of the Macintosh (and it's server installation gives you lots of
> Pardon me for being the contrarian, but why does a server need a
> GUI?  Isn't that just extra RAM & CPU overhead that could be more
> profitably put to use powering the application?
Amen =)

Unnecessary waste of resources, plus artificial introduction of stuff
that can potentially make the machine go belly-up...  a dedicated
server should have the bare minimum install; as much as necessary
and as little as possible.

/me cringes at the idea of flying toasters slowing down a query ... :D


> - --
> Ron Johnson, Jr.
> Jefferson LA  USA
Cheers,
Andrej

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, John K Masters <[EMAIL PROTECTED]> wrote:

> I love Slackware but have eventually gone back to running my servers on
> Debian stable. Most of the Debian derivatives base on unstable to get
> the latest version of things but stable is rock solid and will never let
> you down. The advantage of Debian over Slackware is the ease of
> installation of new packages and updating the latest security patches.
I'll have to disagree :} on the "new packages" part.  While
apt-get'ing security fixes may be easier than manually ftp'ing
after having received the security alert ( I don't mind the mildly
more involved approach), I have to say that I find trying to
install packages that the maintainers didn't find necessary to
update (and no, just because I want a newer version of postgres
I don't necessarily want to dist-upgrade) I much prefer Slackware
*because* it doesn't have any dependency checks.




> Regards, John
Cheers,
Andrej

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
> Andrej,
Richard,


>How quickly people forget about the quiet distribution: Slackware. Ideal
> for servers, and great on desktops and portables, too, for those who know
> what they're doing.
Slackware is my preferred distro by a long stretch, I've
been a happy Slacker for over 6 years now;  but to someone
who's new to Linux as such, and wanting to get a production
system up and running quickly, I wouldn't recommend it.  A
few months of solid experience would be the minimum, I'd say.

> Rich
Cheers,
Andrej

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Linux distro

[Andrej Ricnik-Bay]

On 8/2/07, Reid Thompson <[EMAIL PROTECTED]> wrote:

> If it's a dedicated production server, look at UBUNTU 6.10 server.
> If you're planning to connect a monitor and run X-windows ( i.e. I
> bought a server, but i'm going to use it as a learning platform for
> LINUX in general also), i'd suggest either UBUNTU 6.10 or 7.04 desktop
> ( or, start with the 6.10 server, and use apt/synaptic/etc to add
> whatever additional packages you want )
No offense, but *if* you have to suggest Ubuntu you should be
suggesting 6.06 LTS, not any of the bleating, errrh, bleeding edge
and quickly fluctuating versions.  In a production server environment
people commonly aren't eager to update the whole OS every year. I
certainly wouldn't.

And if you settle for a stable server environment, I, too, would
rather go with the original debian than with ubuntu.  Not that
I particularly like either of them :}



Cheers,
Andrej

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PgAdmin GUI on the Linux Server

[Andrej Ricnik-Bay]

On 7/24/07, Ashish Karalkar <[EMAIL PROTECTED]> wrote:

Hello All,

Hi Ashish,


I am having PostgreSQL server 8.2.0 running on Redhat Linux .
I want to install PgAdmin GUI on the Linux Server.

Why would you want to introduce an extra load on
the server if the GUI will run just as fine on a client
side?  To install X (and have it running) on a database
server is (from my perspective as a system person) a
not very prudent move;  you use more RAM that would
be put to better use for database stuff, and you introduce
more potential flaws and security risks.


can anybody please guide me to the appropriate documantation and the
prerequisite required for the same .

That all said:
http://www.pgadmin.org/download/source.php


Thanks In Adavnce

With Reagrds
Ashish...

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(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: [GENERAL] Sylph-Searcher 1.0.0 released

[Andrej Ricnik-Bay]

On 7/19/07, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:


Yes, sylpheed does not need PostgreSQL. sylph-searcher is an
independent application and actually is consisted of two programs:
"syldbimport" and "sylph-searcher". syldbimport reads given mail files
and stores them into PostgreSQL database, indexing with
tsearch2. sylph-searcher does full text searching the database and
shows the result.

Thanks - that clarifies things.  Do you have plans to make an
optional integration of Sylpheed w/ postgres in the long run,
so one wouldn't have to do the import step before being able
to query the mail?



Cheers,
Andrej

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] Sylph-Searcher 1.0.0 released

[Andrej Ricnik-Bay]

On 7/18/07, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:

Hi,

Hi,



We are pleased to announce that Sylph-Searcher 1.0.0 is released.

Sylph-Searcher is a client program for searching mail boxes. Supported
mail box format is MH style, i.e. 1 mail = 1 file.

Sylph-Searcher uses tsearch2 for full text search, thus searching is
very fast. For example, ~300,000 mails or ~1.7GB DB is confortably
searched by Sylph-Searcher. Sylph-Searcher runs on UNIX/Linux/Windows.

Sylph-Searcher can be downloaded from:

http://sylpheed.sraoss.jp/en/download.html#searcher

Can you give a brief explanation of how sylpheed and
sylph-searcher correlate?  Sylpheed doesn't seem to
need postgres, sylph-searcher does ... ?



enjoy,
--
Tatsuo Ishii

Cheers,
Andrej

---(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] Hyper-Trading

[Andrej Ricnik-Bay]

On 7/11/07, Tom Lane <[EMAIL PROTECTED]> wrote:

Conventional wisdom around here has been that HT doesn't help database
performance, and that IBM link might provide a hint as to why: the
only item for which they show a large loss in performance is disk I/O.
Ooops.

Thanks Tom, great summary.  How does this compare with
SMP vs HT?


Personally I keep HT turned on on my devel machine, because I do find
that recompiling Postgres is noticeably faster ("make -j4" rocks on a
dual Xeon w/HT).  I doubt that's the benchmark of greatest interest
to the average *user* of Postgres, though.

Understood :)




regards, tom lane

Cheers,
Andrej

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Hyper-Trading

[Andrej Ricnik-Bay]

On 7/11/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:

On Tue, Jul 10, 2007 at 08:09:11PM +0200, Adrian von Bidder wrote:

> If your  operating system is able to schedule the threads/processes across
> CPUs, PostgreSQL will use them.

But notice that hyperthreading imposes its own overhead.  I've not
seen evidence that enabling hyperthreading actually helps, although I
may have overlooked a couple of cases.

I don't have any metrics of my own to present (nor do I care enough
to try and gather them), but there are a few tests with kind of varied
results, depending on WHAT one wants to use HT for.

Have a look at these:
http://www.ibm.com/developerworks/linux/library/l-htl/
http://www.2cpu.com/articles/41_6.html

In how far they're relevant to Postgres is left as an
exercise to the reader :}



A

Cheers,
Andrej


--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Hyper-Trading

[Andrej Ricnik-Bay]

On 7/10/07, Евгений Кононов <[EMAIL PROTECTED]> wrote:

Здравствуйте, Andrej.

Privet ;) ... not that I speak any Russian, really.


ARB> What OS are you using, and what's hyper-trading? Hyper threading
ARB> by any chance?  That's the OSes responsibility, not the databases.



I'm use Fedora Core 5, based on two Intel(R) Xeon(TM) MP CPU 3.16GHz
processors with Hyper-Trading technology. It means, that I use 4
virtual processors.
And, then I run postgreSQL, he use only one processor and work very
easy. I want to use postgreSQL on all my processors, but I don't know
how did it.

As I said ... if the OS supports those hyperthreaded CPUs
properly (I assume you're seing four CPUs in /proc/cpuinfo?)
and you fire up concurrent connections to the database
the OS should start spreading the load across CPUs.  It's
not the databases task (or capability) to make that decision.



Thank's !

Cheers,
Andrej

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] Hyper-Trading

[Andrej Ricnik-Bay]

On 7/7/07, Евгений Кононов <[EMAIL PROTECTED]> wrote:

Hello !

Hi Evgenij,



How to force POSTGRES to use all virtual processors at included
Hyper-Trading ?

What OS are you using, and what's hyper-trading? Hyper threading
by any chance?  That's the OSes responsibility, not the databases.


--
С уважением,
Евгений Кононов

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] What O/S or hardware feature would be useful for databases?

[Andrej Ricnik-Bay]

On 7/4/07, Ron Johnson <[EMAIL PROTECTED]> wrote:


"Enterprise-level" tapes can sit in storage for 7-15 years and then
still be readable.  Can a disk drive sit un-used for 7 years?  Would
the motor freeze up?  Will we still be able to connect SATA drives
in 7 years?

Same with a tape-drive, no?  I've seen so many standard changes
in drives and SCSI connectors ... if you don't keep spares of all the
equipment involved you'll face the same issue with tapes that you'd
face with SATA disks.



--
Ron Johnson, Jr.
Jefferson LA  USA




-- Cheers,
  Andrej
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows

[Andrej Ricnik-Bay]

On 7/2/07, Casey Crosbie <[EMAIL PROTECTED]> wrote:

Hello,

I am running the windows version of PostgreSQL 8.1 on my XP laptop. I
was trying the \cd command to change working directories [to import
query files to run] to the Documents and Settings directory (eventually
to the desktop) and I am getting an error where psql doesn't recognize
the gap between Documents and Settings.

The error states,

\cd : could not change directory to "C:/Documents": No such file or
directory.

Does anyone have any solutions on how to get around this issue with the
Documents and Settings directory?

Try enclosing Documents and Settings in quotes ...
"Documents and Settings"


Thank you in advance!



Casey Crosbie

Cheers,
Andrej


--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] greatest/least semantics different between oracle and postgres

[Andrej Ricnik-Bay]

On 6/30/07, Tom Lane <[EMAIL PROTECTED]> wrote:


Hmm ... I fear Oracle's behavior is more correct, because if any
argument is null (ie, unknown), then who can say what the greatest or
least value is?  It's unknown (ie, null).  But I suspect our behavior
is more useful.  Comments?

But in min/max scenarios NULL values are simply ignored, too,
no?


regards, tom lane

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] greatest/least semantics different between oracle and postgres

[Andrej Ricnik-Bay]

On 6/30/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:

The following is just FYI.
I was recently doing some stuff with greatest() on oracle (9.2.0.8.0) and
noticed that it returned null if ANY of the arguments were null. Out of
curiosity I checked postgres' definition of that function and found that it
returns null only if ALL of the arguments are null.

W/o knowing the SQL standard (just from what I'd perceive
as sensible) I'd say Oracle is broken. :}


-- Cheers,
  Andrej

---(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: [GENERAL] postgres and webmin

[Andrej Ricnik-Bay]

On 6/28/07, Danyelle Gragsone <[EMAIL PROTECTED]> wrote:

Now all I have to do is figure out how to login.  My old username and
password no longer works..

So you were able to connect to the database with webmin
before this change?  In that case you may want a similar
line for your own user account (rather than the postgres
one you just added) and make the authorisation whatever
you used in the host based statement.




thanks for helping!

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] postgres and webmin

[Andrej Ricnik-Bay]

On 6/28/07, Danyelle Gragsone <[EMAIL PROTECTED]> wrote:

Here is the entire file.



Could someone please take a look at this and tell me what I am doing
wrong.  Apparently I have something commented that I shouldn't but I
don't know what that is.  Sorry if I sound like a complete moron.. but
I am trying to learn.

The line you're missing isn't commented out, it's not there at
all.  Just add it to the file and restart postgres.

local   all postgres  ident sameuser

Those lines that have a "local" in them in your file are using
IP rather than the unix socket.



Thanks,
Danyelle

Cheers,
Andrej


--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster