On Thu, May 20, 2010 at 10:59 PM, Kevin Kempter
wrote:
> Can I copy from one db (via COPY) and pipe the results to a psql/COPY stmt so
> I can load the data into a table in the second db 'inline' without writing to
> & reading from a flat file?
That's pretty much what
pg_dump -t tablename -d dbn
In response to Kevin Kempter :
> Can I copy from one db (via COPY) and pipe the results to a psql/COPY stmt so
> I can load the data into a table in the second db 'inline' without writing to
> & reading from a flat file?
Yes, but keep in mind, COPY cant create the table on the destination. If
th
Can I copy from one db (via COPY) and pipe the results to a psql/COPY stmt so
I can load the data into a table in the second db 'inline' without writing to
& reading from a flat file?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
On Thu, May 20, 2010 at 11:29 PM, Richard Walker wrote:
>
> If I understand your scheme, this works in a scenario
> where the row being updated is in some sense "owned" by a
> particular user, who must provide some other data (a "password")
> not otherwise stored in the database in order
> to decr
Peter Hunsberger wrote:
Can you use an external key store? If not, I can't see this as being
a serious attempt at security, but playing along, you could try
something like the following:
1) Symmetrically encrypt a randomly generated string with something
based on the users credentials (user nam
On Thu, May 20, 2010 at 8:03 PM, Richard Walker wrote:
> Peter Hunsberger wrote:
>>
>> If you really need security of some form at the physical database
>> level then don't screw around with convoluted hacks. Encrypt the
>> critical data in the database and be done with it.
>
> If the hacker gets
I'm writing in desperate hope that something like this exists... because
if so, it would make my life a lot easier. I want to be able to:
a) Roll back a transaction
b) Receive a notification when retrying the exact same transaction might
cause different data to be returned from something that wa
Alvaro Herrera wrote:
Excerpts from Richard Walker's message of jue may 20 02:19:17 -0400 2010:
(a) (ii) It seems a breach is possible via the xmin values.
In that case, what about doing updates inside a transaction
that does a trivial update of all rows, e.g.:
begin transaction;
update m
Peter Hunsberger wrote:
If you really need security of some form at the physical database
level then don't screw around with convoluted hacks. Encrypt the
critical data in the database and be done with it.
If the hacker gets root access so they can read
the raw database files, they most likely
you might want to also check your architecture flags for your compiler.
i ran into this problem on a mac when I was compiling php and by default it
tries to make a 32 bit and 64 bit binary, but pg was compiled as 64 bit only.
I found that the php compile did not fail, but i was "missing" some f
On Thu, May 20, 2010 at 3:36 PM, Tom Lane wrote:
> Matt Bartolome writes:
> > Setting the breakpoint (b exit) got me a little farther...
>
> > DEBUG: invoking IpcMemoryCreate(size=32595968)
> > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10
> > Detaching after fork from child
Matt Bartolome writes:
> Setting the breakpoint (b exit) got me a little farther...
> DEBUG: invoking IpcMemoryCreate(size=32595968)
> DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10
> Detaching after fork from child process 19066.
> Detaching after fork from child process 19067
Alvaro Herrera writes:
> Excerpts from Justin Pasher's message of jue may 20 16:10:53 -0400 2010:
>> Whenever I clear out the stats for all of the databases, the file
>> shrinks down to <1MB. However, it only takes about a day for it to get
>> back up to ~18MB and then the stats collector proces
On Thu, May 20, 2010 at 2:44 PM, Tom Lane wrote:
> Matt Bartolome writes:
> > gdb output...
>
> > DEBUG: -
> > DEBUG: invoking IpcMemoryCreate(size=32595968)
> > DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10
> > Detaching after fork fr
Matt Bartolome writes:
> gdb output...
> DEBUG: -
> DEBUG: invoking IpcMemoryCreate(size=32595968)
> DEBUG: max_safe_fds = 980, usable_fds = 1000, already_open = 10
> Detaching after fork from child process 18310.
> Detaching after fork from child proces
Excerpts from Justin Pasher's message of jue may 20 16:10:53 -0400 2010:
> Whenever I clear out the stats for all of the databases, the file
> shrinks down to <1MB. However, it only takes about a day for it to get
> back up to ~18MB and then the stats collector process start the heavy
> disk wr
Hi Tom,
On Thu, May 20, 2010 at 11:33 AM, Tom Lane wrote:
> Matt Bartolome writes:
> > I'm attempting to start postgres on a standby machine from a backup. Both
> > the primary and standby are running postgres 8.4, fedora 12.
>
> 8.4.what exactly?
>
I'm running 8.4.2 on the primary and 8.4.4 o
On Thu, May 20, 2010 at 3:00 PM, Tom Lane wrote:
> Vick Khera writes:
>> On Thu, May 20, 2010 at 4:21 PM, Joshua D. Drake
>> wrote:
>>> I wonder if the oom killer is acting up.
>
>> that'd be my guess. postfix *never* dies. something external is
>> killing your processes.
>
> Either that or h
Vick Khera writes:
> On Thu, May 20, 2010 at 4:21 PM, Joshua D. Drake
> wrote:
>> I wonder if the oom killer is acting up.
> that'd be my guess. postfix *never* dies. something external is
> killing your processes.
Either that or his hardware is failing, eg RAM dropping critical bits in
the
That may in fact be the cause. I ran, free -lm -s 0.5, to watch my memory
use and saw the output below. My processes didn't die this time when it hit
zero bytes free, but it only lasted for 1 second. Some process must be
occasionally using very excessive memory, and every once in a while, I get
On Thu, May 20, 2010 at 4:21 PM, Joshua D. Drake wrote:
> I wonder if the oom killer is acting up.
>
that'd be my guess. postfix *never* dies. something external is
killing your processes.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
/var/log/messages doesn't really show anything (see below). Just my
repeated manual restarts because of the daemon crashing. Yes, all three
crash each time, I can't figure out why rsyslog and postfix die because of a
database issue. I'm not familiar with the oom killer. I'll google around.
Do y
On Thu, 2010-05-20 at 15:10 -0500, Spencer Anderson wrote:
> I have a Ruby on Rails web site that is running on a CentOS 5 server
> using Apache 2 with Passenger and PostgreSQL 8.4. Over the past two
> weeks I am seeing my PostgreSQL daemon, postfix, and rsyslog daemons
> all die at the same time,
I have a Ruby on Rails web site that is running on a CentOS 5 server using
Apache 2 with Passenger and PostgreSQL 8.4. Over the past two weeks I am
seeing my PostgreSQL daemon, postfix, and rsyslog daemons all die at the
same time, this happens at least 5 times per day at random times. Apache
how
- Original Message -
From: Justin Pasher
Date: Fri, 23 Apr 2010 17:46:16 -0500
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Alvaro Herrera
CC: pgsql-general@postgresql.org
- Original Message -
From: Alvaro Herrera
Date: Fri, 23 Apr 2010 18:28:03 -0
On Thu, May 20, 2010 at 7:49 AM, Hernan Danielan
wrote:
> The server and the client are running in the same machine.That is why a
> network connection problem is almost imposible. I do not know if i am doing
> something wrong, my code is in my fist message. It is a extrange thing
> because with fi
Matt Bartolome writes:
> I'm attempting to start postgres on a standby machine from a backup. Both
> the primary and standby are running postgres 8.4, fedora 12.
8.4.what exactly?
> DEBUG: invoking IpcMemoryCreate(size=32595968)
> DEBUG: max_safe_fds = 984, usable_fds = 1000, already_open = 6
Yan Cheng CHEOK wrote:
Hello all,
I am programming in Windows environment. Previously, we are using MBCs
(http://msdn.microsoft.com/en-us/library/5z097dxa%28VS.71%29.aspx), in order to
support language other than English.
The following function still can be used, as long as we are setting the
Hi,
I'm attempting to start postgres on a standby machine from a backup. Both
the primary and standby are running postgres 8.4, fedora 12.
The backup on the primary is done nightly using the following commands:
# psql -d operations -U postgres -c "SELECT
pg_start_backup('/data/postgres')";
# tar
Giancarlo Boaron wrote:
> Hi all.
>
> Recently, I wrote an email about the problem I was having with some Postgres
> functions that when those functions were called, I received the following
> error: "Call to undefined function ".
>
> After some answers, I decided to rebuild a brand new linux v
On Thu, 2010-05-20 at 09:21 -0700, Giancarlo Boaron wrote:
> Hi Jim.
>
> I think it depends on each server configuration but I checked in my server
> and I don't have the 'pgsql.so' and 'psql.ini' files and neither the 'www'
> directory.
>
> My Apache version is 2.2.15 and my root directory is
Excerpts from Richard Walker's message of jue may 20 02:19:17 -0400 2010:
> (a) (ii) It seems a breach is possible via the xmin values.
> In that case, what about doing updates inside a transaction
> that does a trivial update of all rows, e.g.:
>begin transaction;
>update mytable ; --
Hi Jim.
I think it depends on each server configuration but I checked in my server and
I don't have the 'pgsql.so' and 'psql.ini' files and neither the 'www'
directory.
My Apache version is 2.2.15 and my root directory is /usr/local/apache2/htdocs.
Thank you.
--- Em qui, 20/5/10, Jim Lucas
Yes. Phpinfo() tells me it's ok:
pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.4.4
Multibyte character support disabled
SSL support enabled
Active Persistent Links 0
Active Links 0
Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_pe
On Thu, May 20, 2010 at 11:16 AM, Teddy Limousin wrote:
> thanks tom, aparently your rigth in the sql dump file there are some
> set search_path changes
> I tried the set search_path command and use the same query that generate
> the error and it works on my pgadmin editor.
>
> My question is how
Hello,
I have a problem with a SRF. In the first call, another external
function is called. This function returns some allocated memory, and
allocate/free more memory during its execution (I think there's no
memory leaks in it...). Before calling the function, I change to a
memory context appropia
thanks tom, aparently your rigth in the sql dump file there are some
set search_path changes
I tried the set search_path command and use the same query that generate
the error and it works on my pgadmin editor.
My question is how can I set the search_path for all users or all conections
so my app
Sorry I miss read the question.
It does seem that php is not picking up the pg module and cannot find
the functions.
I assume Postgresql is in fact installed at /usr/local/pgsql. If you
run phpinfo(); can you see that PG is installed?
On 20/05/2010 10:46, Giancarlo Boaron wrote:
**
I make
I make the function call in a php file. I'm not using stored procedures.
If I create an empty php file and put only some of these functions, Apache
reports de 'call to undefined function XXX'.
--- Em qui, 20/5/10, Fernando escreveu:
De: Fernando
Assunto: Re: [GENERAL] [PHP] Some undefine
Are you calling store procedures that return cursors? I had this
problem with cursors because the transaction gets committed and the
cursor closed after they return. Mind you I had the problem on .NET
using npgsql, so I might be way off.
Cheers
On 20/05/2010 10:05, Giancarlo Boaron wrote:
On Thu, May 20, 2010 at 1:19 AM, Richard Walker wrote:
>
> I have an application in which I want it
> _not_ to be possible to work out which
> rows of a table are being/have been updated.
>
Why?
If you really need security of some form at the physical database
level then don't screw around with
Teddy Limousin writes:
> I guess this is because when executing the sql command to install lo, it
> makes it visible from the public schema only
> not from the schema I`m using. So my question is how can I make lo type to
> be visible from all schemas
> by visible I mean accesible: not need to us
On Thu, May 20, 2010 at 8:11 AM, Igor Neyman wrote:
>
>
>> -Original Message-
>> From: Scott Marlowe [mailto:scott.marl...@gmail.com]
>> Sent: Wednesday, May 19, 2010 4:15 AM
>> To: A. Kretschmer
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: default ordering of query result - are the
> -Original Message-
> From: Scott Marlowe [mailto:scott.marl...@gmail.com]
> Sent: Wednesday, May 19, 2010 4:15 AM
> To: A. Kretschmer
> Cc: pgsql-general@postgresql.org
> Subject: Re: default ordering of query result - are they
> always guarantee
>
>
Hi all.
Recently, I wrote an email about the problem I was having with some Postgres
functions that when those functions were called, I received the following
error: "Call to undefined function ".
After some answers, I decided to rebuild a brand new linux virtual machine with
Apache + PHP + Po
hello I`m trying to restore a database that uses contrib type lo. The
database uses one schema where the relations are created
before restoring the schema I execute the command
psql -d dbname -f path-to-contrib/lo.sql
after this I restore the schema and then the data of the database
the problems
Joshua Tolley writes:
> On Wed, May 19, 2010 at 1:46 PM, Hernan Danielan
> wrote:
>> Yes, the most interesting thing is that the log says
>> unexpected EOF on client connection or could not send data to client:
>> Broken pipe
> That log mostly just says something disconnected uncleanly, but
> d
Yan Cheng CHEOK writes:
> May I know, how I can store wchar_t * typed string into PostgreSQl, using C
> library?
You can't; you have to convert to whatever the client_encoding is.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
The server and the client are running in the same machine.That is why a
network connection problem is almost imposible. I do not know if i am doing
something wrong, my code is in my fist message. It is a extrange thing
because with files less than 500KB works great. However with a file of 1.4MB
it
Thanks Steve, that works nicely in the testing I've done so far.
I'll keep in mind about the pgfoundry project. I don't see this growing
overly large, but you never know. I didn't realize the CIDR type
couldn't be indexed.
Scot Kreienkamp
skre...@la-z-boy.com
-Original Message-
Fr
50 matches
Mail list logo
