Hello
I have FreeBSD5.1, postgresql 7.4.3, when i tried to:
initdb -D /usr/local/pgsql/data
i receive:
..
selecting default max_connections... 10
selecting default shared_buffers... 50
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data//base/1... FATAL:
A really good email from Cheryl Bender near a month ago:
Michael;
What version of FreeBSD? What version of PostGres?
On my server, running FreeBSD 5.1 and pg 7.3, the values are
kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 8192
kern.ip
Re:
i launched http://developer.postgresql.org/docs/pgsql/contrib/ipc_check/:
-bash-2.05b# ./ipc_check.pl -B 64
shared memory enabled: 32768 kB available
no changes to kernel required for a "-B 64" setting
==
and my:
bash-2.05b# sysctl -a |grep shm
kern.ipc.shmmax: 3
Hello list,
On Thu, Jul 01, 2004 at 01:55:19PM -0400, Tom Lane wrote:
> Jean-Christophe Weis <[EMAIL PROTECTED]> writes:
> > The variable PGDATA2 is set and marked for export in the root shell where I
> > start the server, but it is not passed into the server's environment.
>
> No, because the s
Just wondering--is it possible to dump on a temporary table?
Cheryl Bender
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of mike g
Sent: Thursday, July 01, 2004 11:11 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Dumping partial data
[EMAIL PROTECTED] writes:
> could not create semaphores: No space left on device
> DETAIL: Failed system call was semget(1, 17, 03600).
> HINT: This error does *not* mean that you have run out of disk space.
> It occurs when either the system limit for the maximum number of
> semaphore se
I have all of these on my server, but postgres does not fail when using
semaphores. What happens when you 'gmake check'?
Thanks,
Corey
[EMAIL PROTECTED]
Hello
i have:
create table student(
id SERIAL NOT NULL,
name VARCHAR(35) NOT NULL,
primary key (id)
);
and when i try to insert like this:
insert into student (name) values('me');
i receive error:
ERROR: duplicate key violates unique constraint "student_pkey"
W
I restarted computer and it's working fine:)
I had too small kern.ipc.semmns: 60, maybe some applications did not free
semaphores (?).
Thanx all for help.
[EMAIL PROTECTED] wrote:
>
> Hello
> i have:
> create table student(
> id SERIAL NOT NULL,
> name VARCHAR(35) NOT NULL,
> primary key (id)
> );
>
> and when i try to insert like this:
> insert into student (name) values('me');
> i receive error:
> ERROR: duplic
On Fri, Jul 02, 2004 at 19:22:17 +0200,
[EMAIL PROTECTED] wrote:
> Hello
> i have:
> create table student(
> id SERIAL NOT NULL,
> name VARCHAR(35) NOT NULL,
> primary key (id)
> );
>
> and when i try to insert like this:
> insert into student (name) values('me
The serial datatype creates a sequence in the background. So, in your
example, you'll have a sequence called "student_id_seq". Your sequence was
probably reset, dropped/created, or whatever, to cause it to feed IDs back
that already exist in your table.
On July 2, 2004 10:22 am, [EMAIL PROTEC
Never mind--answered my own question.
You can dump from a temporary table, which provides Hanan another way to
dump a subset of data.
Use CREATE TEMPORARY TABLE as select
Cheryl Bender
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bender, Ch
i found the problem:
sys=> create table test2(
sys(> id serial,
sys(> name varchar(10),
sys(> primary key(id)
sys(> );
NOTICE: CREATE TABLE will create implicit sequence "test2_id_seq" for
"serial" column "test2.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test2_pkey"
fo
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Bender, Cheryl") wrote:
> Just wondering--is it possible to dump on a temporary table?
The temp table is only visible inside the context of the transaction
under which it was created.
A pg_dump session will create an independent tra
[EMAIL PROTECTED] wrote:
i found the problem:
sys=> insert into test2 values(1,'myname');
INSERT 18765 1
sys=> insert into test2 (name) values('myname2');
ERROR: duplicate key violates unique constraint "test2_pkey"
sys=>
Why is it so ?
Because you explicitly put in 1:
values(1,'myname')
and t
On Fri, Jul 02, 2004 at 21:40:02 +0200,
[EMAIL PROTECTED] wrote:
> i found the problem:
>
>
>
> sys=> create table test2(
> sys(> id serial,
> sys(> name varchar(10),
> sys(> primary key(id)
> sys(> );
> NOTICE: CREATE TABLE will create implicit sequence "test2_id_seq" for
> "serial" column
[EMAIL PROTECTED] wrote:
> i found the problem:
>
>
>
> sys=> create table test2(
> sys(> id serial,
> sys(> name varchar(10),
> sys(> primary key(id)
> sys(> );
> NOTICE: CREATE TABLE will create implicit sequence "test2_id_seq"
> for "serial" column "test2.id"
> NOTICE: CREATE TABLE / PRIMA
hi,
Is it possible to run postgreql on redhat 7.3/9.0
32mb 1gb scsi system? without x of course.
thanks
hi,
Is it possible to run postgreql on redhat 7.3/9.0 32mb 1gb scsi system?
without x of course.
thanks
---(end of broadcast)---
TIP 8: explain analyze is your friend
I see what you're saying. I thought it had worked, but when I looked at
the dump file there was no data. Thanks.
Cheryl Bender
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher
Browne
Sent: Friday, July 02, 2004 2:15 PM
To: [EMAIL PROTECTED]
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] wrote:
> Hello
> i have:
> create table student(
> id SERIAL NOT NULL,
> name VARCHAR(35) NOT NULL,
> primary key (id)
> );
>
> and when i try to insert like this:
> insert into student (name) values('me
Am 2004-07-02 17:00:09, schrieb Paul Gimpelj:
>hi,
>Is it possible to run postgreql on redhat 7.3/9.0 32mb 1gb scsi system?
>without x of course.
>
>thanks
I think, with RedHat a little bit to much for the memory...
Exept you know, how to strip down this pig.
I use Debian GNU/Linux 3.0r2 with a
Hi,
I need to query a table with column name having
special characters ":", "@", "/", for example:
ab:cde12n/[EMAIL PROTECTED]
When performing a select on this column I get this
error:
ERROR: parser: parse error at or near ":"
Any suggestions how to escape these special
characters?
thanks
rk
On Fri, 2 Jul 2004, Rahul k wrote:
> I need to query a table with column name having
> special characters ":", "@", "/", for example:
> ab:cde12n/[EMAIL PROTECTED]
You'd need to double quote the name on creation and on any usage of the
name (for example in a select list or expression) in SQL stat
On Fri, Jul 02, 2004 at 17:00:09 -0400,
Paul Gimpelj <[EMAIL PROTECTED]> wrote:
> hi,
> Is it possible to run postgreql on redhat 7.3/9.0 32mb 1gb scsi system?
> without x of course.
I have run Postgres on Redhat 6.x with only 32MB of memory. It was awfully
slow though. Your main problem is goi
26 matches
Mail list logo
