Dear my friends,
I want to install PostgreSQL in my Debian Lenny box.
I can't install PostgreSQL with aptitude:
aptitude install postgresql
.
It seems that the aptitude can not find the postgresql.
This is my '/etc/apt/sources.list'.
I have done aptitude update too. And it was completed
On Fri, 2009-09-11 at 13:17 +0700, Ricky Tompu Breaky wrote:
It seems that the aptitude can not find the postgresql.
Please post the exact output from the screen.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
We used power architect but not really satisfied with it.
Currently using Mogwai ERDesigner but still early to make an evaluation
even if seems really promising.
http://mogwai.sourceforge.net/?Welcome:ERDesigner_NG
Peter Hunsberger ha scritto:
Check out Power Architect. Pre-major release, it
Ricky Tompu Breaky wrote:
Dear my friends,
I want to install PostgreSQL in my Debian Lenny box.
I can't install PostgreSQL with aptitude:
aptitude install postgresql
.
What Peter said, but you might also want to do aptitude search
postgresql. That should find packages including
rr04 wrote:
I am an MIT student doing a project on schema-less database usage and would
greatly appreciate if you guys can fill out a quick survey on this (should
take 5 mins)
http://bit.ly/nosqldb
Hi,
even when I think that most of the people on this list will answer the
same way to your
On Fri, Sep 11, 2009 at 12:31 AM, Ehsan Haq ehsan_ha...@yahoo.com wrote:
Hi,
I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE
in my application (C++) using C libpq library. I can get the result set of an
OUT parameter having REFCURSOR data type through an explicit
Hi:
Is it possible to define a constraint that checks all elements of an array type
column?
Example...
create table foo (asset text, owner_uids text[]);
I also have a plperlu function that checks to see if a given uid is valid
(returns a 0/1). It's called validate_uid(text), This function
NTPT wrote on 11.09.2009 03:06:
Hi all. is there available some freeware and/or opensource visual
database design tool for postgresql ? Something like commercial microOLAP ?
thanx for help
I like Power*Architect although it does have some quirks.
I recently discovered another one, which
Hi all,
I have a FUNCTION queried like this:
SELECT * FROM f_authorize_check_query2('%{SQL-User-Name}','%{User-Password}'
[...];
Built this way:
CREATE FUNCTION f_authorize_check_query2(...) RETURNS radcheck
AS $_$
DECLARE
[...]
v_ret radcheck%ROWTYPE;
[...]
09/11/2009 05:53 PM, Rakotomandimby Mihamina:
Is SELECTing INTO a second time OK?
But I dont know how...
Any hint?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
+261 34 29 155 34
--
Sent via
On 11/09/2009 15:53, Rakotomandimby Mihamina wrote:
It returns only one row, like this:
++--+++---+
| id | UserName | Attribute | op | Value |
++--+++---+
| 1 | bartek |
On Fri, Sep 11, 2009 at 10:34 AM, Gauthier, Dave
dave.gauth...@intel.com wrote:
Hi:
Is it possible to define a constraint that checks all elements of an array
type column?
Example...
create table foo (asset text, owner_uids text[]);
I also have a plperlu function that checks to see
After updating to 10.6.1 this morning the postgresql 8.3 server (from
a macports installation) refuses to start.
It's stops with the message
FATAL: incorrect checksum in control file
Yesterday I was running postgresql server successfully the whole day
under 10.6 with no problems at all. I
Hi,
We are developing a web application that will work on Postgresql. My
doubt is about the hardware that I can use for postgresql.
What HW is more important to postgresql performance?
Assuming that the database will have some load, what hardware must i
buy?
Thanks
Best regards
--
Sent via
On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk gil.nunes.rese...@gmail.com wrote:
What HW is more important to postgresql performance?
Assuming that the database will have some load, what hardware must i
buy?
Generally, you put as much RAM as you can afford, and then buy the
fastest disks you
erik c...@classlibrary.net writes:
After updating to 10.6.1 this morning the postgresql 8.3 server (from
a macports installation) refuses to start.
It's stops with the message
FATAL: incorrect checksum in control file
Yesterday I was running postgresql server successfully the whole day
In response to Vick Khera vi...@khera.org:
On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk gil.nunes.rese...@gmail.com
wrote:
What HW is more important to postgresql performance?
Assuming that the database will have some load, what hardware must i
buy?
Generally, you put as much RAM as
Hi,
We are running Pg 8.2.6 on sparc-sun-solaris2.9 compiled by gcc 3.4.6.
We are planning a server software upgrade to Solaris 10 (binaries and
kernel, etc).
Has anyone done this, and were there problems when trying to start up
postmaster after the upgrade?
Thank you in advance,
Mike
--
How much reading? Writing? Concurrent transactions? How much data will
you have? These are some of the things you need to provide to get a
reasonable answer.
Psicopunk wrote:
Hi,
We are developing a web application that will work on Postgresql. My
doubt is about the hardware that I can use
On 11 Set, 17:59, vi...@khera.org (Vick Khera) wrote:
On Fri, Sep 11, 2009 at 6:01 AM, Psicopunk gil.nunes.rese...@gmail.com
wrote:
What HW is more important to postgresql performance?
Assuming that the database will have some load, what hardware must i
buy?
Generally, you put as much
How can i take some measurements to understand what bottlenecks will
appear?
For long-term / ongoing I'm very happy so far with a package called
munin. Google it and join their mailing list for help setting it up.
But it takes snapshots at 5 minute intervals and this is not configurable.
For
Purchase solid equipment and fairly current machines.
We buy referbished system at a fraction of the cost of new.
For example;
IBM 3650 with 8 x 300g SAS drives and controller, 4 slot dual with the
following specs. 16 gb memory.
model name : Intel(R) Xeon(R) CPU E5345
Dear Peter Eisentraut.
My aptitude still can not find it.
Please keep telling me.
Thank you very much in advance.
Here is the output of my postgres installation attempt with aptitude and
my current '/etc/apt/sources.list':
lenny:/etc/apt# dpkg-reconfigure gforge-db-postgresql
lenny:/etc/apt#
On Fri, Sep 11, 2009 at 12:35 PM, Chris Barnes
compuguruchrisbar...@hotmail.com wrote:
Purchase solid equipment and fairly current machines.
We buy referbished system at a fraction of the cost of new.
For example;
IBM 3650 with 8 x 300g SAS drives and controller, 4 slot dual with the
On Fri, Sep 11, 2009 at 3:53 PM, Scott Marlowe scott.marl...@gmail.com wrote:
For about $8000 more you can get a 16 drive machine with 146G drives
and same basic setup, which I would recommend over the 8 drive
machine. With 2 hot spares, and 2 in a mirror for the OS/xlog you
still have 12
Hi,
I have a loop of the form:
FOR rec IN SELECT code FROM staff WHERE shiftgroup = NEW.groupe ORDER
BY code LOOP
WHILE sdate = NEW.todate LOOP
SELECT INTO starty,endy,nday resumetime,closetime,nextday FROM
shifts WHERE shift = NEW.shift;
Hello Folks,
On windows 2003 server , if I try to run initdb with -D , -U ,
-A password --pwfile = password file options it fails.At the time of
try , I was logged in as Domain \ username . My aim is to initialize db
with using same domain user which is currently logged in. Same
Hi,
I still don't get. How can I get the varchar OUT parameter in the
application? For Example
CREATE OR REPLACE
Function getOutVarchar(outvarchar OUT varchar2) RETURN NUMBER
IS
BEGIN
outvarchar:='This is Out String';
RETURN 1;
END getOutVarchar;
iris= SELECT
Hello Folks,
So I have following problem as I logged in Windows 2003 with
domain\user. I am basically trying to create installer for postgres. So
I need to keep in mind that person who is going to install can be the
one who is currently logged in.
So I tried to change permissions
29 matches
Mail list logo