Hi,
I send some additional info :
pginfo wrote:sklad05=# explain analyze select
S.IDS_NUM,S.IDS_SKLAD,SUM(S.KOL),S.sernum FROM A_GAR_PROD_R S where ids
< 9742465 GROUP BY S.IDS_NUM,S.IDS_SKLAD ,s.sernum limit 10;
QU
Hi ,
I try to make insert into myTable select on pg 8.0.1 and freeBSD 5.3.
After ~10 sec. pg returns "out of memory".
In log file I found:
Portal hash: 8192 total in 1 blocks; 2008 free (0 chunks); 6184 used
Relcache by OID: 8192 total in 1 blocks; 4040 free (0 chunks); 4152 used
Relcache by n
Hi all,
I am searching for good working HW RAID controller.
I will use linux as OS.
Also I will use SCSI.
I readet the docs about adaptec AHA2120S, but do not find any comments
about the driver supprt and how stable is for linux.
Any ideas?
Of course I will use it for pg.
many thanks,
ivan.
-
Hi,
I am using linux cron and pg_dump.
It is working very well.
After you have dump-file you can move it to remote pc.
regards,
ivan
Edgars wrote:
Hi!
is here anyone familar with subj.? How that could be implemented? I'm
using postgresql on Debian system.
Is it possible only on the same server whe
Hi all,
We are using pg as db for many erp installations.
In general it is working great.
But at the monet I have problem (I think it is database corrupted, but I
am not sure) by running pg_dump.
I receive this message:
pg_dump acc01 > dmpacc01
pg_dump: query to obtain list of data types failed: ER
Hi all,
I try to find OS with better performance.
At the mement we are using linux RH AS 3.0 and I think it is not the
best possible.
So my test server:
Dual Pentium III 1 GHz
1.5 GB ram
30 GB ATA 7200 HDD.
pg 7.4.2
I installed freebsd 5.2.1 (It is my first try on it).
and ran the same db and pg
Sorry for my question about trigger in "C".
A found the good example.
regards,
ivan.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Hi,
where can I find trigger example writen in "C" ?
I have many made in pgSQL, but I have performance problems and I will
try to rewrit in "C".
regards,
ivan.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
Hi,
use ssh if you need only terminal or vnc if you will need X.
regards,
ivan.
vidhya wrote:
Hi, I
want to access the Linux server in US from win2k in India. Do
you have any service like terminal services client to access the Linux
server. Thank u, Regards, Vidhya.
Hi,
I try to rebuild my pg 7.4 to get generated jdbc driver.
If I run gmake it stops with error (without --with-java option I do not
have any problems to complite it).
I send the error message (one part from message):
gmake[5]: Nothing to be done for `all'.
gmake[5]: Leaving directory `/pginst/po
Hi ,
We are using pg as oracle alternative on ~30 production db servers.
Also we are planing to migrate all oracle servers to pg if we can get
stable config.
After 6 m. of intensive use of systems by diferent customers we do not
know what for filesystem to install.
In this time we are using linu
Hi,
Sam Barnett-Cormack wrote:
> Is pg7.4 not available through the apt system at all?
>
I do not know.I prefer to compile pg self.
And also I found the problem.
I needet libreadline4-dev and zlib1g-dev.
It is working now.
regards,
ivan.
> On Sun, 23 Nov 2003, pginfo wrote:
>
Hi all,
I just tryed to compule 7.4 on debian 3.0.
It is my first try to compile pg on debian ( I was using redhat to this
moment), sorry for my question.
Aftre ./configure --bindir=/usr/bin --libdir=/usr/lib/pgsql
I recive error:
configure: error: zlib library not found
If you have zlib alread
Stephan Szabo wrote:
> On Tue, 11 Nov 2003, pginfo wrote:
>
> > > > It is possible to be one not closed transaction, but in this case nobody will
> > > > be
> > > > able to modify this table (tables) and
> > > > the system will stop
Stephan Szabo wrote:
> On Tue, 11 Nov 2003, pginfo wrote:
>
> > Stephan Szabo wrote:
> >
> > > On Tue, 11 Nov 2003, pginfo wrote:
> > >
> > > > The result by is:
> > > > acc01=# select * from pg_locks;
> > > >
Hi,
Stephan Szabo wrote:
> On Tue, 11 Nov 2003, pginfo wrote:
>
> > The result by is:
> > acc01=# select * from pg_locks;
> > relation | database | transaction | pid | mode | granted
> > --+--+-+---+---
On Tue, 11 Nov 2003, pginfo wrote:
>
> > Hi,
> > I can not be sure if it is not the case.
> > But we are usin this system on a number of servers and it happen only by
> > one.
> > Can I with a pg_locks help detect the query that is running?
>
> It won
Hi,
I can not be sure if it is not the case.
But we are usin this system on a number of servers and it happen only by
one.
Can I with a pg_locks help detect the query that is running?
regards,
ivan.
Stephan Szabo wrote:
> On Tue, 11 Nov 2003, Antonis Antoniou wrote:
>
> > Guys, does anyone has a
Hi,
I try to reindex and reindex run ok, but the vacuum still not running.
regards,
ivan.
Antonis Antoniou wrote:
> pginfo wrote:
>
> >Hi,
> >I am running pg 7.3.4 on linux red hat 9.0.
> >
> >If I try to execute vacuum full analyze verbose, the pg vacuum some
>
Hi,
I am running pg 7.3.4 on linux red hat 9.0.
If I try to execute vacuum full analyze verbose, the pg vacuum some
tables and hang after this lines:
INFO: --Relation pg_toast.pg_toast_16408--
INFO: Pages 0: Changed 0, reaped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, UnUsed 0, MinLen 0, Ma
Andrew Sullivan wrote:
> On Tue, Oct 28, 2003 at 03:12:37PM +0100, pginfo wrote:
> > >
> >
> > I do not have made any patchin on my kernel.I used the standart reiserfs
> > with my linux distro.
>
> Yes, but have you kept up to date with new kernel releases
Hi Andrew,
Andrew Sullivan wrote:
> On Mon, Oct 27, 2003 at 06:21:40PM +0100, pginfo wrote:
> > Hi all,
> > I am using pg 7.3.4 on linuz red hat 7.3 and reiserFS.
>
> How sure are you that your patch level for your kernel is good? ISTR
> some issues with reiserfs on som
Hi all,
I am using pg 7.3.4 on linuz red hat 7.3 and reiserFS.
After ~30 days error free work my pg stops.
I my log I found:
PANIC: open of /mnt/diske/skladdb/pg_clog/0D02 failed: No such file or
directory
LOG: statement: COPY public.a_sp (ids, ids_ma, ids_mp, ids_mr, ids_mpr,
ids_mpdt, ids_mpkt,
Hi,
yes I can type reboot, but the system can not reboot.
I tested the memory (it take ~20 h - the maximum test) without any problems.
I do not see any reason to think that the problem is into the HW/OS.
At the moments I install red hat 9.0 to be sure that the problem is not
by kernel.
regards,
iv
Sorry the last message was for pgAdmin mailing list.
Pls. ignore it.
It was my type mistake and I am very sorry.
regards,
ivan.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/F
Hi,
I try to install the latest pgAdmin3 on my workstation.
It is running red hat 7.3.
I make the installation from source.
By running ./configure I got this message:
you must specify a valid pgsql instalation wit --with-pgsql=DIR.
I installed also the latest pg 7.3.4. ( I do not deen it on my
wor
scott.marlowe wrote:
> On Fri, 12 Sep 2003, pginfo wrote:
>
> > Hi,
> > I am runing linux red hat 7.3 (standart install)
> > on dual athlon box , 1 GB ram and pg 7.3.4.
> >
> > If I try to access with pgAdmin one from my tables (i contains ~ 1 M
> > re
Tom Lane wrote:
> pginfo <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> You have a corrupt table. Can you drop and recreate a_acc?
>
> > Yes I can.The problem is that it is happen for 4 times in this week.
>
> Oh? Perhaps you should be looki
Hi,
Tom Lane wrote:
> pginfo <[EMAIL PROTECTED]> writes:
> > In my pg log I can find:
> > ERROR: Invalid page header in block 5604 of a_acc
>
> You have a corrupt table. Can you drop and recreate a_acc?
>
Yes I can.The problem is that it is happen for 4 times i
Hi,
I am runing linux red hat 7.3 (standart install)
on dual athlon box , 1 GB ram and pg 7.3.4.
If I try to access with pgAdmin one from my tables (i contains ~ 1 M
records)
the linux box crashes.
In my pg log I can find:
ERROR: Invalid page header in block 5604 of a_acc
before this error I see
Hi all,
I posted today message about pg globals directory corruption.
I am using pg 7.3 on linux with reiserfs.
My problem is where to find more info about the pg structure.
To this moment I created one new db with the same structure as my
original.
I was able to finf the filename of one from my
Hi all,
after many months of well working I was very supporaised that my pg do
not work.
It is produktion server.
I checked the pd directory and found that the global directory was
destroyed.
In my system it is file owned by root( I do not know how is it happen).
All other directories are there (
I want to share a Postgres DB between 2 servers,
Both these systems will be running Postgres,I need to share the Database files,
these files need to be stored on a file server, Do I only copy the /base directory to
the file server
and mount this directory on /var/lib/pgsql/base. ?
Both system
33 matches
Mail list logo
