Well, using pg_unescape_bytea I was able to get the image. How can I stream
it directly to the users's browser??
- Original Message -
From: "Andy Shellam"
To: "Félix Sánchez Rodríguez"
Cc:
Sent: Friday, May 08, 2009 8:26 AM
Subject: Re: [ADMIN] Getting image from a DB
Hi Felix,
the install sets the file
permissions to account for postgresql service. The only account that
should have access to those files is the postgresql service, and the
postgresql account should only have access to directories that it needs
access to.
If you took ownership of the directory and t
On Fri, 8 May 2009 10:19:29 -0400
Ray Stell wrote:
> don't you need root to do package management? Maybe that is just
> Red Hat like. Hmm, not on OS X.
Well you expect that every single header that postgresql needs to be
built from source is already on the system? If not you need access to
pac
j...@commandprompt.com ("Joshua D. Drake") writes:
>> > * Why should I have to configure a custom init.d script so my
>> > PostgreSQL will start?
>>
>> to gain control over the system issue. From my perspective pg has always
>> been at the enterprise layer,
>
> This surprises me a bit. In my exp
Hi Everybody,
Is anyone testing 8.4 beta?
I installed it on win2008 64bit machine, testing and uninstalling I found no
problems, but I ran into an issue with trying to delete the C:\Program Files
(x86)\PostgreSQL folder after uninstalling. File permissions on some of the
data files under the Da
Hi,
Got it working now, though after several searches and hit-n-trials
The problem was in my "/pgsql/data/pg_hba.conf"; where it needed my machine's
IP.
Now got it working.
But the real issue of service is not yet being recognized with in the command:
# service postgresql status
postgresq
Ok let's to create a cluster for you, be sure the pg8 directory owned by
postgres user and the directory is empty.
[postg...@callisto]$ initdb -D /usr/local/pgsql/postgresql-8.3.7/pg8 -U
postgres -W
Type your password if they ask, wait initdb process until finish.
And try the server:
[postg...
On Fri, 2009-05-08 at 10:19 -0400, Ray Stell wrote:
> On Thu, May 07, 2009 at 09:58:04AM -0700, Joshua D. Drake wrote:
> > Because "users" shouldn't compile. The commands aren't relevant. If
> > possible you should *always* run from your package manager.
>
> don't you need root to do package manag
Michael Monnerie writes:
> On Freitag 08 Mai 2009 Jan Muhammad wrote:
>> postmaster -D /usr/local/pgsql/data
>> LOG: could not translate host name "localhost", service "5432" to
>> address: Name or service not known
> This smells a lot like SElinux.
No, it looks like his DNS setup is broken. N
On Thu, May 07, 2009 at 09:58:04AM -0700, Joshua D. Drake wrote:
> Because "users" shouldn't compile. The commands aren't relevant. If
> possible you should *always* run from your package manager.
don't you need root to do package management? Maybe that is just
Red Hat like. Hmm, not on OS X.
>
On Freitag 08 Mai 2009 Jan Muhammad wrote:
> After having various error message in starting PostgreSQL version
> 8.2.11; finally uninstalled/deleted it. Now trying my luck on 8.3.7,
> but things haven't changed for me. When I try to check that
> postmaster server is running or not? I get the follo
Hi,
After having various error message in starting PostgreSQL version 8.2.11;
finally uninstalled/deleted it. Now trying my luck on 8.3.7, but things
haven't changed for me.
When I try to check that postmaster server is running or not? I get the
following error:
$ postmaster -D /usr/local/pgsq
12 matches
Mail list logo
