Najib Abi Fadel wrote:
Dear all,
i was reading the postgres docs concerning the
Database Physical Storage. I found that the
information present there is not enough to satisfy my
curiosity.
Are there any documentation out there that describes
in more details the Database Physical Storage of
Najib Abi Fadel wrote:
Concerning the 8KB page size, as i understood postgres
Page Size is different from the file system Block
size.
If the system block size is 4kB are there any
mechanism that guaranties that a postgres page is
stored on 2 adjacent file system blocks ?
That's the job of the
Concerning the 8KB page size, as i understood postgres
Page Size is different from the file system Block
size.
If the system block size is 4kB are there any
mechanism that guaranties that a postgres page is
stored on 2 adjacent file system blocks ?
Cause otherwise performance may suffer since
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 5 March 2008 0:29
To: Joris Dobbelsteen
Cc: Gregory Stark; Scott Marlowe; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Planner: rows=1 after similar to
where condition.
Joris Dobbelsteen [EMAIL
Dear all,
I implement database in my faculty using Postgre. I have a problem
with ctid in my tables. Let say, i have table STUDENT with #STU
as the primary key. I don't know what happend in this table, some
rows have exactly the same value ( i also have set the #STU as unique).
After tracing the
Hi,
Conor McTernan schrieb:
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
[...]
Does anyone know of any commercial or open source software that will do this?
Datastudio (www.aquafold.com) also has a tool to build ER diagrams.
It is a commercial
On Thu, Mar 06, 2008 at 05:40:00PM +0700, Achmad Nizar Hidayanto wrote:
Dear all,
I implement database in my faculty using Postgre. I have a problem
with ctid in my tables. Let say, i have table STUDENT with #STU
as the primary key. I don't know what happend in this table, some
rows have
Achmad Nizar Hidayanto [EMAIL PROTECTED] writes:
I implement database in my faculty using Postgre. I have a problem
with ctid in my tables. Let say, i have table STUDENT with #STU
as the primary key. I don't know what happend in this table, some
rows have exactly the same value ( i also have
Hi all,
I've successfully converted a huge mssql ddl to postgres 8.1.9 - I
could upgrade if need be. We run both db's for our app depending on
the customer. We have a new feature, storing serialized java objects
in the db, and I'm having trouble with on this insert:
INSERT INTO
robert, 06.03.2008 15:32:
Hi all,
I've successfully converted a huge mssql ddl to postgres 8.1.9 - I
could upgrade if need be. We run both db's for our app depending on
the customer. We have a new feature, storing serialized java objects
in the db, and I'm having trouble with on this insert:
Hi,
I encountered an odd behaviour when I tried to delete a record.
I have two tables z_base and z_ul. z_base's primary key is isin
which is referenced by z_ul.
select count(*) from z_base where isin = 'DE000DB3BTR9';
count
---
1
select count(*) from z_ul where isin = 'DE000DB3BTR9';
[EMAIL PROTECTED] writes:
So there is no record in z_ul that references z_base with isin
'DE000DB3BTR9', but when I do:
delete from z_base where isin = 'DE000DB3BTR9';
ERROR: update or delete on table z_base violates foreign key
constraint z_ul_isin_fkey on table z_ul
DETAIL: Key
Ralph Smith wrote:
And should be easier to find in the manual!
I've looked in many related chapters of the 8.2 manual for a way to
find out
WHY a specific user has access to a database.
Chapter 5Data Definition
Chapter 18 Database Roles Privileges
Chapter 20 Client Authorization
Thomas Kellerer [EMAIL PROTECTED] writes:
robert, 06.03.2008 15:32:
I've successfully converted a huge mssql ddl to postgres 8.1.9 - I
could upgrade if need be. We run both db's for our app depending on
the customer. We have a new feature, storing serialized java objects
in the db, and I'm
Ralph Smith wrote:
So am I to assume that there is no way to query just what privs a
user/role has on an object, anything, from a DB to an index?
Well, obviously you can see what permissions an object has - \dp from
psql. See the manual for details. Run psql with -E if you want to see
the
On Mar 6, 2008, at 11:52 AM, Ralph Smith wrote:
Ralph Smith wrote:
And should be easier to find in the manual!
I've looked in many related chapters of the 8.2 manual for a way to
find out
WHY a specific user has access to a database.
Chapter 5Data Definition
Chapter 18 Database
It's Version 8.3.
Both columns are of a user defined datatype which is a varchar(12)
with a special check.
I already did a REINDEX but it didn't help.
On 6 Mrz., 18:27, [EMAIL PROTECTED] (Tom Lane) wrote:
What PG version is this? Are the two columns of identical datatypes?
(I'm wondering
Hi,
I am having trouble installing PostgreSQL on Windows 2000 Server. When I
installed it the Services would not start so I could not complete the
install.
I granted the windows postgres account Log On as a Service and Log on
Locally permissions. Now when I try to install I get an error say the
Hello everyone :-) ,
I've just started to get to grips with
pgsql and am facing a small issue. I would appreciate any pointers /
ideas about how to get around it :-) .
When I installed FC8 on my machine, I installed the pgsql package via
the package installer, and
Why are there too many to fix with ALTER?
Use SQL and the data dictionary to generate the DDL and pipe it into
psql (or spool it to disk and use that file as a sql script):
psql your_db_name -t -c select 'alter table '||t.tablename||' rename
\'||c.column_name||'\ to
I'm getting the back end closing connections early for some reason.
Here is an exception report from my servlet. This first started
happening with my instance of Trac, but now it's happening to my Java
apps too. I hope someone can shed some light on what is going on
here.
Alex
HTTP Status 500
Ok - lookint at the pg log, it appears that the server process is seg
faulting :(. This might conceivably be my fault. I have 3 stored
procedures written in C, but they've been on the server for months,
and unless I didn't deploy them correctly originally I don't think
it's them.
I'm thinking I
On 3/6/08, Alex Turner [EMAIL PROTECTED] wrote:
I'm getting the back end closing connections early for some reason.
Here is an exception report from my servlet. This first started
happening with my instance of Trac, but now it's happening to my Java
apps too. I hope someone can shed some
Ok - the connection closed thing is happening a lot, but not much is
going into pg_log...
Alex
On Thu, Mar 6, 2008 at 4:03 PM, Douglas McNaught [EMAIL PROTECTED] wrote:
On 3/6/08, Alex Turner [EMAIL PROTECTED] wrote:
Ok - lookint at the pg log, it appears that the server process is seg
Alex Turner wrote:
I'm getting the back end closing connections early for some reason.
Here is an exception report from my servlet. This first started
happening with my instance of Trac, but now it's happening to my Java
apps too. I hope someone can shed some light on what is going on
here.
Sometimes I'm getting LOG: unexptected EOF on client connection
Alex
On Thu, Mar 6, 2008 at 4:06 PM, Alex Turner [EMAIL PROTECTED] wrote:
Ok - the connection closed thing is happening a lot, but not much is
going into pg_log...
Alex
On Thu, Mar 6, 2008 at 4:03 PM, Douglas McNaught
Ok - more info
I turned on connection logging a few other things, and normaly I get
something like this:
LOG: 0: connection authorized: user=postgres database=trend
LOCATION: BackendInitialize, postmaster.c:3097
LOG: 0: disconnection: session time: 0:00:00.004 user=postgres
On 3/6/08, Alex Turner [EMAIL PROTECTED] wrote:
Ok - lookint at the pg log, it appears that the server process is seg
faulting :(. This might conceivably be my fault. I have 3 stored
procedures written in C, but they've been on the server for months,
and unless I didn't deploy them
Alex Turner wrote:
Ok - lookint at the pg log, it appears that the server process is seg
faulting :(. This might conceivably be my fault. I have 3 stored
procedures written in C, but they've been on the server for months,
and unless I didn't deploy them correctly originally I don't think
it's
Alex Turner [EMAIL PROTECTED] writes:
I'm thinking I need a core file.
Yeah.
I'm guessing I just restart
postgresql from a user whos core file size limit is set to non zero?
Probably won't help if your start script does su postgres as most do.
What I'd try is putting the ulimit command in
I did a pg_ctl start from the postgres user... is that gonna work, or
does pg_ctl do an su?
Alex
On Thu, Mar 6, 2008 at 4:34 PM, Tom Lane [EMAIL PROTECTED] wrote:
Alex Turner [EMAIL PROTECTED] writes:
I'm thinking I need a core file.
Yeah.
I'm guessing I just restart
postgresql
[EMAIL PROTECTED] writes:
It's Version 8.3.
Both columns are of a user defined datatype which is a varchar(12)
with a special check.
You mean a DOMAIN, or you mean a special datatype with custom C code?
If the latter, I'd suspect the C code. 8.3 has more stringent coding
rules for
newbiegalore [EMAIL PROTECTED] writes:
When I use this command $ service postgresql initdb nothing really
happens. The display says, initializing database and then nothing.
I've waited for 10 minutes at a stretch and CPU/memory utilization
doesn't seem to be going out of the window implying
Tony Cade skrev:
select relfilenode from pg_class where relname='rates'
update pg_attribute set attname=lower(attname) where attnum 0 and
attrelid= ( from above query)
Instead of the second one, do
SELECT
'ALTER TABLE rates RENAME COLUMN ' || attname || ' TO ' ||
lower(attname) ||
Robert, would you email us the patch? Thanks.
---
Robert Haas wrote:
We require that all submissions conform to the Postgres BSD license,
but we are not picky about requiring paperwork to prove it. Just put
the same
I have updated the docs by changing a few words, patch attached.
---
Simon Riggs wrote:
On Thu, 2007-04-19 at 15:48 -0500, Thomas F. O'Connell wrote:
If we take a backup of the standby server's files while it is
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 7 Mar 2008 15:01:11 +1300
Andrej Ricnik-Bay [EMAIL PROTECTED] wrote:
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
Ralph Smith wrote:
Ralph Smith wrote:
And should be easier to find in the manual!
I've looked in many related chapters of the 8.2 manual for a way to
find out
WHY a specific user has access to a database.
Chapter 5Data Definition
Chapter 18 Database Roles Privileges
On Mar 6, 10:12 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
newbiegalore [EMAIL PROTECTED] writes:
When I use this command $ service postgresql initdb nothing really
happens. The display says, initializing database and then nothing.
I've waited for 10 minutes at a stretch and CPU/memory
In article [EMAIL PROTECTED],
Richard Huxton [EMAIL PROTECTED] wrote:
% Some people used to suggest that a larger blocksize helped with specific
% disk systems disk block sizes. This means changing the setting in one
% of the header files and recompiling. It also means your database files
%
newbiegalore [EMAIL PROTECTED] writes:
hey! thanks for the reply :-). I looked into the pgstartup.log file
and everything seems to have worked perfectly with the msg at the end
saying Success: you can now start
but when I try to start it as a normal user using su normaluser my
computer
Anirban Banerjee [EMAIL PROTECTED] writes:
Wow! thanks for being super helpful, I will try it all out. Though I
distinctly remember turning off SElinux because it was giving me such a
headache even in permissive mode.
Yeah, Red Hat has spent quite some time now filing the rough edges off
Sorry, I was wrong. It's a charachter(12) not a varchar and it's a
domain.
The isins in z_ul either start with 'DE000' or with 'CH003'. PG seems
to compare only the first few charachters because when I set the
reference to CASCADE all z_ul entries that start with 'DE000' are
deleted. I tested it
44 matches
Mail list logo