Hi Patrick,
First read this as a general guide for debian.
http://www.debian.org/releases/stable/i386/release-notes/ch-upgrading.html
There was a few gotchas for our upgrade that made us for now stay on
lenny and postgres 8.3.
One being our old client application not being able to deal
On Mon, July 30, 2012 9:14 pm, Craig Ringer wrote:
> On 07/24/2012 09:50 PM, Larry Rosenman wrote:
>> This one is concerning. Trying to restore a backup from one system to
>> another, and got this:
>>
>> pg_restore: restoring data for table "userid"
>> pg_restore: restoring data for table "values
On Jul 30, 2012, at 7:35 PM, Tom Lane wrote:
> Steven Schlansker writes:
>> It is not possible to compile Postgres contrib/uuid-ossp on the newest
>> release of Mac OS X, 10.8
>
> This looks like some variant of the same issue that OSSP's uuid
> package has had on Macs all along, to wit an un
Steven Schlansker writes:
> It is not possible to compile Postgres contrib/uuid-ossp on the newest
> release of Mac OS X, 10.8
This looks like some variant of the same issue that OSSP's uuid
package has had on Macs all along, to wit an unreliable method for
avoiding conflicts with any OS-supplie
On 07/24/2012 09:50 PM, Larry Rosenman wrote:
This one is concerning. Trying to restore a backup from one system to
another, and got this:
pg_restore: restoring data for table "userid"
pg_restore: restoring data for table "values"
pg_restore: [compress_io] could not uncompress data: (null)
pg_r
It is not possible to compile Postgres contrib/uuid-ossp on the newest release
of Mac OS X, 10.8
The specific compile error:
make -C uuid-ossp install
/bin/sh ../../config/install-sh -c -d '/usr/local/Cellar/postgresql/9.1.3/lib'
/usr/bin/clang -Os -w -pipe -march=native -Qunused-arguments
-I
Hi,
Several years ago I gave this presentation to a bunch of PHP
developers in order to show then that something else is out there :).
Presentation was based on MySQL 4.1 and Postgres 8.2/8.3 (early 2008).
I would like to do it again and I'm looking for sources which can I
re-use (and credit back
On 07/30/2012 07:36 AM, Little, Douglas wrote:
I have an input source that is in epoch time.Is there a built-in
conversion to changing to timestamp
http://www.postgresql.org/docs/9.1/interactive/functions-formatting.html
"
to_timestamp(double precision) timestamp with time zone convert Unix
Le lundi 30 juillet 2012 à 12:57 +0200, Patrick Ernst a écrit :
> We are running PostgreSQL 8.3 on a Debian Lenny system. Since the system
> is outdated, we want to update to Debian Squeeze.
>
> Based on your knowledge and experience are there any special
> preparations for PostgreSQL we have t
On Jul 30, 2012, at 7:36 AM, Little, Douglas wrote:
> I have an input source that is in epoch time.Is there a built-in
> conversion to changing to timestamp
to_timestamp().
You can also do things like "select timestamptz 'epoch' + ? * interval '1
second'".
Cheers,
Steve
--
Sent via
"Little, Douglas" hat am 30. Juli 2012 um 16:36
geschrieben:
> I have an input source that is in epoch time.Is there a built-in
> conversion to changing to timestamp
>
>
>
select 'epoch'::date + * '1second'::interval;
Andreas
--
Sent via pgsql-general mailing list (pgsql-genera
I have an input source that is in epoch time.Is there a built-in conversion
to changing to timestamp
Thanks
Doug Little
Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz
Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax
312.894.516
Hello,
I need to index a table with two columns:
column_t timestamp
column_ia integer[]
The number of rows is around 100M. Each integer array (column_ia)
contains on average 4 values (100 possible integer values altogether)
I created two indexes:
create index idx_gist on my_table using gi
Im contacting them tomorrow for sure. My issue is that I uninstalled the
postgresql system from my computer and now I cant get it installed again
because of the password issue. Thats all im trying to solve, getting the
postgresql installed again in my laptop and like said because of being reall
Hello,
We are running PostgreSQL 8.3 on a Debian Lenny system. Since the system
is outdated, we want to update to Debian Squeeze.
Based on your knowledge and experience are there any special
preparations for PostgreSQL we have to take care of? Or can you give us
some tips how we should appro
On 07/30/2012 05:52 PM, Venkat Balaji wrote:
Hello Community,
We have used "pg_ctlkill QUIT " to terminate one of the processes
on the production database and the database went into recovery mode.
Did you intend to send SIGTERM (signal 15) instead of SIGQUIT (signal
3)? Signal 3 will be inte
On 2012-07-30, Jasen Betts wrote:
>> I have tried several ways including creating a function to read a file
>> without any success but basically I want to do something like the
>> following from a bash shell
>>
>> psql -c "insert into x (ID, load_date, image)
>> values ($PID,clock_timestamp()
On 2012-07-24, jkells wrote:
> I am running REDHAT 5.5 64 bit with PostgreSQL 8.4.7 64 bit. I am trying
> to load a binary file into a bytea column into a table without any luck
> from psql.
> On the linux server a script is looking for a file and if found would
> create a record into a table
On 07/30/2012 02:00 PM, Guillermo Echevarria Quintana-Gurt wrote:
Im contacting them tomorrow for sure. My issue is that I uninstalled
the postgresql system from my computer and now I cant get it installed
again because of the password issue. Thats all im trying to solve,
getting the postgresql
Hello Community,
We have used "pg_ctl kill QUIT " to terminate one of the processes on
the production database and the database went into recovery mode.
We understand that we should not use "kill -9" and we did not do that.
Could you please help us avoid this problem permanently.
Regards,
Venka
20 matches
Mail list logo
