Josh Trutwin j...@trutwins.homeip.net 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
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 objects.
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
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
initdb -D
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 packages (so just compiling from the source
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
leonel
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
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
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
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
try to
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
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
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, if this is an upgrade
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) =
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
sudo apt-get
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
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.
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 uncompressed
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. You aren't going to find a performance win though.
(c
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
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
select thumbnail(image_field, 100, 100) from images_table
that would be a good
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
represents
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 !
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
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:
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
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
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:
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
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
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
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 binary
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
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
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.
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 have
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
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
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?
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
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
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
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 unregister
45 matches
Mail list logo
