On Nov 27, 2006, at 11:19 PM, Doron Baranes wrote:
This is exactly what i am doing.
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
You have new mail.
# su - postgres
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
-bash-3.00$ id
uid=49500(postgres) gid=65434(postgres)
On Nov 30, 2006, at 5:15 AM, [EMAIL PROTECTED] wrote:
I have an Oracle DB, where my backup file is 280 GB and growing. I
also have a
lot of blob fields there. When i make a backup recover, the blob
fields are
there, and my boss is alive.
I want to know how postgresql's backup utilities deal
On Nov 27, 2006, at 10:41 AM, Tony Caduto wrote:
I then updated the postgresql.conf file with "listen_addresses =
'*' and changed the port from 5432 (currently being used for a 7.3
server) to 5435.
Have you tried setting the port back to default and see what happens?
Is it possible for you
If you're concerned about them, you might want to just use someone
else... I can think of at least 2 other companies that offer training
classes.
On Nov 27, 2006, at 2:40 PM, [EMAIL PROTECTED] wrote:
I've been tasked with administering one of our PostgreSQL databases
and
know little or no
Hi Again,
I posted earlier about a problem installing 8.1.5 on Windows XP Home. THat
message was delayed, so it likely will not
show up.
THe problem is occuring on execution of initdb. I skipped the cluster creation
in the installation so that I could run
it manually, but it made no difference
On Wed, 2006-11-29 at 14:39 -0600, Dave Bodenstab wrote:
> I guess one cannot create an index on an element of an array?
>
> test=> create table test ( ordinal int[] );
> CREATE TABLE
> test=> create unique index x1 on test ( ordinal[1] );
> ERROR: syntax error at or near ")" at character 45
> LI
Why does user big_daddy need to access everybody's data? Who is he?
What's his role? It seems like a big security problem waiting to
happen, but that's just me.
Uncle Sam :)
This is one of those fundamental problems you run into when you make a
design decision up front (user perms in th
I am trying to measure amount of data coming from Postgres DB to
application layer. Is there any tool/utility that can help to log all
results using JDBC driver? I would really appreciate your help on this.
Regards,
Ranjan
---(end of broadcast)---
On Thu, 2006-30-11 at 17:22 -0400, [EMAIL PROTECTED]
wrote:
> Date: Thu, 30 Nov 2006 12:48:53 -0600
> From: John McCawley <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Subject: Separation of clients' data within a database
> Message-ID: <[EMAIL PROTECTED]>
>
> ... I would assume there a
On 11/30/06, John McCawley <[EMAIL PROTECTED]> wrote:
I can't speak for wxPython etc., but regarding using QT from C++, your
speed of development depends on your C++ skills. I wrote a
full-featured Point of Sale system in Visual Basic that has been in
active use for about 4 years. The original
On Thu, 2006-11-30 at 14:07, John McCawley wrote:
> Maybe I'm not understanding what you're getting at, so I'll throw out an
> example:
I completely understand what you're saying, but I'm not quite getting
the reasons for it. For instance:
> HOWEVER, when user big_daddy logs into the applicati
On Thu, 2006-11-30 at 15:23 -0500, Bill Bartlett wrote:
> Is anyone aware of any issues with running PostgreSQL 8.0.4 on a Windows
> 2003 Server x64 system?
You will want to check the release notes for differences between 8.0.4
and 8.0.9 but except for the fact that PostgreSQL on win32 doesn't
cur
Is anyone aware of any issues with running PostgreSQL 8.0.4 on a Windows
2003 Server x64 system? (I know it's an old DB version that we will
eventually upgrade to 8.1.x or 8.2.x, but it's running on a production
system where for the immediate future I don't have the time to test on
any of the late
On Tue, Nov 28, 2006 at 03:40:09PM -0800, [EMAIL PROTECTED] wrote:
> Hi-
>
> I've run into a problem using Postgres 8.1 that has me stumped:
>
> I'm logged on as user 'postgres' and I can connect using the following
> command:
>
> bash$>psql
>
> However when I specify the host:
>
> bas
Maybe I'm not understanding what you're getting at, so I'll throw out an
example:
--
With my current architecture, smartlowe logs in, but his login is
handled at the application layer, so his database connection is simply
"foo". He inserts a hundred records in the invo
> It seems that this approach would suffer the same problem as the one I
> outlined in "1) Actually separate client data by table". I would have
> to modify the logic of my web app...My web app currently handles all of
> the data, regardless of company, so it would have to aggregate the data
> fro
On Nov 30, 2006, at 8:50 AM, Enrico wrote:
I already read your link and it is not specific for Postgres, I'm
searching for a
more specific document.
Just remove any devices you don't have on your machine, and remove
any "extras" like linux compat, older version compat, etc. You
probabl
On Thu, 2006-11-30 at 13:45, John McCawley wrote:
> Note that my in my current code, application-level permissions are
> completely detached from database permissions. The entire web app uses
> one user/pass to login to the database. The web app is used both by
> individual companies who can
Is it possible to have each user connect via different postgresql
account? if so, then you can use
alter user set search_path='common_schema','user_schema';
where common schema has the things that would be the same for each
instance of the app, and user_schema is the name of that user's schema.
Note that my in my current code, application-level permissions are
completely detached from database permissions. The entire web app uses
one user/pass to login to the database. The web app is used both by
individual companies who can only view their data, and also the
overseeing company who
search_path="$user" in postgresql.conf
and you create one schema for each user with the user name as name
Rodrigo
John McCawley wrote:
It seems that this approach would suffer the same problem as the one I
outlined in "1) Actually separate client data by table". I would have
to modify t
It seems that this approach would suffer the same problem as the one I
outlined in "1) Actually separate client data by table". I would have
to modify the logic of my web app...My web app currently handles all of
the data, regardless of company, so it would have to aggregate the data
from the
> I have been using PostgreSQL for years in my web apps, and so far in my
> career I have not had to deal with database-side permissions issues.
> i.e. when I have multiple clients, or hands on the data, everyone
> interfaces through my web app and I handle security there. The app
> enforces what
>>> On Thu, Nov 30, 2006 at 12:48 PM, in message
<[EMAIL PROTECTED]>,
John McCawley <[EMAIL PROTECTED]> wrote:
>
> 4) Create views for each client that filter the underlying table data
to
> only show them their data. The only database objects they would have
> read permission on are these view
I have been using PostgreSQL for years in my web apps, and so far in my
career I have not had to deal with database-side permissions issues.
i.e. when I have multiple clients, or hands on the data, everyone
interfaces through my web app and I handle security there. The app
enforces what data
I can't speak for wxPython etc., but regarding using QT from C++, your
speed of development depends on your C++ skills. I wrote a
full-featured Point of Sale system in Visual Basic that has been in
active use for about 4 years. The original development effort (screens,
grids, etc.) took about
> The big problem with all the solutions mentioned (besides Delphi,
> SharpDevelop etc) is that they
> take a LOT of time to develop complex GUI applications with.
>
> I looked at Python etc, but it would have taken me 10 times (or more)
> longer to create Lightning Admin
> using something othe
Ritesh Nadhani wrote:
Hello All
Sorry for the late reply. Been a little busy with my assignments.
I will try to answer all the queries in this mail.
The reason I don't want to develop the project in wxWindows or a C/C++
based toolkit is that in the end I would be able to compile a binary
Anot
On 11/30/06, Teodor Sigaev <[EMAIL PROTECTED]> wrote:
Fixed, thank you. Changes are commited in CVS, pls, try it (I think that
index
is corrupted, so you need to recreate it)
great. thanks. i will retry. full retry will take some time - i can
estimate that i will be able to reply tomorrow in
Did you 'vacuum analyze' after you did the update?
Make sure you have the correct indexes in place on your foreign keys.
Did you have fsync off on your previous installation?
Give some more details and I'm sure people will be able to give better advice
than me.
Regards,
Ben
""surabhi.ahuja"
Hello.
I have a db with a table that it has a two oid fields. in the next code
i insert a new row in the table with this oid fields but it crash.
This crash is when called the function SQLParamData that it return -1
why does it crash? any ideas?
int PgsqlImageDao::insertImage(Connection* conn, c
Terry Yapt wrote:
> Terry Yapt wrote:
>
> > Terry Yapt wrote:
> >
> > > I am trying to restore from a pg_dump. Pg_restore is doing some
> > > strange behaviour.
> > >
> > > If I open a CMD shell console and execute pg_restore, nothing is
> > > showed. If I try to do a "with sense" pg_restore,
I guess one cannot create an index on an element of an array?
test=> create table test ( ordinal int[] );
CREATE TABLE
test=> create unique index x1 on test ( ordinal[1] );
ERROR: syntax error at or near ")" at character 45
LINE 1: create unique index x1 on test ( ordinal[1] );
Terry Yapt wrote:
> Terry Yapt wrote:
>
> > I am trying to restore from a pg_dump. Pg_restore is doing some
> > strange behaviour.
> >
> > If I open a CMD shell console and execute pg_restore, nothing is
> > showed. If I try to do a "with sense" pg_restore, nothing is showed
> > in spite of I
Richard Broersma Jr wrote:
> > Is it possible to configure PostgreSQL so that a " LIKE 'a' " query
> > will match a 'รก' value, ie, make it accent-insensitive ?
>
> I forgot this was possible using regular expressions. I don't think it is
> possible using the LIKE
> syntax.
What a pity, I've found
Hi-
I've run into a problem using Postgres 8.1 that has me stumped:
I'm logged on as user 'postgres' and I can connect using the following
command:
bash$>psql
However when I specify the host:
bash$>psql -h localhost
or
bash$>psql -h hostname.domain.com
I get the following error:
Ritesh Nadhani wrote:
Also, IDEs like Delphi etc. are out of question as I cant afford to
buy the licenses.
You can get Turbo Delphi Explorer for free and the license
allows commercial development. It really is sweet.
Check it out here: http://www.turboexplorer.com/
The explorer version com
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> also, if what Martijn is saying is correct, wouldn't that make the
> LOAD command unsupportably dangerous?
If you have write access to a file that you can LOAD, then you can
already put garbage into the backend's memory space, so I don't see
this as a
Nevermind. I used:
OPEN test FOR EXECUTE 'SELECT a, b, c FROM tbl WHERE d IN ' values;
Nik wrote:
> I have a dynamic set of clauses that I would like to use in the cursor.
> Is there a way to achieve this using the "IN" clause and a string, or
> multiple "OR" clauses coupled with strings.
>
> Thi
On Wed, Nov 29, 2006 at 11:21:41PM +0100, Bernhard Weisshuhn wrote:
> LZO is pretty much rock solid. It is used in OpenVPN and supposedly was
> used for the communication with NASAs Mars Rovers Spirit and
> Opportunity, if that counts as trusted.
It's also GPL, which makes it a hard sell.
Have a
Fixed, thank you. Changes are commited in CVS, pls, try it (I think that index
is corrupted, so you need to recreate it)
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
-
>
> Obviouly you want to start with a machine with a much memory as you can
> afford,
> as fast a disk subsystem you can afford, and as powerful a CPU you can afford.
> Then rip a boot only CD, and do a minimal install with the ports collection.
Done
> FreeBSD 6.1 is pretty optimized already
> Hello,
>
> (Sorry for the cross-posting)
>
> Today, I have built PGDG RC1 SRPM; as well as RPMs for RHEL 4 and Fedora
> Core 6 packages for x86 and x86_64. They will be on main FTP site for
> testing in an hour. I hope to upload more packages for wide testing; but
> these should be enough at leas
Hello,
(Sorry for the cross-posting)
Today, I have built PGDG RC1 SRPM; as well as RPMs for RHEL 4 and Fedora
Core 6 packages for x86 and x86_64. They will be on main FTP site for
testing in an hour. I hope to upload more packages for wide testing; but
these should be enough at least for now.
RH
I reproduce a problem with small script:
print <5000 and i<40;
VACUUM FULL ANALYZE qq;
EOT
So, I'm digging now...
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
--
Teodor Sigaev <[EMAIL PROTECTED]> writes:
>> #1 0x080bc224 in PageDeletePostingItem (page=0xb28039a0 "\020",
>> offset=53719) at gindatapage.c:291
>> #2 0x080bf558 in ginDeletePage (gvs=0xbfc2ab80, deleteBlkno=29194,
>> leftBlkno=29059, parentBlkno=70274, myoff=351, isParentRoot=0 '\0') at
>>
Bill Moran wrote:
In response to Enrico <[EMAIL PROTECTED]>:
HI,
I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres
installed.
Where can I have any info about?
http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/kernelconfig.html
It appears as if English is not you
Enrico wrote:
HI,
I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres
installed.
Where can I have any info about?
Opimizing the FreeBSD kernel?
Obviouly you want to start with a machine with a much memory as you can afford,
as fast a disk subsystem you can afford, and as
Enrico wrote:
>> http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html
>>
>
> Hi Bill
> I already read your link and it is not specific for Postgres, I'm searching
> for a
> more specific document.
You'll probably want a lot of shared memory, but you can set that using
sy
Hi List !
I have some data that comes from a HTTP server.
Some characters are encoded with the HTML convention :
&#;
I'd like to replace these sequences with the 'real'
character, my database being encoded in UTF8.
I already found that to convert the decimal value to the
corresponding chara
> http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html
>
Hi Bill
I already read your link and it is not specific for Postgres, I'm searching for
a
more specific document.
Regards,
Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a
multi-bil
In response to Enrico <[EMAIL PROTECTED]>:
> HI,
> I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres
> installed.
> Where can I have any info about?
http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/kernelconfig.html
It appears as if English is not your primary langu
Hi,
I have an Oracle DB, where my backup file is 280 GB and growing. I also have a
lot of blob fields there. When i make a backup recover, the blob fields are
there, and my boss is alive.
I want to know how postgresql's backup utilities deal with blob fields...
Thanks,
-
On Thu, 30 Nov 2006 03:23:03 -0800 (PST), Ashish Karalkar <[EMAIL PROTECTED]>
wrote:
> Hello All,
>
> I am trying to add a new table to an running
> replication system.
>
Please stop posting Slony-I related questions to this list.
slony1-general is the more applicable list for this, see my
#1 0x080bc224 in PageDeletePostingItem (page=0xb28039a0 "\020",
offset=53719) at gindatapage.c:291
#2 0x080bf558 in ginDeletePage (gvs=0xbfc2ab80, deleteBlkno=29194,
leftBlkno=29059, parentBlkno=70274, myoff=351, isParentRoot=0 '\0') at
ginvacuum.c:268
Are you sure about your hardware? myoff
HI,
I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres
installed.
Where can I have any info about?
Thanks in advantage.
Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a
multi-billionaire by now ...oh look, he already is
[EMAIL PROTECTED] -
Hi,
What about cast to numeric?
select 6.1::numeric-6::numeric ;
?column?
--
0.1
(1 row)
Regards,
Kaloyan Iliev
Hengki Suhartoyo wrote:
Hi all,
I got problem in postgrsql 8.0 when subtraction in float8, this is my
query :
select 6.1::float8-6::float8
Result>>> 0.09
On 11/30/06, Teodor Sigaev <[EMAIL PROTECTED]> wrote:
gdb /usr/local/pgsql/bin/postgres your_core_file
If it's needed, change path to postgres file.
In gdb, type
# bt
and send output
sure, here you have:
$ gdb /home/pgdba/work/bin/postgres /home/pgdba/data/core
GNU gdb 6.3-debian
Copyright 20
Hello All,
I am trying to add a new table to an running
replication system.
For that i want to create new set but it is giving me
error.
slonik <<_EOF_
> create set (id=2, origin=1, comment='All qsweb
tables');
> _EOF_
:1: ERROR: syntax error at or near create
can anybody tell me how can i crea
On Nov 30, 2006, at 19:56 , Hengki Suhartoyo wrote:
I got problem in postgrsql 8.0 when subtraction in float8, this is
my query :
select 6.1::float8-6::float8
Result>>> 0.096
I need the result like natural subtraction is 0.1
Then use numeric instead of float. Float by its very
While I'm downloading your file, pls, do follow:
gdb /usr/local/pgsql/bin/postgres your_core_file
If it's needed, change path to postgres file.
In gdb, type
# bt
and send output
hubert depesz lubaczewski wrote:
hi,
i have been testing 8.2 rc1, while i got this problem.
base data:
linux, 32bit
And (indeed) that is exactly the answer that you received [within
DLB_DIG units of precision].
I guess that you will be happier with NUMERIC(precision, scale) because
the results of operations will be closer to what you expect.
Suggested reading:
http://www.physics.ohio-state.edu/~dws/grouplinks/
Hi all,
I got problem in postgrsql 8.0 when subtraction in float8, this is my query :
select 6.1::float8-6::float8
Result>>> 0.096
I need the result like natural subtraction is 0.1
Help me please
___
hi,
i have been testing 8.2 rc1, while i got this problem.
base data:
linux, 32bit, kernel: 2.6.18.3; debian
postgresql version:
PostgreSQL 8.2rc1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.5(Debian 1:
3.3.5-13)
problematic table is over 2gigabytes in size, and has several indices - one
Thanks for your repaly
I have done with that but facing the same problem.
Actually what i want to do is to add a table to a
already existing replication set.
firstly, I will have to create new set
secondly subscrib it .
and finaly merge it.
do i need to create this set in the same cluster into
Hi,
On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar wrote:
> create set (id=2, origin=1, comment='All tables');
>
> but it gives error
>
> syntax error near unexpected token `('
That command must be passed to slonik, not to bash.
Here is an example:
#!/bin/bash
slonik << _END_
cluster
I want to create new set,
I am running create set command as follows
create set (id=2, origin=1, comment='All tables');
but it gives error
syntax error near unexpected token `('
can anybody tell me where i am doing wrong
With regards
Ashish
_
67 matches
Mail list logo
