On 6/3/07, Andrej Kastrin <[EMAIL PROTECTED]> wrote:
I am experiencing difficulty in trying to copy the file structure below
into PostgreSQL table:
||001||,||Classification||,||Economics||,||N||
||001||,||Classification||,||Trends||,||Y||
etc...
Although I can preprocess the input file with e.
On 6/13/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
Hi,
I have a Pl/Perlu function in which I have written an insert statement in
tbl_xyz.
If there's not foreign key in this table, insert works fine.
As soon as i make one of its fields refer to tbl_abc i.e field a in tbl_xyz
refering to
On 6/13/07, Porell, Chris <[EMAIL PROTECTED]> wrote:
Hi All,
[...]
the SQL in psql. The old server was a dual AMD opteron 2.6 GHz machine with
a RAID 5 array and 4GB memory. The new machine is a dual dual-core AMD
Opteron 2.6GHz with RAID 1 and 16GB memory.
[...]
On my new DB server, it ta
On 6/17/07, John Smith <[EMAIL PROTECTED]> wrote:
guys,
love both tools but php @ 2.5 *billion* google results is far more
popular than postgresql @ 25 million google results. *if* somebody's
gotto adapt it's not php. php does what it does best in a way that
stuffy academics don't get.
That's li
On 6/17/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> That's like saying that BSD or Linux should be more like
> Windows because there's more Windows than Linux stuff
> to be found on the web
You've not used KDE lately, have you? :)
That'll be right. I use fluxbox. :}
And while *ix migh
On 6/18/07, John K Masters <[EMAIL PROTECTED]> wrote:
I feel somewhat embarrassed to post this but I can't get past the first
post with Postgresql. I have installed onto a Debian testing system,
created a space for the database cluster on /usr/local/pgsql/data,
changed owner to postgres and chang
On 6/18/07, Jan Danielsson <[EMAIL PROTECTED]> wrote:
UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
Something like this?
http://www.joeconway.com/plr/
-- Cheers,
Andrej
---(end of broadcast)---
TIP 9: In versions below 8.0
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.
Chee
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 a
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 accoun
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 t
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 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 ge
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/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/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
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/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, ind
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 clien
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,
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 advantag
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 previou
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 ap
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 memo
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
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 HT
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
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
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/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 y
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 ad
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 w
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 perfo
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
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 s
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/22/07, Bill Thoen <[EMAIL PROTECTED]> wrote:
> How would you suggest I try to track down this problem?
> Any suggestions?
postgres version?
Operating system?
Anything in the log(s)?
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/ec
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 datab
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 th
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 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/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 (ma
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 hi
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 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
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
> pos
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
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
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/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
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 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 righ
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 d
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
On 12/6/07, Marco Curtolo <[EMAIL PROTECTED]> wrote:
> Hi, my question is this: it is possible to query, using SQL, an LDAP server
> and put these data to a table of a Postgres database (under linux) ???
I don't know of any LDAP server implementations that can
be queried via SQL, and getting LDAP
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
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 fro
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
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 rea
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 whic
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)
On 05/02/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote:
And a more generic version :}
8<8<8<8<8<8<8<8<
#!/bin/bash
# split.sh: a shell script and wrapper for some (g)awk to extract a single
#database out of a dump
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 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
n
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 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
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
t
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
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 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
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.
Yo
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
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.
Le
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, Alcate
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
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
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
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 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_dum
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,
o
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 ri
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
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 tha
On 01/04/2008, Steve Crawford <[EMAIL PROTECTED]> wrote:
> One advantage of using a consistent prefix is that when you have
> forgotten the exact name of a rarely used command and you are using a
> shell with readline support, "pg_" will bring up a list of
> available commands.
For any value of
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 stri
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 exper
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 do
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 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
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 instal
1 - 100 of 139 matches
Mail list logo
