Dnia Mon, 01 Jun 2009 09:29:30 -0400, Justin Carrera napisał(a):
> Hi,
>
> I'm trying to connect ruby to postgres on ubuntu and the only link I
> found that has the library is down. Does anyone have the postgres
> library for ruby? Or direct me to it?
It's in the libpgsql-ruby package.
--
S
> I have a webserver with postgresql. I would have a backup from this
> database. It should also be possible to query this backup solution.
> So I think slony would be a good choice. Am I right?
Slony will replicate the data from selected tables for you, and the
replicated database will be availab
so even the "malicious
> administrator" cannot see the data ?
Encrypt it. And keep the key on some other machine. And plan your
application so decryption happens on some other machine
--
------
| Marcin Kasperski | Commu
As in the title - is it possible to convert WAL for another architecture?
(source database on Linux/i386, contemplating chances to restore
backup on Linux/amd64)
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-admin
Did anybody face the same problem during the compilation of postgresql 8.2.5
on suse 10.2?
I'm using gmake 3.81
gcc -I../../include -I../../../../../src/interfaces/ecpg/include
-I../../../../../src/interfaces/libpq -I../../../../../src/include
-D_GNU_SOURCE -O2
-Wall -Wmissing-prototypes -Wpoi
: Authentication failure
FATAL: PAM authentication failed for user "mporwit"
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: server process (PID 1430) exited with exit code 0
Any insight here
Jürgen Ulrich wrote:
Hello,
Hi,
I hope this is what you're looking for:
add to your C code:
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
Regards,
Marcin
I have a problem with the postgreSQL Source Code when I compile the
fuzzystrmatch.c. I want to try to replace all german um
dress Foreign Address State
tcp 0 0 Portal:postgres *:* LISTEN
Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 10315 /tmp/.s.PGSQL.5432
So Can any body tell me whts the prob with this?? why I am not able to
conne
s into this database after setting
default_with_oids=true.
I don't have time inserting all database again.
I'm not subscribed.
Please CC to me: [EMAIL PROTECTED]
Marcin Kuk
---(end of broadcast)---
TIP 6: explain analyze is your friend
Dnia poniedziałek, 21 listopada 2005 16:31, Alvaro Herrera napisał:
> Marcin Giedz wrote:
> > Dnia poniedzia??ek, 21 listopada 2005 11:23, Mario Splivalo napisa??:
> > > Cool! :) Could you give specs on processors itself? The clock, cache,
> > > and stuff?
> >
Dnia poniedziałek, 21 listopada 2005 11:23, Mario Splivalo napisał:
> On Mon, 2005-11-21 at 10:58 +0100, Marcin Giedz wrote:
> > Dnia poniedziałek, 21 listopada 2005 10:34, Mario Splivalo napisał:
> > > On Sun, 2005-11-20 at 11:53 -0600, Jim C. Nasby wrote:
> > > &
ent RAID's for Postgresql - but
I will soon. However almost all people I know preffer RAID10 for database
like PGSQL.
Marcin
>
>
> Mike
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Tom Lane napisał(a):
Marcin Giedz <[EMAIL PROTECTED]> writes:
However I still can see 'spikey' performance but not as much as before
changes. What can I do more to eliminate or smooth these spikes?
The spikes are certainly caused by checkpoints. You can fool wit
still can see 'spikey' performance but not as much as before
changes. What can I do more to eliminate or smooth these spikes? I
tried to increase bg_writer_all_xxx parameters but.... spikes still
exists ;).
Regards,
Marcin
This is pretty nearly an ideal example of how NOT t
formance drops
Every 5 minutes (assuming default checkpoint settings).
You might also want to up wal_buffers and maybe checkpoint_segments.
OK many thanks, I will check.
On Wed, Nov 09, 2005 at 03:26:51PM +0100, Marcin Giedz wrote:
Hello.
I made some test comparing postgresql 8.0.4 base
almost all time on the same level but has much
less
performance than opteron. Is it normal?
Did anyone has similar tests/results?
BR,
Marcin
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
f you already do something like this?
Regards,
Marcin Giedz
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Ok guys... thanks you both ;) I've installed perl once again into
default location and now IT'S ALIVE !
Thanks once again.
Marcin
---(end of broadcast)---
TIP 6: explain analyze is your friend
d-linux.so.2 => /lib/ld-linux.so.2 (0x8000)
pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl#
But still problem with Perl_craok exists during creating lang plperl ;(
Marcin
---(end of broadcast)---
TIP 6: explain analyze is your friend
ion and
Report
ii perl-base 5.8.4-8The Pathologically Eclectic Rubbish Lister
ii perl-modules 5.8.4-8Core Perl modules
pgsql2-test:/usr/lib#
Marcin
if there isn't more then one on your system.
Sergiusz
---(end of broadcast)
Tom Lane napisał(a):
Marcin Giedz <[EMAIL PROTECTED]> writes:
I don't see any libperl.so :( But doesn't plperl use shared libperl library?
Yeah, it's supposed to. On an FC4 machine I get
$ ldd libplperl.so
linux-gate.so.1 => (0x00682000)
libpe
Dnia wtorek, 13 września 2005 17:24, Tom Lane napisał:
> Marcin Giedz <[EMAIL PROTECTED]> writes:
> >> createlang: language installation failed: ERROR: could not load library
> >> "/usr/local/postgresql-8.0.3/lib/plperl.so":
> >> /usr/local/po
Dnia wtorek, 13 września 2005 17:01, Marcin Giedz napisał:
Additional info: I've also checked plperl with postgresql snapshot - problem
still exists ;( -
didn't anyone have something similar? or maybe I'm only one who uses Sarge
3.1? :D:D
Marcin
> Dnia wtorek, 13 w
Dnia wtorek, 13 września 2005 14:42, Sergiusz Jarczyk napisał:
> Hi Marcin
>
> Marcin Giedz napisał(a):
> >Hello..
> >
> >I've installed plperl.so in postgresql lib directory but when I try to
> > create lang, such error occures:
> >
> >pgsql2-t
Dnia wtorek, 13 września 2005 14:18, Marcin Giedz napisał:
> Hello..
O I didn't mention what Linux .
Debian Sarge 3.1
kernel 2.6.12.5
perl lates 5.8.7 from sources
perl 5.8.4-8 from dselect
postgresql 8.0.3 from sources
>
> I've installed plperl.so in postgresql lib d
brary
"/usr/local/postgresql-8.0.3/lib/plperl.so":
/usr/local/postgresql-8.0.3/lib/plperl.so:
undefined symbol: Perl_croak
[EMAIL PROTECTED]:/root$
I've even compiled perl from sources but still have this error. What's going
on?
Thx,
Marcin
---
.lock alredy exist. How to avoid
this problem?
Hi,
You have to change port parameter in postgresql.conf - default is 5432
so leave 5432 for first instance and change to 5433 for the second one.
That's all.
BR,
Marcin
Regards
Marek
---(end of
Użytkownik Tom Lane napisał:
Marcin Giedz <[EMAIL PROTECTED]> writes:
Why I still have "out of memory" despite of changing not
overcommit_memory?
Because the 2.6.10 kernel is buggy :-( See this thread:
http://archives.postgresql.org/pgsql-general/2005-04/msg00342.php
O
s" was set to 5 and I havn't had this problem. Why I
still have "out of memory" despite of changing not overcommit_memory?
Thx,
Marcin
Here is a problem's log
Apr 15 14:17:35 pgsql1 kernel: oom-killer: gfp_mask=0x4d0
Apr 15 14:17:35 pgsql1 kernel: DMA per-cpu:
Apr 15 14:1
Hello...
Last time I found that about 200 schemas have appeared in my database. These
schemas are pg_temp_. What's this? Can I remove it safely or these
schemas will be removed automatically?
Thx,
Marcin
---(end of broadcast)---
TIP 6:
Dnia czwartek, 7 kwietnia 2005 10:49, Marcin Giedz napisał:
> Hello...
>
>
> Here is procedure of making everyday online backup:
> 1) select pg_start_backup('xxx');
> 2) tar -cf backup-xxx.tar /mnt/db/pg1
> 3) select pg_stop_backup();
> rm all archived WAL f
'm doing wrong?
Thx,
Marcin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Dnia Åroda, 16 marca 2005 15:05, Scott Marlowe napisaÅ:
> On Wed, 2005-03-16 at 07:46, Marcin Giedz wrote:
> > Dnia wtorek, 15 marca 2005 18:00, Scott Marlowe napisaÅ:
> >
> > OK now I know I mys query lasts so long:
> >
> > SELECT DISTINCT t1.Id, t1.IdTypNa
in tables?
Maybe some other query?
BR,
Marcin
> On Tue, 2005-03-15 at 10:17, Marcin Giedz wrote:
> > Dnia wtorek, 15 marca 2005 17:08, Scott Marlowe napisaÅ:
> > > On Tue, 2005-03-15 at 02:59, Marcin Giedz wrote:
> > > > Dnia poniedziaÅek, 14 marca 2005 19:32, Scott Marlo
Dnia wtorek, 15 marca 2005 17:08, Scott Marlowe napisaÅ:
> On Tue, 2005-03-15 at 02:59, Marcin Giedz wrote:
> > Dnia poniedziaÅek, 14 marca 2005 19:32, Scott Marlowe napisaÅ:
> > > On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote:
> > > > Hello...
> > > &g
Dnia poniedziałek, 14 marca 2005 19:32, Scott Marlowe napisał:
> On Mon, 2005-03-14 at 12:03, Marcin Giedz wrote:
> > Hello...
> >
> >
> > Our company is going to change SQL engine from MySQL to PSQL. Of course
> > some performance problems occured. Our server
ilter: (idjezyktyp = 2)
Total runtime: 3159.199 ms
(55 rows)
pl=#
I now query plan is not very readable but as you can see only one
seq scan occured for field "ulica" in table "adres" on the rest Index
scan were used. I'm rather new and really don
Dnia czwartek, 24 lutego 2005 15:39, Rick Apichairuk napisał:
> I think you should also state what operating system you are using.
Ohhh Debian Sarge of course ;)
>
>
> On Thu, 24 Feb 2005 14:54:46 +0100, Marcin Giedz
>
> <[EMAIL PROTECTED]> wrote:
> > Hello...
>
clients connected to mysql
server (we plan to switch to postgresql) but in the future there will be even
1 thousand clients. Can anyone please help me what should I change in
postgresql.conf to achieve very good performance ;)
Thx
Marcin
---(end of broadcast
here
FATAL 1: Index 'pg_shadow_name_index' does not exist <-- restarted again
FATAL 1: Index 'pg_shadow_name_index' does not exist
FATAL 1: Index 'pg_shadow_name_index' does not exist
---
What can I do??? I've got a non-trivial amount of data that I cannot afford
y fields and am clustering (vacuum + vacuum analyze done)?? Are there
any command line parameters I can try to increase performance..??
Thanks in ADvance
MarCIn
Tom Lane wrote:
> Marcin Kowalski <[EMAIL PROTECTED]> writes:
>> Is it possible that one of the system tables has been c
system tables has been corrupted and shows
multiple entries for the tables?? This makes me a bit worried about system
integrity. When I do a simple select * from tablename it works fine, what
does pg_dump do that I don't ???
Thanks in ADvance
MarCin
> Marcin Kowalski <[EMAIL PROTECT
executable??
chmod u+x postmaster
E) Rather use pg_ctl -D /home/database -o "-i" start 1>> database.log
2>>database.error.log
Regards
MarCin
bryan wrote:
> Dear all,
>
> I installed postgresql 7.03 and it works well in the first time.
> After I reboot the com
HI,
I couldn't find an answer in doc, so here's the question. Is it possible
to to have result similar to explain command in postgres log. I've turned
on plan in pg_options but results are not to readable for me (anyone has a
doc about it?). I need it to find queries which I can optimize by using
db without authorization. But now I have a problem
how to dump a db with cron. pg_dump requires me to type a username and
login. How to do a dump even as pg_superuser without authorization?
tia
mazek
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/
c# ls /usr/include/readline
chardefs.h history.h keymaps.h readline.h rlconf.h rlstdc.h tilde.h
mtldb:/usr/local/src/postgresql-7.0.2/src#
tia
mazek
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/
x27;;
UPDATE 0
Why I can't do it?
tia
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/
Hi,
can anybody help me with dropping unique constrint on attribute. I was
looking for it in pg_attributebut I think this is done in some other way.
How can I change it without recreating whole table.
tia
ps. list archives are unfortunately unusable...
Marcin Mazurek
--
Kierownik Działu
Hi,
I was wandering if it is possible to limit size (on fizical disks) used by
sigle db? quote works per user id or gid so ...
Is it at all possible, is it in plans for 7.1 or sth?
tia
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/
nkly
speaking i have no idea how to do it. Does anybodyhas such examples with
Connection pools?
mazek
Marcin Mazurek
--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/
hello,
does anybody know how to sort tables using other charachter sets (like polish
ISO8859-2 for exemple)
i use postgres 6.5.1 and 6.4.x
--
Marcin Inkielman
52 matches
Mail list logo
