Hi Felix,
I've not written an image specifically, but I have read/written byte
data which is all an image is.
Your PostgreSQL database column that holds the image should be of type
"bytea." Your PHP application must then use the following functions:
Writing to the database - http://uk2.php
Hi:
Has anybody here had to capture an image from a PostgreSQL Data Base using
PHP?? I used a simple query: select photo from people where id = 3, for
instance. The problem is that when I write the image to disk it's not a valid
image. I opened it using an HEX editor and saw that the question i
you have a data directory alredy?
try to use another directory
$ mkdir /usr/local/pgsql/data2
$ chown postgres:postgres /usr/local/pgsql/data2
$ initdb -D /usr/local/pgsql/data2
--- On Thu, 5/7/09, Jan Muhammad wrote:
> From: Jan Muhammad
> Subject: Re: [ADMIN] How to run PostgreSQL?
> To:
Hi list:
Does Cybercluster provides a pool service or I have to install it instead,
for example pgPool II? I´m wondering that because when you configure the
load balancer service there is an option like this one:
yes
and it seems like it provides the pool service.
Linux Registered
On Thu, 2009-05-07 at 09:01 -0400, Ray Stell wrote:
> On Thu, May 07, 2009 at 07:49:56AM -0500, Ries van Twisk wrote:
> > I hope you don't compile 8.2.11 now from source, right?
>
> I never understood this attitude.
Because "users" shouldn't compile. The commands aren't relevant. If
possible you
Hi Andy,
Thanks indeed for detailed response.
Infact, I have suffered many times due to latest versions & their
dependecy/compatibility issues (not with PostgreSQL but other softwares). Thats
why I have chosen bit older version.
Anyways, now what you suggest? Should I download/reinstall 8.3.7?
Jan Muhammad writes:
> It wasn't installed with package manager; I downloaded and
> followed the PDF manual from the link (
> http://www.postgresql.org/docs/manuals/). But now while I installed it
> from source; if try to check it with (#rpm -q postgresql ), I get
> "Package postgresql is not inst
Hi Jan
initdb: directory "/usr/local/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql/data" or run initdb
with an argument other than "/usr/local/pgsql/data"
---
It wasn't installed with package manager; I downloaded and followed the PDF
manual from the link ( http://www.postgresql.org/docs/manuals/). But now while
I installed it from source; if try to check it with (#rpm -q postgresql ), I
get "Package postgresql is not installed". I wonder the system d
Hi,
Yes I had done that step prior to writing on group. But now if I try to re-run
I get the following error:
[postg...@callisto local]$ initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The
Zitat von Jan Muhammad :
Hi,
I have just downloaded, installed/configured postgresql version
8.2.11 on Fedora Core 6. While reading through the installation
manual have setup most of its parts; now while trying to run
datebase server with the command:
$ postmaster -D /usr/local/pgsql/d
On Thu, May 07, 2009 at 07:49:56AM -0500, Ries van Twisk wrote:
> I hope you don't compile 8.2.11 now from source, right?
I never understood this attitude. Do this commands really
make for a daunting adventure. Why the trepidation?
http://www.postgresql.org/docs/8.2/interactive/install-short.
On May 7, 2009, at 7:26 AM, Ray Stell wrote:
On Thu, May 07, 2009 at 04:38:59AM -0700, Jan Muhammad wrote:
Hi,
I have just downloaded, installed/configured postgresql version
8.2.11 on Fedora Core 6. While reading through the installation
manual have setup most of its parts; now while try
On Thu, May 07, 2009 at 04:38:59AM -0700, Jan Muhammad wrote:
> Hi,
>
> I have just downloaded, installed/configured postgresql version 8.2.11 on
> Fedora Core 6. While reading through the installation manual have setup most
> of its parts; now while trying to run datebase server with the comman
Hi,
I have just downloaded, installed/configured postgresql version 8.2.11 on
Fedora Core 6. While reading through the installation manual have setup most of
its parts; now while trying to run datebase server with the command:
$ postmaster -D /usr/local/pgsql/data
I get the following error:
15 matches
Mail list logo
