Re: [GENERAL] In memory Database for postgres
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)
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] [OT] newsreader issue? (Was: bytea encode performance issues)
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] Problems Restarting PostgreSQL Daemon
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
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
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
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
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] Problems Restarting PostgreSQL Daemon
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] plperl installation
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
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
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?
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] Open Source CRM - Options?
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] Stored procedures in C
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] Schema design question
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...)
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_tabtab 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] Survey: renaming/removing script binaries (createdb, createuser...)
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 dir 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] Survey: renaming/removing script binaries (createdb, createuser...)
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] Need help to migrate pqSQL db 8.0.3 to 8.2.6
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] How to use database?
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] table size and storage location
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] Need help to migrate pqSQL db 8.0.3 to 8.2.6
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?
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: 8888SNIP8888 Message-ID: [EMAIL PROTECTED] Date: Thu, 20 Mar 2008 14:02:12 -0400 From: John Smith [EMAIL PROTECTED] To: PostgreSQL General pgsql-general@postgresql.org Subject: [GENERAL] [postgis-users] how many min. floating-points? Cc: PostGIS Users Discussion [EMAIL PROTECTED] 8888SNIP8888 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?
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] Dump format for long term archiving.
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] postgre vs MySQL
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] postgre vs MySQL
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] split pg_dumpall backups per database
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] Trigger to run @ connection time?
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 BEG 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] PHPs PDO, apache and never ending sessions
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
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
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.
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] Trouble running PostgreSQL server / Server must be started under certain locale.
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.
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] Understanding ps -ef command column
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?
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?
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
On 05/02/2008, Scott Marlowe [EMAIL PROTECTED] wrote:
And a more generic version :}
88888888
#!/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
echowhere database is the name of the database you want to isolate
echoout of the dump-file, inputfile is the file generated by
pg_dumpall
echofrom which you want to extract a single database, and
outputfile is
echothe 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
88888888
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] pg_ctl: cannot be run as root
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] Postgres with daemontools or similar
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] Reload only specific databases from pg_dumpall
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] Is PostGreSql's Data storage mechanism inferior?
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
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?
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!
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] Sharing static data among several databases
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] Sharing static data among several databases
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] Syntax error in a large COPY
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 ?
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
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
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] Photos from the PostgreSQL Conference Fall 2007
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] Importing MySQL dump into PostgreSQL 8.2
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)
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?
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] Debian problem...
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] an other provokative question??
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] Hardware recommendation: which is best
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
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
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
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] Data Warehousing
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
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] Install on 32 or 64 bit Linux?
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] I get a error msg when i try to connect to the DB
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] Enterprise Wide Deployment
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
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] Postgresql INSERT speed (how to improve performance)?
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.
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] Automation Using Databases.
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] Allowing LAN connections
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
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
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
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
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
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
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
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] Linux distro
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
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
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
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
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] PgAdmin GUI on the Linux Server
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
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] Sylph-Searcher 1.0.0 released
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] Hyper-Trading
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
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
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
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?
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
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
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] greatest/least semantics different between oracle and postgres
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] postgres and webmin
On 6/28/07, Danyelle Gragsone [EMAIL PROTECTED] wrote: I am sorry William but you lost me. I haven't disabled anything have I? Hard to say w/o seeing the WHOLE file. You're looking in the wrong section. What you need to make sure is that the line William posted *isn't* commented out. 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] postgres and webmin
On 6/28/07, Danyelle Gragsone [EMAIL PROTECTED] wrote: BEFORE # TYPE DATABASEUSERCIDR-ADDRESS METHOD #local is for Unix domain socket connections only host template1 postfix, postfixadmin all 10.2.0.202 255.255.255.0 trust # IPv4 local connections: hostall all 127.0.0.1/32 trust # IPv6 local connections: #hostall all ::1/128 trust AFTER # TYPE DATABASEUSERCIDR-ADDRESS METHOD local is for Unix domain socket connections only host template1 postfix, postfixadmin all 10.2.0.202 255.255.255.0 trust # IPv4 local connections: hostall all 127.0.0.1/32 trust # IPv6 local connections: #hostall all ::1/128 trust You mean like this? Firstly I fail to see the difference between the before and after. Secondly you don't have a line that begins with local. Add the following line to your file (was the stuff you just posted the entire file?) and restart postgres. local all postgres ident sameuser Thirdly you're still top-posting :} 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 and webmin
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
Re: [GENERAL] postgres and webmin
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/
