egards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Lenny has 8.3.6 why don't just apt-get install postgresql ???
http://packages.debian.org/le
Gustavo Rosso wrote:
> Please, exists postgres forum in spanish?
> Thanks
> Gustavo
>
aqui se habla español :
http://archives.postgresql.org/pgsql-es-ayuda/
Saludos ..
Leonel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
roadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org/
>
With Java , Python , Perl you've got functions that escapes the data for
you
Leonel
---(end of broadcast)---
TIP 6: explain analyze is your friend
-
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
>
and what are the permissions and owner for
/usr/local/pgsql/data
?
r work."
>
well redhat 9 is no longer supported by redhat a long time
http://www.redhat.com/security/updates/eol/
Upgrade to fedora 8 or RHEL 5 or CentOS 5.1
> - Robert Kiyosaki
>
>
>
>
>
Leonel
---(end of broadcast)
esql and create your databases in the NEW tablespace
take a look at :
http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html
Leonel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ot create executables
> [EMAIL PROTECTED]:~/Desktop/postgresql-7.4.17$
>
> -
>
> Ralph Smith
> [EMAIL PROTECTED]
> =
>
>
you need to install the package build-essential that install all you
need to compile and make executables
--
Leonel
--
ommand to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
There won't be a release for postgresql 8.2 for ubuntu 6.10
you can :
1 upgrade to ubuntu feisty with sudo "update-manager -c -d"
2 request a backport
3 do the backport
tgresql servers in the same machine
postgresql listens on port 5432 for the first installed postgresql
and in port 5433 for the second installed postgresql
try using port 5433 for postgresql 8.2
--
Leonel
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t about the distros that do backporting for the bug fixes ?
those would be saying you are with a outdated PostgreSQL version
--
Leonel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 4/5/07, Listmail <[EMAIL PROTECTED]> wrote:
> On 4/5/07, Michelle Konzack <[EMAIL PROTECTED]> wrote:
>> Am 2007-04-01 12:05:44, schrieb Leonel:
>> > and once you downloaded the packages do a :
>> >
>> > apt-get build-deps postgresql-8.1
>
On 4/5/07, Michelle Konzack <[EMAIL PROTECTED]> wrote:
Am 2007-04-01 12:05:44, schrieb Leonel:
> and once you downloaded the packages do a :
>
> apt-get build-deps postgresql-8.1
Are you sure? -- It should be:
You don't have the build-dep for 8.2 in ubuntu dapper
end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Is today Aprils Fool's ?
--
Leonel
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
version for those packages
then
add this to your /etc/apt/sources.list
deb-src http://archive.ubuntu.com/ubuntu/ feisty main universe
then
apt-get source tzdata
cd tzdata-2007b
dpkg-buildpackage -rfakeroot
cd ..
dpkg -i tzdata_2007b0ubuntu1_all.deb
and now install postgresql 8.2.3
--
Le
ilable.
>
> Regards
>
> MP
>
>
> [1] https://launchpad.net/ubuntu/+source/postgresql-8.2
>
> ---(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
>
And that backport has security updates as soon as they get fixed?
leonel
---(end of broadcast)---
TIP 6: explain analyze is your friend
.0.58
> PHP 5
>
>
I do with ByteA datatype
leonel
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
ema
and the rest of your app will be untouched
leonel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
hand, manually modifying information etc., so
> there's no way in hell I'm letting them touch my data.
>
> John
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
rompt.com/
>
>
>
>
>
>
libpq.so.4 is for compatibility with 8.1
If my apps work with 8.1 and need libpq.so.4, when I upgrade to 8.2
this libpq.so.4 will be talking to postgresql 8.2 without problems ?
Leonel
---(end of broadcast)--
gt;
> I havent altered the config files, so postgresql should be listening
> on localhost.
>
on solaris :
telnet localhost 5432 does connect ?
> Any one got any ideas?
>
> Ben
>
> ---(end of broadcast)---
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 broa
n(abi) = 2.4 is needed by postgresql-python-3.8.1-3PGDG.i686
does Redhat es 4 has python 2.4 ?
Thank you
Leonel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
> 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
;
> Kirt
>
>
>
after instalation do
sudo apt-get install postgresql-8.1 postgresql-client-8.1 php5-pgsql
that's all
Leonel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
s on Fedora Core 5 (x86), psql 8.1.4.
>
> Andras
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can ge
> "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
>
int ("Content-type: image/jpeg\n\n")
print ( imagetmp.getvalue())
with this you get your image to the browser thumbnailed
without touch the filesystem
that's all
Leonel
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
> 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.
asier 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) easy to replicate
(d) easy to load balancing
leonel
--
>
Encode the image on base64 and inseert on a text field
if you use Bytea it needs to be encoded and the size stored will be
more than base64 encoded
if you store the image on disk you need to keep the consistency between
the database and the file system
leonel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
r response time ! That's
> why i need to load balance the web requests and the database.
>
> Regards,
> Najib.
>
Before that, are you using persistent conecctions ?
Leonel
---(end of broadcast)---
TIP 3:
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)---
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
on to PostgreSQL itself, many of the PostgreSQL drivers will
be upgraded this week (Java, PHP, Perl, Ruby, etc.) You will want to
upgrade them at the same time."
are the packaged rpms with the upgraded drivers ???
Thank you
Leonel
---(end of
.
<http://us.rd.yahoo.com/mail_us/taglines/postman7/*http://us.rd.yahoo.com/evt=39666/*http://beta.messenger.yahoo.com>
Ubuntu has postgresql 8.0 and 7.4
you need to install
postgresql-client-8.0 or postgresql-client-7.4
Leonel
---(end of bro
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
stop the "other" postmaster
then Unzip it
then start the postmaster with the PGDATA pointed to the location of
your files
leonel
leonel
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
t I read a few days ago, Oracle is negotiating with
Sleepycat, Zope
(is that the PHP developer's name?), and one other OSS developer.
Nothing is
yet signed, and they could all fall through.
Rich
Zope is a Python framework
Zend is for php
leonel
---(e
? Would it work? Or would
something like this blow up the db?
S.
---(end of broadcast)---
TIP 6: explain analyze is your friend
well I store images and other files on the Database with ByteA
fields works great
leonel
-
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
rchar and encode to Base64 and wil be abour 30% bigger
Leonel
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
an
mukati
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
No problems here
this is what I used as reference :
http://jdbc.postgresql.org/documentation/80/binary-data.html
Leonel
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
documentation?
Can anybody please give me a link to the documentation?
Thanks
It's on the contrib package
or in the contrib dir if you installed from source
leonel
---(end of broadcast)---
TIP 6: explain analyze is your friend
disco viejo
trata de hacer un pg_dumpall
si funciona deten el postmaster apunta el PGDATA a donde debe ir en el
nuevo
levanta el postmaster y carga la base de datos
leonel
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please s
yes it was released but
I think he meant RPMS for Fedora x64 and there's no RPMS on the
mirrors
Leonel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
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?
TIP 2: Don't 'kill -9' the postmaster
edit your postgresql.conf and
set the listen_address variable to your needs
leonel
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
le des una leida al manual
http://www.postgresql.org/docs/8.0/interactive/sql-copy.html
Leonel
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ing through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
You have on theflatfile info about the query
let's say
leonel=> select count (*) from image;
count
-
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 "
54 matches
Mail list logo
