Rekha Ravi Pai wrote:
Hi,
I want to store confidential data. I created a user with createdb
permission.
How can I prevent others accessing tables created by this user?
if you don't grant privileges to other roles or users, then only the
table creator can access the created table.
--
Sent
On Sun, Mar 14, 2010 at 08:11:01PM -0400, Carlo Stonebanks wrote:
>
> Now THIS is a new one for me! I have no idea where to even start. Does
> anyone know how to look for the error? Below is the query and what I
> believe are the related log entries.
>
> Any help will be rewarded with heartfelt
On Mon, Mar 15, 2010 at 12:07 AM, Carlo Stonebanks
wrote:
> "PostgreSQL 8.3.6, compiled by Visual C++ build 1400"
>
> I see the log entries for 'loaded library
> "$libdir/plugins/plugin_debugger.dll"'
>
> Is there any cost or downside associated with this? There are suspicions the
> server is quit
On Mon, Mar 15, 2010 at 1:04 AM, Jeffrey Ottery
wrote:
> Anyone have some idea how to do this? I am able to install my Win32
> application but the postgeSQL install will not work. Any help or at
> least a starting point would be appreciated.
Windows XP Embedded is not a tested or supported platfo
Carlo Stonebanks wrote:
> Now THIS is a new one for me! I have no idea where to even start. Does
> anyone know how to look for the error? Below is the query and what I believe
> are the related log entries.
>
[...]
>
> SELECT facility_id, street_address, base_zip, COUNT(*) AS
> provider_count
Hi All,
I am creating a system DSN using PostgreSQL Unicode driver, after giving all
the server credentials, when i am testing for the connection it is giving,
error message like
"odbcad32.exe has encountered a problem and needs to close. We are sorry for
the inconvenience."
Can anybody please
Felix wrote:
> I am using libpq 8.2.4 (and my own wrapper around it) for a
> long time now. Due to some performance penalties I would
> like to upgrade to 8.4.x libpq.
>
> Is it o.k. if I upgraded my libpq to the newer 8.4
> libraries but would still connect to old 8.2 servers?
>
> Are there any
Hi,
I am trying to migrate a 32-Bit server running Postgres 8.3.1 to another
machine running 8.4.0 on 64-bit. I have compiled Postgres 8.4.2 on a
Debian Leeny 64-Bit System and getting constantly Segmentation Faults
(Terminated Postgres Server by Signal 11) when a specific function,
which use
Frank jansen writes:
> I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib
> directory, tried Debians 8.4 backport package with the 8.4 contrib package
> and all do the same: Segfault and terminated by Signal 11 :-(
Try 8.4.3, which has some XML crash related fix:
http://
Hi,
I have an email marketing software installed on the same server as
PostgresSQL database.
Am unable to connect to the database from this application. The
database owner is dbadmin.
My pg_hba.conf has one entry as:
local all dbadmin trust
What other setup is required for this?
Thanks
--
In response to Major Services :
> Hi,
>
> I have an email marketing software installed on the same server as
> PostgresSQL database.
> Am unable to connect to the database from this application. The
> database owner is dbadmin.
Error-message?
>
> My pg_hba.conf has one entry as:
>
> local al
On 15/03/2010 11:24, Major Services wrote:
> I have an email marketing software installed on the same server as
> PostgresSQL database.
> Am unable to connect to the database from this application. The
> database owner is dbadmin.
>
> My pg_hba.conf has one entry as:
>
> local all dbadmin trus
On Mon, Mar 15, 2010 at 11:47, Dimitri Fontaine wrote:
> Frank jansen writes:
>> I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib
>> directory, tried Debians 8.4 backport package with the 8.4 contrib package
>> and all do the same: Segfault and terminated by Signal 11 :-
-- Forwarded message --
From: Major Services
Date: Mon, Mar 15, 2010 at 5:36 PM
Subject: Re: [GENERAL] Unable to connect to Postgres database from
email marketing software on the same host
To: r...@iol.ie
I have the following:
host all dbadmin 0.0.0.0/0 trust
Do I
Error message is "Server call failed for unknown reason"
The software doc does not mention whether trying to establish a
connection via UNIX-Sockets or
via TCP/IP?
On Mon, Mar 15, 2010 at 5:43 PM, Major Services
wrote:
> -- Forwarded message --
> From: Major Services
> Date: M
In response to Major Services :
> Error message is "Server call failed for unknown reason"
Okay, i know from the other post, you have also a proper host-entry.
Well, this error-message isn't helpfull, can you see in the server-log
for a more detailed error message?
Regards, Andreas
--
Andreas
A B wrote:
3Ware SAS 9690SA-8i 512 MB BBU
Adaptec SAS Raid 5805 256 MB BBU
LSI MegaRaid SAS 8708 128 MB BBU
When it comes to choosing the acctual discs I guess this would be
appropriate to use:
"other data": Barracda ES.2 1000 GB (SATA) to get a a good GB/$ ratio.
OS/xlog : Barracuda ES.2 500
Not sure how to check the server-log? Please help.
New to Postgres & Linux!
On Mon, Mar 15, 2010 at 5:48 PM, Major Services
wrote:
> Error message is "Server call failed for unknown reason"
>
> The software doc does not mention whether trying to establish a
> connection via UNIX-Sockets or
> vi
A B wrote:
If I had a controller with battery, then I could use fsync=off, but I
should still disable the write cache?
Never turn fsync=off. Always disable any write cache on the drives
themselves; most good battery-backed RAID controllers will do that for
you. So long as the battery con
In response to Major Services :
> Not sure how to check the server-log? Please help.
>
> New to Postgres & Linux!
Just read the logfile, it's usually somewhere under /var/log/postgresql.
On my machine for instance /var/log/postgresql/postgresql-8.4-main.log
>
>
> On Mon, Mar 15, 2010 at 5:48
Am 15.03.2010 12:56, schrieb Magnus Hagander:
On Mon, Mar 15, 2010 at 11:47, Dimitri Fontaine wrote:
Frank jansen writes:
I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib
directory, tried Debians 8.4 backport package with the 8.4 contrib package
and all do
On Mar 15, 7:23 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Mon, Mar 15, 2010 at 1:04 AM, Jeffrey Ottery
>
> wrote:
> > Anyone have some idea how to do this? I am able to install my Win32
> > application but the postgeSQL install will not work. Any help or at
> > least a starting point would be
On Sat, Mar 13, 2010 at 4:33 PM, fka...@googlemail.com
wrote:
> I am using libpq 8.2.4 (and my own wrapper around it) for a
> long time now. Due to some performance penalties I would
> like to upgrade to 8.4.x libpq.
>
What gives you the impression that updating the client library will
improve yo
Hi,
we have encountered huge memory problems (segfault on 8.4.2, out of
memory on 8.4.3) with our xml functions when moving from 8.3 to 8.4, as
mentioned here:
http://archives.postgresql.org/pgsql-general/2010-03/msg00563.php
We think about moving from contrib/xml2 to the core xml support.
B
Vick Khera:
> On Sat, Mar 13, 2010 at 4:33 PM, fka...@googlemail.com
> wrote:
> > I am using libpq 8.2.4 (and my own wrapper around it) for a
> > long time now. Due to some performance penalties I would
> > like to upgrade to 8.4.x libpq.
> >
>
> What gives you the impression that updating the c
On Mon, Mar 15, 2010 at 11:25 AM, fka...@googlemail.com
wrote:
> May I, the other way round, assume from your reply that
> there is neither a disadvantage nor a compatibility issue
> when I stick to libpq 8.2 (not upgrading to 8.4) but update
> the *server* to 8.4?
>
The 8.2 client library will s
> Don't put SAS drives on a 3ware controller. They say that works now, but
> they haven't really gotten it right yet--their controllers are still only
> good with SATA drives.
How bad will it be with SAS drives? Is there so little performance
gain witn 3ware+SAS?
Scott Marlowe stated in earlier
Frank jansen wrote:
> Now with 8.4.3 the scripts work, but only until it has eaten up my
> memory (4 gig).
> The function above is executed for ~4 items, with iteration
> steps of 300 items, every step memery consumption is increasing till
> the machine hangs and process dies.
Can you describ
Hi all,
I updated the server from 8.2 to 8.4, but I am still using
libpq 8.2 to write timestamps with the libpq C interface,
using the binary format and PQexecParams(). While pgAdmin in
8.2 server shows correct timestamps, 8.4 displays garbage
(year 15000 etc).
This has probably to do with the co
Windows XP Embedded is not a tested or supported platform for
PostgreSQL. I have no idea if it will work or not.
To make changes to your
subscription:http://www.postgresql.org/mailpref/pgsql-general
As it turns out I have succeeded, So pg seems to work OK on Windows
Embedded
indeed, X
We have a database with contacts within lists, which can have any
number of tags associated with them. I would like to segment the
contacts based on any number of tag-based conditions, all of which
must be fulfilled (i.e. an ALL rule/filter). For instance, I want to
extract all contacts whi
Greg Smith wrote:
> Given what you've said about your budget here, I suspect that you're
> heading toward either 3ware or LSI and all SATA drives. I wouldn't
> expect that big of a performance difference between the two with only 8
> drives on there. If you had 24, the 3ware controller would l
"fka...@googlemail.com" writes:
> I updated the server from 8.2 to 8.4, but I am still using
> libpq 8.2 to write timestamps with the libpq C interface,
> using the binary format and PQexecParams(). While pgAdmin in
> 8.2 server shows correct timestamps, 8.4 displays garbage
> (year 15000 etc).
>
On Mon, Mar 15, 2010 at 8:55 AM, Greg Smith wrote:
> Don't put an Adaptec card into a Linux system. They don't take that OS
> nearly as seriously as your other choices here.
>
Interesting... same advice goes for Adaptec + FreeBSD. I guess
Adaptec + !Windows == bad?
--
Sent via pgsql-general m
Greetings!
Our database monitors the progression of steel coils through the
annealing process. The times for each step are recorded in wallclock
time (US eastern time zone for this customer) and in UTC time. During
standard time, the difference will be 5 hours, and during daylight
savings time t
Magnus Hagander wrote:
I could swear I've seen cases where xp embedded failed because it was
missing a bunch of security api's. Is it like ce where such things can
be removed by an oem manufacturer?
yeah, eggzackly.every component imaginable is custom configurable.
there's some things i
Vick Khera wrote:
Interesting... same advice goes for Adaptec + FreeBSD. I guess
Adaptec + !Windows == bad?
i've never liked adaptec, windows or not. bunches of their too-popular
SCSI cards even way back in the old days of 10-20MB/sec SCSI had sketchy
electrical specs on the SCSI bus an
On Monday, March 15, 2010, John R Pierce wrote:
>
>
> Windows XP Embedded is not a tested or supported platform for
> PostgreSQL. I have no idea if it will work or not.
>
> To make changes to your
> subscription:http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> As it turns out I have succe
I upgraded from 8.4.2 to 8.4.3, and I couldn't start postgres. This was
printed on STDERR
FATAL: data directory "path-to-my-data-dir" has group or world access
DETAIL: Permissions should be u=rwx (0700).
This change was not documented in the release notes, and I don't think
permission != 700
I need to get a copy of the 8.4.2 Linux 64 bit One Click Installer instead of
8.4.3. The plan is to install the 8.4.2 and then test our Patching procedures
when upgrading to 8.4.3.
Thanks,
Sandra Arnold
Sr. Database Admin
DOE/OSTI
On 3/15/2010 2:40 PM, Rob Richardson wrote:
> Greetings!
>
> Our database monitors the progression of steel coils through the
> annealing process. The times for each step are recorded in wallclock
> time (US eastern time zone for this customer) and in UTC time. During
> standard time, the differe
Thanks for the try, Justin, but that doesn't seem to be the problem.
The query generates the same results on my customer's machine. Besides,
I think your theory would only hold up if there were two machines
involved. There aren't.
RobR
--
Sent via pgsql-general mailing list (pgsql-general@pos
On Mon, Mar 15, 2010 at 21:08, Joseph S wrote:
> I upgraded from 8.4.2 to 8.4.3, and I couldn't start postgres. This was
> printed on STDERR
>
> FATAL: data directory "path-to-my-data-dir" has group or world access
> DETAIL: Permissions should be u=rwx (0700).
>
> This change was not documented
Frank jansen wrote:
> Hi,
>
> we have encountered huge memory problems (segfault on 8.4.2, out of
> memory on 8.4.3) with our xml functions when moving from 8.3 to 8.4, as
> mentioned here:
> http://archives.postgresql.org/pgsql-general/2010-03/msg00563.php
>
> We think about moving from contr
On 15/03/10 20:08, Joseph S wrote:
This change was not documented in the release notes, and I don't think
permission != 700 should be a fatal error. I purposely set o+x to let
any user be able to read the log files.
What Magnus said but also - put your log files somewhere else. That way
you c
On 15/03/10 20:40, Arnold, Sandra wrote:
I need to get a copy of the 8.4.2 Linux 64 bit One Click Installer
instead of 8.4.3. The plan is to install the 8.4.2 and then test our
Patching procedures when upgrading to 8.4.3.
Hmm - didn't even know we *had* a one-click installer on Linux. I think
Magnus Hagander wrote:
There has been no change there. From what I can tell, that part of the
code hasn't been touched since 2004. That shouldn've have worked in
8.4.2 either - but it's only checked on server startup, so if you
changed the mode after startup you wouldn't have noticed.
Hmm. I
Rob Richardson wrote:
Greetings!
...
I just looked at the record for a charge for which heating started just
after 9:00 Saturday night, less than 3 hours before the change to
daylight savings time. The UTC time stored for this event is six hours
later!
The function that writes these times f
On 03/15/2010 12:40 PM, Rob Richardson wrote:
Greetings!
Our database monitors the progression of steel coils through the
annealing process. The times for each step are recorded in wallclock
time (US eastern time zone for this customer) and in UTC time. During
standard time, the difference wil
"Rob Richardson" writes:
> Our database monitors the progression of steel coils through the
> annealing process. The times for each step are recorded in wallclock
> time (US eastern time zone for this customer) and in UTC time. During
> standard time, the difference will be 5 hours, and during d
Magnus Hagander writes:
> On Mon, Mar 15, 2010 at 21:08, Joseph S wrote:
>> I upgraded from 8.4.2 to 8.4.3, and I couldn't start postgres. This was
>> printed on STDERR
>>
>> FATAL: data directory "path-to-my-data-dir" has group or world access
>> DETAIL: Permissions should be u=rwx (0700).
>>
Thank you for your replay.
I fixed by get specific rpm(compat-postgresql-libs-4-
1PGDG.rhel4.i386.rpm) from Postgres site and run manually installed.
---
G. Padmanabhan
On Sun, Mar 14, 2010 at 4:02 AM, Lacey Powers <
lacey.pow...@commandprompt.com> wrote:
> Padmanabhan G wrote:
>
>> Hi,
>>
>>
52 matches
Mail list logo
