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
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
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
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
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
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,
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
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
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
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,
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
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
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.)
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
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
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
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
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
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. ;-)
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
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
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
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
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
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
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
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,
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%
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
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 :}
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
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:
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
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.
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
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
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
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?
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
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
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
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.
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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.
--
С
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?
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
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
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
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.
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
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
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
1 - 100 of 137 matches
Mail list logo