data dir>/base/"
>
I was able to find that in FreeBSD the -U in ls (1) does the job.
However i could not find any inode creation time related info for linux
(ext3).
Anyone has any clue on that?
> ---(end of broadcast)---
> TIP 6
Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε:
> Achilleas Mantzios wrote:
> > I was able to find that in FreeBSD the -U in ls (1) does the job.
> > However i could not find any inode creation time related info for linux
> > (ext3).
> >
investigation.
Could you think of a reason for this "signal 7" caught by the pgsql server?
Memory or other HW problem maybe?
Thank you.
--
Achilleas Mantzios
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Στις Δευτέρα 22 Ιανουάριος 2007 18:01, γράψατε:
> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> > In one of our remote pgsql 7.4.2 installations (no tcp/ip, no mgetty
> > dialin works always), i got the above message.
>
> Since you have not told us what the plat
Στις Τρίτη 23 Ιανουάριος 2007 16:25, γράψατε:
> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> >> Since you have not told us what the platform is, there is no way to
> >> guess what signal 7 means.
> >
> > Its a Bus error (SIGBUS). Those remote servers run
me such, which doesn't include the regression test files.
> > Try downloading the full tarball (I don't know what is it named).
> >
> > I wonder if it isn't time to remove the split tarballs. Do they buy us
> > anything?
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
--
Achilleas Mantzios
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
; Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
--
Achilleas Mantzios
-
ATE INDEX album_idxFTI_idx ON album USING gist(idxFTI);
> >>
> >> CREATE TRIGGER album_tsvectorupdate BEFORE UPDATE OR INSERT ON album
> >> FOR EACH ROW EXECUTE PROCEDURE tsearch2(idxFTI, name);
> >>
> >> SELECT * FROM album WHERE idxfti @@ to_tsquery('spiderman');
> >>
> >>
> >> Hopefully that helps...
> >>
> >> On Thu, 1 Feb 2007, Alexander B. wrote:
> >>> Hi,
> >>>
> >>> I need to install tsearch2, but I couldn't find a procedure
> >>> (step-by-step).
> >>> Could you recomend some site or some steps to install.
> >>>
> >>> I used PG 8 on Suse and Debian, and I installed postgres by source.
> >>>
> >>> Thanks in advance.
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> ___
> >>> Yahoo! Mail - Sempre a melhor op??o para voc?!
> >>> Experimente j? e veja as novidades.
> >>> http://br.yahoo.com/mailbeta/tudonovo/
> >>>
> >>> ---(end of
> >>> broadcast)---
> >>> TIP 7: You can help support the PostgreSQL project by donating at
> >>>
> >>> http://www.postgresql.org/about/donate
>
> ___
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
--
Achilleas Mantzios
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
acuum = on
> autovacuum_naptime = 3600
> autovacuum_vacuum_threshold = 5000
> autovacuum_analyze_threshold = 2500
> autovacuum_vacuum_scale_factor = 0.4
> autovacuum_analyze_scale_factor = 0.2
> autovacuum_vacuum_cost_delay = -1
> autovacuum_vacuum_cost_limit = -1
> lc_messages = 'de_DE.UTF-8'
> lc_monetary = 'de_DE.UTF-8'
> lc_numeric = 'de_DE.UTF-8'
> lc_time = 'de_DE.UTF-8'
>
> log_filename = 'postgresql.%Y'
>
> mfg zmi
--
Achilleas Mantzios
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Στις Δευτέρα 05 Φεβρουάριος 2007 23:36, ο/η Michael Monnerie έγραψε:
> On Montag, 5. Februar 2007 15:22 Achilleas Mantzios wrote:
> > This ERROR is normally thrown when you *try* to violate a unique
> > constraint. Can you demonstrate the presence of the UNIQUE constraint
> >
ons to facilitate debugging or core dump analysis should
> it be necessary.
>
> Any guidance on this would be much appreciated.
>
> Andrew
>
>
> ---(end of broadcast)---
> TIP 5: don't forget to increase your free space map
Στις Τετάρτη 07 Φεβρουάριος 2007 16:31, ο/η Achilleas Mantzios έγραψε:
> Στις Τετάρτη 07 Φεβρουάριος 2007 02:15, ο/η Andrew Hammond έγραψε:
> > I'm looking for a document on best practices for building and
> > operating PostgreSQL on FreeBSD (amd64). Does such a thing alrea
e appropriate. Attempt to violate a UNIQUE CONSTRAINT
is an erroneous act.
> Efharisto, Achilleas!
Bitte Sen!
>
> mfg zmi
--
Achilleas Mantzios
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
is not doing you
any good, since you simply recode those chars in UTF-8 to their latin2
counterparts.
How about
translate('your slovak text','éěáäš','eeaas');
>
> pls help
--
Achilleas Mantzios
---(end of broadcast)---
TIP 6: explain analyze is your friend
on (or catalog view) that I can call in psql and that
> will tell me host name of the machine on which Postgres database is
> running?
>
> Igor
--
Achilleas Mantzios
---(end of broadcast)---
TIP 6: explain analyze is your friend
e dump of this mirror db.
>
> Now we are using it like this:
> pg_dump -f /home/backup/DB.sql -d -Fp -v DB
>
> thx
> Lukas
--
Achilleas Mantzios
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
atabase,
> > and nullify these bytea columns in the mirror db before
> > taking the dump of this mirror db.
> >
> >> Now we are using it like this:
> >> pg_dump -f /home/backup/DB.sql -d -Fp -v DB
> >>
> >> thx
> >> Lukas
> >
Στις Παρασκευή 09 Μάρτιος 2007 15:05, ο/η Milen A. Radev έγραψε:
> Achilleas Mantzios wrote:
> > Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε:
> >> Hello,
> >>
> >> pg_dump can avoid bloob fields (it can dumb without blobs), but as I
> >> u
> message can get through to the mailing list cleanly
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
--
Achilleas Mantzios
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Unix/Windows
Debian/FreeBSD behaviour is exactly the same, it is on windows that you should
try to make it work.
> TIA
>
> Joost
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>
_
>_ Get the free Yahoo! toolbar and rest assured with the added
> security of spyware protection.
> http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
>
> ---(end of broadcast)---
> TIP 6: explain analyze is y
Στις Πέμπτη 19 Ιούλιος 2007 12:29, ο/η Abraham, Danny έγραψε:
> Thanks
>
As a first measure, stop posting HTML attachments, and then see how it goes :)
> Danny Abraham
>
> [EMAIL PROTECTED]
--
Achilleas Mantzios
---(end of broadcast)--
tually
2) Transactions either have the autocommit flag on, are commited or are
rollbacked.
>
> Thanks for help
--
Achilleas Mantzios
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Στις Τετάρτη 31 Οκτώβριος 2007 23:47, ο/η Scott Marlowe έγραψε:
> On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > � 30 � 2007 10:45, �/� Patrick De
Zlio ��:
> > > Hi,
> > >
> > > We are running PostgreSQL 8.2
og?
Those patches are supposed to make IPC run without collisions in many jails,
thus solving the
classic problem with postgresql, allowing the admin to use the same uid, PGPORT
in all pgsql
server instances.
Do you know if any of this stuff make it anywhere in official FreeBSD?
--
Achilleas
-(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Achilleas Mantzios
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
-(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
>
--
Achilleas Mantzios
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
it possible to lose this problem?
> HELP!!!
>
maybe take a look at your lost_found dir under the fs in question.
--
Achilleas Mantzios
KOSOVO IS SERBIA FOR EVER
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Friday 28 March 2008 14:39:53 ο/η A.Burbello έγραψε:
> ls -t1p | grep -v / | grep -v backup | head -1
maybe:
ls -t1p | grep -v / | grep -v backup | grep -v `ls -t1p | grep -v / | grep -v
backup | head -1`
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-ad
Στις Friday 28 March 2008 14:39:53 ο/η A.Burbello έγραψε:
> ls -t1p | grep -v / | grep -v backup | head -1
maybe:
ls -t1p | grep -v / | grep -v backup | grep -v `ls -t1p | grep -v / | grep -v
backup | head -1`
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-ad
Στις Friday 28 March 2008 19:38:02 ο/η salman έγραψε:
>
> Achilleas Mantzios wrote:
> > Στις Friday 28 March 2008 14:39:53 ο/η A.Burbello έγραψε:
> >> ls -t1p | grep -v / | grep -v backup | head -1
> >
> > maybe:
> > ls -t1p | grep -v / | grep -v backu
ocess will not be any easier.
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Wednesday 16 April 2008 12:52:45 ο/η Tino Schwarze έγραψε:
> On Wed, Apr 16, 2008 at 12:35:26PM +0300, Achilleas Mantzios wrote:
> > Hi, i just started the process of migrating from 7.4 to 8.3.1.
> > On restoring, apart from the easily explainable ERRORs (both in DDL, COPY),
Στις Thursday 17 April 2008 08:25:22 ο/η Tom Lane έγραψε:
> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> >> Did you make the dump using 8.3's pg_dump?
>
> > Yes, with 8.3.1's pg_dump (data only dump)
>
> That would be your problem. *Don&#x
Στις Thursday 17 April 2008 08:46:24 ο/η Achilleas Mantzios έγραψε:
> Στις Thursday 17 April 2008 08:25:22 ο/η Tom Lane έγραψε:
> > Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> > >> Did you make the dump using 8.3's pg_dump?
> >
> > > Yes, with
> Is there a method to do so?
>
smth like
dynacom=# SELECT extract(epoch from '49 hours 0 mins 12 seconds'::interval);
> --
> Julius Tuskenis
> Programavimo skyriaus vadovas
> UAB nSoft
> mob. +37068233050
>
>
--
Achilleas Mantzios
--
Sent via pgsql-a
forward...
>
No idea why. However as you pose it,it makes sense.
>
> Achilleas Mantzios rašė:
> > Στις Monday 12 May 2008 16:44:16 ο/η Julius Tuskenis έγραψε:
> >
> >> Hello,
> >>
> >> Is there a good method of knowing how mutch seconds does some
Στις Monday 12 May 2008 18:09:11 ο/η Tom Lane έγραψε:
> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> > Στις Monday 12 May 2008 17:32:39 ο/η Julius Tuskenis έγραψε:
> >> do you know why division of intervals was not implemented? As I see it -
> >> there should
Στις Tuesday 13 May 2008 11:22:28 ο/η Scott Marlowe έγραψε:
> On Tue, May 13, 2008 at 12:56 AM, Achilleas Mantzios
> <[EMAIL PROTECTED]> wrote:
> > Monday 12 May 2008 18:09:11 �/� Tom Lane ��:
> >> Achilleas Mantzios <[EMAIL PROTECTED]> writes:
> &
0 Μαϊ 09:00 /var/log/pgsql.log
This works in my FreeBSD system, although with 7.4.*, i dont have any 8.3.1
handy at the moment.
>
>
>
> I dont see any files show up in /var/log
>
> what am I doing wrong?
>
> Thanks in advance..
>
> /Kevin
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
gt; > web: http://www.inprint.ru/
> >
> > --
> > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-admin
> >
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
options?
pg_dump by default ommits OIDs.
However why do you want to completely remove OID functionality?
space usage?
>
> 2. Alter encoding from C to utf8.
there is a script hanging around to do just that.
(i miss it at the moment)
>
> Cheers,
> Steve
>
>
>
--
Ac
ECT * FROM xxx
> > WHERE >= CAST('2008-05-20' as timestamp) AND
> >< CAST('2008-05-21' as timestamp)
> >
> > Regards
> > Roberto Garcia
> >
> >
> >
>
>
> Roberto Garcia
> Banco de Dados, MSc
> Fone: (12) 3186-8405
> --
> A luta contra o aquecimento global depende de cada um de nós, faça sua parte,
> economize recursos naturais.
> --
> http://www.cptec.inpe.br
> http://www.inpe.br
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
; index scan.
Then create an additional index like
CREATE INDEX tablename_tscol_date on tablename (date(tscol));
where tscol is timestamp
>
> Achilleas Mantzios wrote:
> > Why not simply,
> > SELECT * FROM xxx WHERE ::date = '2008-05-20'::date;
> >
> > Στ
ror: could not open file "/root/documents/log.sql" for
> writing: Permission denied
> what can i do for repair this error??
>
The best thing you can do is get yourself familiar with a UNIX environment.
Apparently the user on behalf of which, you run psql, cannot write to
bk_id requires it
> SQL state: 2BP01
> Hint: You may drop table b_prekes_br_kodas column pbk_id instead.
>
> --
> Julius Tuskenis
> Programavimo skyriaus vadovas
> UAB nSoft
> mob. +37068233050
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list
y there, now I wan to
> >know how many and what other foreign keys are referencing this primary
> >key... did this check long time ago and totally forgot how I did it then....
>
> Thanks a log,
> Jessica
>
>
>
>
--
Achilleas Mantzios
--
Sent via p
anything
about the opposite.
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
> If you have any problem with our services ,
> please contact us at 70468146 or e-mail: [EMAIL PROTECTED]
> PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
.
You can enable/disable this kind of logging any time by killing -HUP
>
> regds
> Mallah.
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Friday 08 August 2008 09:21:22 ο/η Курашкин Дмитрий έγραψε:
maybe the listen_addresses in postgresql.conf in Server installation?
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
s the design of the DB.
The lower end you get mysql->sql server->access->COBOL, etc...
the greater chance you need a re-engineering of the schema.
> Carol
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
at he can put the data
> into a postgres database by running a MySQL query? It doesn't sound
> possible to me.
If his query is like:
SELECT 'INSERT INTO PostgreSqlTable(...) VALUES(''||somevalue...||'')' FROM
mysqltable
then it is possible
&g
> http://www.postgresql.org/docs/current/static/release-8-3.html
> http://www.postgresql.org/docs/current/static/release-8-2.html
>
> I believe you should first check the casting changes in 8.3 .
>
> Regards,
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql
but our 7.4 -> 8.3 upgrade was pretty
painful.
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
the maximum number of
> open file descriptors.
> Is there anything we could do about this max_files_per_process limit or any
> other way to speed up inserts to all these tables?
>
> Any suggestions are wellcome.
>
> Kind regards,
> Dilek Küçük
>
--
Achilleas
;
> mfg zmi
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
81127?
take a look at
http://archives.free.net.ph/message/20080924.191644.d692f468.el.html
> What can I do about the missing chunk? I need the data in there...
>
> mfg zmi
>
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Tuesday 17 February 2009 17:11:41 ο/η Michael Monnerie έγραψε:
> "Achilleas Mantzios" schrieb:
> > did you reindex pg_toast_1281127?
> > take a look at
> > http://archives.free.net.ph/message/20080924.191644.d692f468.el.html
>
> REINDEX TABLE pg_toast
URN NEW;
END
$$ LANGUAGE plpgSQL;
CREATE TRIGGER foofunc_trig AFTER INSERT ON test1 FOR EACH ROW EXECUTE
PROCEDURE foofunc();
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ou or your
> employer does not consent to Internet email for messages of this kind.
> Opinions, conclusions and other information in this message that do not
> relate to the official business of my firm shall be understood as neither
> given nor endorsed by it.
>
>
--
Achi
d over SSH. Is it safe
> such technique?
>
Why do you want a simple password? How about protection against your local
(Unix) users?
They could:
SELECT * from pg_user ;
and then try a dictionary attack on the password.
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin
gives
fooname
-
Cylinder Liner No1
Cylinder head No1
Cylinder head cover No1
Database encoding is SQL_ASCII in all four cases.
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
tings, i am just asking if there is a
way to solve the issue now without waiting till
the migration to 8.4
Thanx!
Στις Tuesday 02 February 2010 14:26:44 ο/η Achilleas Mantzios έγραψε:
> Hi, i have the following problem, text ordering seems to behave incosistently
> across various lc_col
Στις Tuesday 02 February 2010 17:37:05 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > What is the shortest way to change the default locale on a production
> > installation running PostgreSQL-8.3.9?
> > Is there anything less painful than dump, initdb,restore?
>
Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
> On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
> > It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
> > are two different stories, hence the seen results.
>
> The UT
Στις Wednesday 03 February 2010 21:16:36 ο/η Peter Eisentraut έγραψε:
> On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote:
> > Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε:
> > > On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
>
ooks like the import is not working as expected.
Are you getting any messages during dump/restore?
>
> Any idea what the problem is ?
>
> Kindly regards
>
> Lutz
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
Στις Tuesday 09 February 2010 11:54:38 ο/η Lutz Steinborn έγραψε:
> On Tue, 9 Feb 2010 11:35:45 +0200
> Achilleas Mantzios wrote:
>
> > Ξ£ΟΞΉΟ Tuesday 09 February 2010 10:48:31 ΞΏ/Ξ· Lutz Steinborn
> > ΞΞ³ΟΞ±ΟΞ΅:
> > > Hi,
> > >
> > > the
struggling with
http://pgfouine.projects.postgresql.org/tutorial.html
(having failed with http://bucardo.org/wiki/Pgsi which wants only syslog)
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
etwork
access to the server
(only ultra expensive unreliable satellite comms)
Thanks for any hints...
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε:
> 2010/4/22 Achilleas Mantzios :
> > Hello,
> > i have this serious problem in one of our remote vessels. (comm is done by
> > minicom to the remote satelite modem)
> > I think that this server was
Στις Thursday 22 April 2010 17:42:33 γράψατε:
> Achilleas Mantzios writes:
> > Then i did: (as i said i do not need the contents of msgsource - yet the
> > contents of msgno are vital)
> > dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013
> >
Στις Thursday 22 April 2010 19:02:00 ο/η Cédric Villemain έγραψε:
> 2010/4/22 Achilleas Mantzios :
> > Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε:
> >> 2010/4/22 Achilleas Mantzios :
> >> > Hello,
> >> > i have this serious problem i
pressed data is corrupt
pg_dump: The command was: COPY public.mail_entity2 (msgno, entno, entparentno,
entdate, entrecvdate, entsendername, entsenderaddr, entmessageid, e;
srv:~>
Is there anything i could do to take this very much wanted dump?
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Friday 23 April 2010 17:05:46 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > Then i did
>
> > # CREATE TABLE mail_entity2 AS SELECT * FROM mail_entity;
>
> > which went fine
>
> > but, for some crazy reason, pg_dump on mail_entity2 also results
ou're talking unix/linux machines, then
> > /etc/hostname _should_
> > have the current hostname in it, so:
> >
> > create temp table foo (t text);
> > copy foo from '/etc/hostname';
> > select * from foo;
> > drop table foo;
> >
holding e.g. image bitmaps)
will have bigger size in the dump rather than
on disk's raw data, since it is compressed there.
In our case the dump is twice the size of the db on disk, but generally i think
there cant be no universal rule of what is
larger than what.
> -Kevin
>
>
Στις Friday 28 May 2010 11:45:17 ο/η Ravi Katkar έγραψε:
> Hi ,
>
> What is the Oracle's Long data type equivalent data type in Postgresql ?
>
int8 i guess
> Regards,
> Ravi katkar
>
>
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing l
3 weeks.
> We also recently upgraded from postgres 8.3.6 to 8.4.5, althought it also
> worked fine for a few months.
> Upgrading to postgres 9 is easy for us. however, not sure that would help.
>
> Some info of our server:
>
> OS: Centos 5.5
> Kernel: 2.6.18-194.1.el5
> Postgres version: 8.4.5 (installation out-of-the-box using yum)
> Server memory: 28GB
>
>
> Any help would be appreciated
>
> Pablo
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
dvice anyway.
>
> To run *memtest86 *we have to go to the datacenter and that will take us a
> few days. Is there anything we can do remotely?
>
> Could it be anything different than memory HW problem?
> Btw, we are not using that server at the moment :)
>
> Thanks
>
&g
> Handle 0x1106, DMI type 17, 28 bytes
> > Memory Device
> > Array Handle: 0x1000
> > Error Information Handle: Not Provided
> > Total Width: 72 bits
> > Data Width: 64 bits
> > Size: 4096 MB
> > Form Facto
om) which dials up a remote mgetty
(which works only if the weather conditions are ok, and nothing else is broken:
read if we are lucky)
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
tion about versions, yes both are 8.3.3, and the pg_dump used to
diff the schemas was from 8.3.3
Στις Monday 22 November 2010 16:58:17 ο/η Kevin Grittner έγραψε:
> Achilleas Mantzios wrote:
>
> > One (ON DELETE CASCADE) FK constraint which was supposed to be
> > there was found
ues)
> or trying to load a dump script into an older major server version
> than it was designed for (and ignoring the ensuing error messages).
>
> regards, tom lane
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Στις Monday 22 November 2010 18:45:28 γράψατε:
> Achilleas Mantzios wrote:
>
> > (imagine having to upgrade 61 installations for which you dont
> > have ssh/scp ;) sounds fun right? )
>
> I don't have to imagine -- been there, done that. (Not with ships
> but
Στις Tuesday 23 November 2010 17:22:29 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > At this time our problematic vessel was running 7.4.2. This vessel upgraded
> > to 8.3.3
> > some time in January 2009.
>
> 7.4!?
>
> I can't shake the suspici
here is only 7.4/old hardware or a combination of 7.4 and the old
hardware to blame.
> regards, tom lane
>
>
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
teristics of parallel
computing was realized in
IBM's Parallel Sysplex technology:
http://en.wikipedia.org/wiki/IBM_Parallel_Sysplex
On top of it, someone could have CICS, DB2,etc... almost any available
application.
It would be interesting to know if there is some concept close to it in
t the said
connection.
I think it would be better to have this user reported in the log files. (or
have another entry e.g. %U to denote that)
--
Achilleas Mantzios
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
Στις Wednesday 29 December 2010 16:06:41 ο/η Achilleas Mantzios έγραψε:
> Hello,
> i noticed that the user name as displayed in the postgresql log (specified by
> %u) in the log_line_prefix
> does not show the user name of the effective user (current_user)as set by
> "SET S
tates ms,mariner m where
ms.endtime IS NOT NULL AND ms.marinerid=m.id;
count
---
54168
(1 row)
Time: 42.224 ms
In 8.3 the Total runtime is only double the value of the actual time.
Is there anything that can shed some light on this?
--
Achilleas Mantzios
--
Sent via pgsql-admin m
Στις Tuesday 11 January 2011 18:19:11 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > I have noticed that in 9.0.2 EXPLAIN ANALYZE takes considerably longer time
> > to return than the actual query. I never noticed this in 8.3.
>
> Same hardware? What it sounds like
Στις Wednesday 12 January 2011 17:07:53 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > Regarding gettimeofday (2), i wrote this program :
> > #include
> > #include
> > #include
> > int main(int argc,char** argv) {
> > struct tim
Στις Wednesday 12 January 2011 21:17:00 ο/η Alex Hunsaker έγραψε:
> 2011/1/12 Achilleas Mantzios :
>
> >
> > Changed that to smth like: micros_total = micros_total + (double) micros;
> > instead of the printf to beat any compiler optimization, and still linux
y_test
micros_total=129491437864563859521536.00
real0m15.506s
user0m0.517s
sys 0m1.161s
So, the FBSD_TEST case although still involves some kernel overhead, it is
faster than LINUX_PROD
(but i am puzzled as to where those 15.5 secs come from since 1.16+
>
>
> Regards,
>
>
Στις Wednesday 12 January 2011 18:45:20 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > Στις Wednesday 12 January 2011 17:07:53 ο/η Tom Lane έγραψε:
> >> Right offhand I'd wonder whether that was more bound by gettimeofday or
> >> by printf. Please t
Στις Thursday 13 January 2011 14:13:21 ο/η Achilleas Mantzios έγραψε:
> SELECT distinct
> m.id,coalesce(m.givenname,''),coalesce(m.midname,''),m.surname from
> marinerstates ms,vessels vsl,mariner m
> where m.id=ms.marinerid and ms.vslid=vsl.id and ms.state=&#x
Στις Wednesday 12 January 2011 18:45:20 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > Στις Wednesday 12 January 2011 17:07:53 ο/η Tom Lane έγραψε:
> >> Right offhand I'd wonder whether that was more bound by gettimeofday or
> >> by printf. Please t
Στις Thursday 13 January 2011 16:13:23 ο/η Achilleas Mantzios έγραψε:
>
> Next step, if i am lucky tonight, i'll set up a new linux box with 9.0.2 and
> load
> the same small (coming from FBSD_DEV) database.
>
> So my problem was twofold : a) EXPLAIN ANALYZE perform
1 - 100 of 138 matches
Mail list logo
