> Josh Trutwin writes:
>> Hi - I'm trying to build 8.3.6 on a box recently upgraded from Sarge
>> to Lenny and I get the following error during compile:
>
>> make[4]: Entering directory
>> `/backup/source/db/postgresql-8.3.6/src/backend/utils/adt' gcc -O2
>> -Wall -Wmissing-prototypes -Wpointer-ar
> Hi,
>
> I would like to store binary data in a PostgreSQL database. The size of
> the data is about 2 to 20 MB and is always stored or retrieved as a
> block (i.e., I do not need to get only part of the data). As I
> understand, I have two options for storing this data: As BYTEA or as
> large obj
> The INSTALL file for postgresql 8.3rc1 lists the following install
> instructions:
>
> ./configure
> gmake
> su
> gmake install
> adduser postgres
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> /usr/loc
> Is it advisable or ok to install v8.2.5 to a Red Hat 9 configuration? I
> tried it and there are a lot of libraries that I need get and install
> (e.g.
> libc). I am wondering if it is worth it (or dangerous) or am I better off
> upgrading my system?
>
> Thanks
>
>
>
> Tony
>
> Onward & Upward!
> Hi All,
>
>I have a question - what is the procedure, to change the default
> location of the data directory of PostgreSQL database? I would like
> the data to be stored in /dane/postgresql/data instead of the Ubuntu's
> default location (/var/lib/postgresql/). Is it enough just to run
> init
> Joshua D. Drake wrote:
>> Mikko Partio wrote:
>>
>>> Laurent ROCHE wrote:
>>>
Hi,
Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2,
from a recommandable place ?
I can not recommend my clients to use 8.2 if there's nobody supporting
the packa
> Hi,
>
> I would like to store picture in my DB and after to display them on my PHP
> pages.
>
> What is the best solution for that ?
>
> thanks a lot
>
> --
> Alain
>
> Windows XP SP2
> PostgreSQL 8.1.4
> Apache 2.0.58
> PHP 5
>
>
I do with ByteA datatype
> 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
> 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
> 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
> Hi,
>
> I have a postgresql server setup on a Solaris 10 box. I can connect to
> the db via psql from the local machine. What I have been trying to do
> it connect with pgAdmin from my workstation. I have setup the tunnel
> correctly, local port 5432 and destination localhost:5432. Everytime I
>
Hello :
I've seen that the 8.1.5-6 rpms are available.
Are those RPMs corrected from the announced bug ?
Thanks
Leonel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> Hi,
>
> On Mon, 2006-10-30 at 09:17 -0700, Leonel Nunez wrote:
>> is it safe to go back to 8.1.4 ?
>> or can we safely wait for the fix ?
>
> If it is a fresh install, then it will probably not work for you. It
> sets a wrong homedir for postgres user. However,
Hello
I've read on the postgresql weekly news the RPMS for 8.1.5 has a serious bug
http://archives.postgresql.org/pgsql-announce/2006-10/msg00018.php
is it safe to go back to 8.1.4 ?
or can we safely wait for the fix ?
thank you
Leonel
---(end of broadcast)
Hello
I've downladed postgresql-python-3.8.1-3PGDG.i686.rpm from the
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/redhat/rhel-es-4/
to install on a CentOS 4.4 and get this error :
# rpm -Uvh postgresql-python-3.8.1-3PGDG.i686.rpm
error: Failed dependencies:
python(abi) = 2.
> Do I need to remove mySQL or leave it installed?
>
> Kirt
If you don't need itremoveit
leonel
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> Hello:
>
>
>
> I am going to install Ubuntu OS under their LAMP installation. This LAMP
> installation installs mySQL. Is there any way I can install postgreSQL
> instead of mySQL? Has anybody created a LAMP to install Ubuntu, Apache,
> postgreSQL & PHP?
>
>
>
> Kirt
>
>
>
after instalation do
> I'm trying to create a new tablespace in a directory that postgres
> owns, but PG says it cannot set permissions on this directory.
>
> [EMAIL PROTECTED] ~]# su - postgres
> -bash-3.1$ mkdir /opt/home/pgdata/mspace/
> -bash-3.1$ psql
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
> "Leonel Nunez" <[EMAIL PROTECTED]> wrote:
>>
>> > If the database had built-in functions to manipulate images (make a
>> > thumbnail, add text ont it.., make a montage of two pictures) and I
>> could
>> > write something like
>
> Hi,
> If the database had built-in functions to manipulate images (make a
> thumbnail, add text ont it.., make a montage of two pictures) and I could
> write something like
> select thumbnail(image_field, 100, 100) from images_table
> that would be a good reason to go the db route versus the file
> Leonel Nunez wrote:
>>> I think the arguments for keeping stuff inside the database are
>>> (a) far easier to maintain transactional semantics for insert/delete,
>>> and (b) easier to serve the data out to clients that aren't on the
>>> same machine.
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
>> ... postgresql will toast all images over a cerain size which
>> is actually pretty efficient although can be a problem if your images
>> are really big.
>
> But any reasonable image format is compressed already (or at least, if
> you are using an u
> Hello,
>
> I think I'm about to ask a traditional (almost
> religious) question, but I haven't been able to find a
> crystal clear answer in the mailing lists so far.
> Thus, here is my question:
>
> I need to store a large number of images in a
> PostgreSQL database. In my application, this
> re
> I have a web application that is accessed by a large number of users.
> My application is written in PHP and uses postgres. Apache is our web
> server.
> The performance of my application drops down when a large numbers of users
> connects at the same time. I need to have a better response time
Hello :
If the driver for postgresql hasn't been patched for the past
sqlinjection bug as I understood the postgresql 8.1.4 engine will
return an error so no sqlinjection can be done ?
thanks
Leonel
---(end of broadcast)---
TIP 3: H
surabhi.ahuja wrote:
where can i download the rpms for the PostgreSQL version 8.0.8
till now we have been using 8.0.0.
thanks,
regards
Surabhi
you can from here :
http://www.postgresql.org/ftp/binary/v8.0.8/linux/
leonel
---(end of broadcast)-
Hello :
the PostgreSQL binary packages for redhat on
http://www.postgresql.org/ftp/binary/v8.1.4/linux/rpms/redhat has
the jdbc python perl modules
are those divers safe from the sql injection ?
according tohttp://www.postgresql.org/docs/techdocs.49
says :
" In addition to Post
P G wrote:
Hello,
I am hoping this is the right place.
I have recently switched to Kubuntu and I just installed Postgres on
it. The installation was successful.
When I try psql, I get this error message, though:
% psql postgres
Error: You must install at least one postgresql-client- packag
Bit Byter wrote:
I just did a file based database backup (stopped postmaster and
zipped/copied all files under /usr/local/pgsql/data/* to a differnt
location)
How can I 'restore' the database and start using it?
---(end of broadcast)---
TIP 3: Ha
Bruno Baguette wrote:
Hello,
I works on a PostgreSQL 8.0.4 database, and I would like to known the
size (in bytes, Mbytes or anything else) of that database, for each
table.
How can I do that ?
Thanks in advance !
on contrib package or contrib subdir from the source is dbsize
leon
Rich Shepard wrote:
On Tue, 14 Feb 2006, Randal L. Schwartz wrote:
Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the
"other" way that MySQL could have transactions if Oracle decided to
restrict InnoDB tables (after purchasing Innobase last year).
From what I read a few
Stefan Arentz wrote:
Hi there,
I'm looking at the design for an application where i have to store
potentially many gigabytes worth of small blobs of varying sizes (8K -
64K) in a database. I've always been told that it is smarter to store
references to files in the database, and I think that
Doug McNaught wrote:
Leonel Nunez <[EMAIL PROTECTED]> writes:
You can use ByteA but the size will be about 4 times bigger
Are you sure? The intermediate form for bytea (escaped single-quoted
strings) is pretty inefficient, but once in the database the data is
stored as
littlebutty wrote:
I have written software that will dynamically create PDF documents used
within my web application. Because each document is unique, I would
like to store the resultant PDF into a field of the DB. Currently I
just store the file to the server's hard drive and insert a path to
kishore mukati wrote:
Hi Leonel
at first thanks for help
I try with that link you send to me
but now I am getting a new error
below
this is exception in MyMailTracker.main()java.sql.SQLException: ERROR:
column "attachment" is of type bytea but expression is of type integer
and one more t
kishore mukati wrote:
Hi
I am facing a proble when I am trying to store images, filse in
postgreSQL.by using Bytea datatype field in table
using setBinaryStream().
it show me exception
inputstream is supported.
please send me if anybody have solution of this problem.
thanks
kishore muka
Andre Truter wrote:
On Sat, 2005-12-17 at 06:20 -0700, Leonel Nunez wrote:
It's on the contrib package
No, unfortunately the SUSE people did not include it in the contrib
package.
or in the contrib dir if you installed from source
Installed from rpm package.
I
Andre Truter wrote:
Where do I find documentation for using dblink?
I am running PostgreSQL 8.03 on SuSE 9.3 and I installed the
postgresql-contrib package, but it only includes the README for dblink,
which only lists the functions, but it does not include any information
on how to use it.
For
Juan Jose Siles Salinas wrote:
Hola tengo un problema serio, my servidor de bases de datos se arruino
y no saque copia de mi base de datos, he instalado otro servidor con
las mismas caracteristicas pero como hago para recuperar toda la base
de datos del anterior disco
---
Jaime Casanova wrote:
On 12/14/05, Alejandro D. Burne <[EMAIL PROTECTED]> wrote:
Hi, I'll be watching on ftps without success. There is a release date for
8.1.1?
Yes... the announce was made yesterday...
8.1.1 is officially released...
--
regards,
Jaime Casanova
(DBA: DataBase Aniq
Hello
I cant find any info if PygreSQL works with ByteA or if there's
an escape function to store the objects in a ByteA Field
Thanks
Leonel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http:/
Michal Hlavac wrote:
hello,
I installed PostgreSQL 8.0.3 on Suse 10 (x86_64).
Firewall is down.
telnet localhost 5432 result:
x:/var # telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
but telnet ip_address 5432 result:
x: # telnet 158.195.
Macario Mares wrote:
He tratado de importar datos con la instrucción COPY pero no he
podido. Les agradeceria me dieran un ejemplo de cómo importar datos ya
sea de Windows o linux
si das mas info de porque no puedes seria mejor con lo que comentas lo
unico que te puedo comentar es que le
John Wells wrote:
Guys,
I have a number of jpegs and tiffs that are stored in a bytea field in a
PostgreSQL database by a Java program using Hibernate.
I need to copy these out to a flat file via pgsql for viewing, etc. I've
tried
psql -c 'select binarydata_field from my_image_table where id
3 to libpq.so.4
you need to recompile all the pagackes that depend on libpq.so.3 so
they can use the new libpq.so.4
Leonel Nunez
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "
45 matches
Mail list logo
