Hello
last december I've delvoped a few PL/pgSQL functions to log
all changes in my database and recreate former database states.
I used row_to_json to log and json_populate_recordset to reproduce
my tables. I think it's cool feature and I like to share and discuss it
with you. I would be v
Can anyone describe how Postgres generates session identifiers and how
Postgres uses a session identifier for community action protection?
More specifically, will Postgres allow a session identifier to be
non-system generated? How does Postgres respond when presented with a
non-system generated s
Hi list,
I am able to successfully authenticate a Windows server AD user with
PostgreSQL 9.2.3 version from linux clients but It doesn't work with
Windows client.
First I logon windows 7, using a Active Directory's user, then I tried
to login to postgresql 9.2.3 server with psql:
psql -h hostname
Hi,
Does anyone know whether this link has an open bug? Maybe a fix?
http://www.postgresql.org/message-id/5046caeb.4010...@grammatech.com
Thanks
Danny
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
Adrian,
Thanks for confirming my observations.
My hope was that I would be able to create one archive file with pg_dump -Fc,
which at a future time could be used to do either a total restoration
or partial restorations via options of pg_restore; ie. Not to have create
addeded specialized pg_dump
On Tue, Jan 14, 2014 at 2:36 PM, Keith Minsel wrote:
> Can anyone describe how Postgres generates session identifiers and how
> Postgres uses a session identifier for community action protection?
PostgreSQL is a database system, it does not "generate session identifiers".
You probably have an ap
On 01/14/2014 04:54 AM, Abraham, Danny wrote:
Hi,
Does anyone know whether this link has an open bug? Maybe a fix?
http://www.postgresql.org/message-id/5046caeb.4010...@grammatech.com
If it where me I would file a bug report here;
http://www.postgresql.org/support/submitbug/
In the report
On 01/14/2014 06:06 AM, Day, David wrote:
Adrian,
Thanks for confirming my observations.
My hope was that I would be able to create one archive file with pg_dump -Fc,
which at a future time could be used to do either a total restoration
or partial restorations via options of pg_restore; ie. Not
On 01/14/2014 04:54 AM, Abraham, Danny wrote:
Hi,
Does anyone know whether this link has an open bug? Maybe a fix?
http://www.postgresql.org/message-id/5046caeb.4010...@grammatech.com
In addition to my suggestion to file a bug report, I came with another idea.
In a previous post you said:
Thanks for the responses, that clarifies the checksum feature for me.
FWIW, my pgbench tests between a 9.2 server and a 9.3 server with checksum
showed very similar performance characteristics and system resource
utilization. Im going to set up another load test with our actual
application to see
On 13/01/14 17:50, Mike Broers wrote:
> Is there a built-in method of scanning the server to check for
> corruption or will I have to wait for a corrupt object to be accessed to
> see the log entry?
This presentation:
http://www.youtube.com/watch?v=TovZ0lb16-Q
suggests pg_filedump.
Torsten
Hello All,
Can anyone please tell me which of the following is the correct replication
lag query to find streaming replication lag in seconds?
1. SELECT extract(seconds from (now() - pg_last_xact_replay_timestamp()))
AS time_lag;
2. SELECT CASE WHEN pg_last_xlog_receive_location() =
pg_last_xlog
I'm a little bit confused by the meaning of xmax.
The documentation at
http://www.postgresql.org/docs/current/static/ddl-system-columns.html
says
"xmax
The identity (transaction ID) of the deleting transaction, or zero for
an undeleted row version. It is possible for this column to be nonzero
in
Hi,
Could anyone explain the meaning of the bit fields in struct
HeadlineWordEntry? Specifically, I'm not completely sure about
selected, in, replace, repeated, and skip.
Thanks,
Zev
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Hi there
Having spent about 2 hours trying to solve a simple problem, I think it might
be worthwhile to record my efforts. Perhaps someone can point out how
extremely silly I have been… or is the documentation lacking?
My original question was: where is the system-wide psqlrc file located?
So
John Sutton escribió:
> As a last resort (which surely shouldn’t be necessary) on the Ubuntu system I
> did:
>
> strings /usr/bin/psql | grep -i sysconf
>
> $ENV{'PGSYSCONFDIR'} = '/etc/postgresql-common' if !$ENV{'PGSYSCONFDIR’};
>
> So that’s where it needs to be: /etc/postgresql-common/psql
John Sutton writes:
> Hi there
> Having spent about 2 hours trying to solve a simple problem, I think it might
> be worthwhile to record my efforts. Perhaps someone can point out how
> extremely silly I have been
or is the documentation lacking?
> My original question was: where is the system
On Jan 14, 2014, at 10:58 AM, John Sutton wrote:
> Hi there
>
> Having spent about 2 hours trying to solve a simple problem, I think it might
> be worthwhile to record my efforts. Perhaps someone can point out how
> extremely silly I have been… or is the documentation lacking?
>
> My origin
Could someone give me some insight to the following error message:
[mqsql06:/Volumes/SQL_Set] _postgres% pg_basebackup --user=replicate
--host=mqsql03 -xP -Fp --pgdata=pgsql
19439890/65873894 kB (29%), 1/1 tablespace
pg_basebackup: could not get transaction log end position from server: ERROR:
I note for the observed failure of pg_restore -c -a -t,
I have worked around this by performing a
Truncate operation on the tables prior to invoking
pg_restore with a simpler -a -t option combination.
If this matter needs to be reposted as bug or needs
further action/information from me, please a
On 01/14/2014 02:29 PM, Day, David wrote:
I note for the observed failure of pg_restore -c -a -t,
I have worked around this by performing a
Truncate operation on the tables prior to invoking
pg_restore with a simpler -a -t option combination.
If this matter needs to be reposted as bug or needs
f
On Wed, Jan 15, 2014 at 1:26 AM, Ming Li wrote:
> I'm a little bit confused by the meaning of xmax.
>
> The documentation at
> http://www.postgresql.org/docs/current/static/ddl-system-columns.html
> says
> "xmax
>
> The identity (transaction ID) of the deleting transaction, or zero for
> an undele
On Wed, Jan 15, 2014 at 6:53 AM, Alan Nilsson wrote:
> Could someone give me some insight to the following error message:
>
> [mqsql06:/Volumes/SQL_Set] _postgres% pg_basebackup --user=replicate
> --host=mqsql03 -xP -Fp --pgdata=pgsql
> 19439890/65873894 kB (29%), 1/1 tablespace
> pg_basebackup: c
23 matches
Mail list logo
