"Randal T. Rioux" <[EMAIL PROTECTED]> writes:
> On Sat, September 6, 2008 8:21 pm, Tom Lane wrote:
> ldd or local equivalent might help debug this.
> bash-3.00# ldd /usr/local/lib/sparcv9/libgcc_s.so.1
> libc.so.1 => /lib/64/libc.so.1
> libm.so.2 => /lib/64/libm.so.2
>
On Sat, September 6, 2008 8:21 pm, Tom Lane wrote:
> "Randal T. Rioux" <[EMAIL PROTECTED]> writes:
>> On Sat, September 6, 2008 7:05 pm, Tom Lane wrote:
>>> configure:19857: $? = 0 configure:19859: ./conftest ld.so.1:
>>> conftest: fatal: libgcc_s.so.1: open failed: No such file or
>>> directory ./
[EMAIL PROTECTED] wrote:
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do i
do this?
Any anniversary today?
SELECT *
FROM your_table_with_t
"Randal T. Rioux" <[EMAIL PROTECTED]> writes:
> On Sat, September 6, 2008 7:05 pm, Tom Lane wrote:
>> configure:19857: $? = 0 configure:19859: ./conftest ld.so.1: conftest:
>> fatal: libgcc_s.so.1: open failed: No such file or directory ./configure:
>> line 19860: 20583 Killed ./conftest$ac_exeext
On Sat, September 6, 2008 7:05 pm, Tom Lane wrote:
> "Randal T. Rioux" <[EMAIL PROTECTED]> writes:
>> checking checking blah blah checking test program...
>> failed configure: error: Could not execute a simple test program. This
>> may be a problem related to locating shared libraries. Check
"Randal T. Rioux" <[EMAIL PROTECTED]> writes:
> checking checking blah blah
> checking test program... failed
> configure: error:
> Could not execute a simple test program. This may be a problem
> related to locating shared libraries. Check the file 'config.log'
> for the exact reason.
> Th
I've battled this for a while. I'm finally breaking down and asking for help.
If you're answer to this is "why 64-bit" then don't answer. You wouldn't
understand. Same if you say "why don't you use packages."
Here is my scenerio:
- Sun 420R x450Mhz UltraSPARC-II / 4GB RAM
- Solaris 10 05/08
-
"Wouter Sergeyssels" <[EMAIL PROTECTED]> writes:
> When doing a recover in a single-user backend we get the following
> error:
> $ postgres -D /var/lib/pgsql/data/ test
> PANIC: block 24929 unfound
This looks like it is probably a case of a design problem that was fixed
in 8.2: the WAL replay co
Tom Lane wrote:
> "Richard Broersma" <[EMAIL PROTECTED]> writes:
> > I am curious if the motivation is still valid for intentionally
> > omitting check sub-queries. (what was the motivation to begin with?)
>
> > Since we can effectively work around this limitation by doing the same
> > thing with
Em Saturday 06 September 2008 14:34:22 [EMAIL PROTECTED] escreveu:
> yes i am trying to build a alerting system where events will repeat
> weekly/monthly/annually
>
> what is the best way to store this kind of information in postgres?
Use timestamps. And model your application with them.
--
Jor
Howard Cole wrote:
> As part of my log configuration, I log statements that take over 3
> seconds. I find this very useful for optimising tables etc. The problem
> is that it produces verbatim some very large statements which can create
> huge log entries, which are probably responsible themselv
On Sat, Sep 6, 2008 at 10:32 AM, Jorge Godoy <[EMAIL PROTECTED]> wrote:
> Em Saturday 06 September 2008 14:12:49 [EMAIL PROTECTED] escreveu:
> > Hi
> > I want to store dates / events for example birthdays (or may 5th) that
> > repeats every year..
> > what is the best way to do in postgres?
> > if
On Sat, Sep 6, 2008 at 10:21 AM, brian <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
>> Hi
>> I want to store dates / events for example birthdays (or may 5th) that
>> repeats every year..
>> what is the best way to do in postgres?
>> if i use timestamp it is going to be use the current
Em Saturday 06 September 2008 14:12:49 [EMAIL PROTECTED] escreveu:
> Hi
> I want to store dates / events for example birthdays (or may 5th) that
> repeats every year..
> what is the best way to do in postgres?
> if i use timestamp it is going to be use the current year.. how do i do
> this?
Along
[EMAIL PROTECTED] wrote:
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do i do
this?
A timestamp includes the year so there shouldn't be any
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do i do
this?
Hi Team,
I have problems to setup SSL for PostgreSQL server. I did all the steps
which described in the documentation (17.8. Secure TCP/IP Connections
with SSL), but when I try to start the PostgreSQL server the pg_ctl gave
me: "could not start server". And nothing in the logs (I enabled all of
t
Dear,
I'm looking for an efficient way to process data that I have stored in a
staging table. This is syslog output, so it consists of text, where I
need regexes to filter it out. The data will be split into several/a lot
of tables.
I currently have a set of queries that
* read from staging a
Yeah, the backup is standard operating procedure before the start of the
release process.
I'm going to try a few of the suggestions offered here first, then fall back on
the fsync option if I can't get an appreciable increase in speed.
thanks all for the help and thoughts.
-Original Mes
On Fri, 5 Sep 2008, Tom Lane wrote:
The trouble with turning fsync off is that a system crash midway through
the import might leave you with a corrupt database. If you're willing
to start over from initdb then okay, but if you are importing into a
database that already contains valuable data, I
Hello,
When doing a recover in a single-user backend we get the following
error:
$ postgres -D /var/lib/pgsql/data/ test
PANIC: block 24929 unfound
Aborted.
All this was the result of an unclean postmaster shutdown while running
a VACUUM in single-user backend.
PGVERSION=8.1.6
DB S
On Thu, 4 Sep 2008, Lars Haugseth wrote:
http://www.amazon.com/PostgreSQL-Reference-Manual-SQL-Language/dp/0954612027/ref=pd_sim_b_1
Though I mostly use the online version, I'm considering buying these.
However, I'm probably going to kill myself if I find a new edition for
sale only a short wh
22 matches
Mail list logo
