Thank you so much all of you.
Table audittraillogentry have PRIMARY KEY and FOREIGN KEY defined, below is the
detail of existing table audittraillogentry.
As you can see ., it is referenced by 2 tables , "cdrdetails" and "cdrlogentry"
. "cdrdetails" table do not have the index whereas "cdrlogen
Hello, recently one of my tables needed a vacuum (to prevent wraparound)
and of course it happened at a really bad time, so since then I've been
learning about how Transaction ID Wraparound works and its associated
parameters.
I'm trying this query to see how close my tables are to hitting the
vac
On Tue, May 5, 2015 at 7:57 AM, Edson F. Lidorio
wrote:
>
>
> On 04-05-2015 00:46, Venkata Balaji N wrote:
>
>> You do not see the above WAL file in the archive directory ?
>> "/mnt/server/archivedir" is shared between master and slave databases ? The
>> file may have been removed from the archiv
On 05/05/2015 11:21 AM, Melvin Davidson wrote:
Have you allowed access to user "replication" in the master pg_hba.conf
and done a
SELECT pg_reload_conf()?
Can you ping the master from the standby?
Did you RTFM?
http://www.postgresql.org/docs/9.2/interactive/warm-standby.html
25.2.3 Preparing t
Try this query and see if it fulfills your needs. Adjust the WHERE clause
as needed.
SELECT
table_catalog as database,
table_schema as schema,
table_name as table,
column_name as column,
ordinal_position as position,
column_default as default,
is_nu
On 05/05/2015 01:13 PM, Suresh Raja wrote:
Hi All:
I have tables with different versions in the same schema. Like
T1a, T1b, T1c
T2a, T2b, T2c, T2d
...
etc.
I'm interested in documenting various version of tables, may be in excel
sheet or may be in another schema in the database. I
On Tue, 5 May 2015 15:13:42 -0500
Suresh Raja wrote:
>
>
> I have tables with different versions in the same schema. Like
> T1a, T1b, T1c
> T2a, T2b, T2c, T2d
>
> ...
> etc.
>
>
> I'm interested in documenting various version of tables, may be in excel
> sheet or may be in another schema
System catalogs should help, unless I misunderstand your question:
http://www.postgresql.org/docs/9.4/static/catalogs.html
http://www.postgresql.org/docs/9.4/static/view-pg-tables.html
http://stackoverflow.com/questions/20698169/how-to-use-postgres-pg-tables-to-compare-contraints
On Tue, May 5
>
> Hi All:
I have tables with different versions in the same schema. Like
T1a, T1b, T1c
T2a, T2b, T2c, T2d
...
etc.
I'm interested in documenting various version of tables, may be in excel
sheet or may be in another schema in the database. I would like to store
information on table name
Hi,
On Mon, 2015-05-04 at 23:05 -0700, Guyren Howe wrote:
> PGFoundry's own link to their Sample databases gives me a 404 error.
>
> http://pgfoundry.org/projects/dbsamples/
>
> Does anyone know of an alternative source for the sample databases?
> And what is going on at pgfoundry?
FWIW, if yo
Fixed .. .let me know if there are any other issues …
> On May 5, 2015, at 09:55, William Dunn wrote:
>
> PgFoundry.org went down some months ago, I contacted webmaster Marc Fournier
> and he was able to get it back up but a lot of it no longer works and I don't
> think he responded to my fol
Wow. I love this community. Thanks a bunch.
> On May 5, 2015, at 10:41 , Marc Fournier wrote:
>
>
> Fixed .. .let me know if there are any other issues …
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
Have you allowed access to user "replication" in the master pg_hba.conf and
done a
SELECT pg_reload_conf()?
Can you ping the master from the standby?
Did you RTFM?
http://www.postgresql.org/docs/9.2/interactive/warm-standby.html
25.2.3 Preparing the Master for Standby Servers
25.2.4 Setting Up a
Em 2015-05-05 14:31, Adrian Klaver escreveu:
> On 05/05/2015 08:35 AM, Edson F. Lidorio wrote:
> On 05-05-2015 11:22, Melvin Davidson wrote: It's possible you have
> wal_keep_segments set too low. What happens is that the master will keep the
> wals ( in your case 20) after processing them,
On 05/05/2015 08:35 AM, Edson F. Lidorio wrote:
On 05-05-2015 11:22, Melvin Davidson wrote:
It's possible you have wal_keep_segments set too low. What happens is
that the master will keep the wals ( in your case 20) after processing
them, before sending them off to the great black hole in the ne
Ya, I’m looking into the problem with the Summary pages right now, actually …
there are no errors in the logs, and it seems mto only affect that one page …
> On May 5, 2015, at 09:55, William Dunn wrote:
>
> PgFoundry.org went down some months ago, I contacted webmaster Marc Fournier
> and h
Em 2015-05-05 13:05, Melvin Davidson escreveu:
> Did you change the setting on the master? Did you remember to reload the
> config on the master after changing?
> Did you rebuild the Standby server after making the change and reloading? IE:
> psql -U postgres SELECT pg_reload_conf();
>
> Y
PgFoundry.org went down some months ago, I contacted webmaster Marc
Fournier and he was able to get it back up but a lot of it no longer works
and I don't think he responded to my follow-up. For the most part top pages
are broken but sub-pages are still there (just very hard to navigate to and
find
Did you change the setting on the master?
Did you remember to reload the config on the master after changing?
Did you rebuild the Standby server after making the change and reloading?
IE:
psql -U postgres
SELECT pg_reload_conf();
You must do ALL of the above to have any chance of making things wo
On 05-05-2015 11:22, Melvin Davidson wrote:
It's possible you have wal_keep_segments set too low. What happens is
that the master will keep the wals ( in your case 20) after processing
them, before sending them off to the great black hole in the network
(deleting) and making them unavailable to
Hi All;
2 questions about UDR:
1) is there documentation showing how to get a one way node (UDR) up and
running?
2) Is it possible to push to a node one way (via UDR) from a BDR node
(i.e. a set of BDR nodes for H/A and a single UDR node to serve up
replication one way as the source for a DSS/Re
sanjeetkamble wrote:
> Please explain in details im not able to understand.
https://wiki.postgresql.org/wiki/Number_Of_Database_Connections
http://stackoverflow.com/questions/10419665/how-does-pgbouncer-help-to-speed-up-django/10420469#10420469
https://wiki.postgresql.org/wiki/PgBouncer
--
Ke
On 05/05/2015 07:23 AM, Edson F. Lidorio wrote:
Please keep this on the list, for two reasons:
1) More eyes looking is better.
2) I will be off line shortly.
Em 2015-05-05 11:09, Adrian Klaver escreveu:
On 05/05/2015 07:05 AM, Edson F. Lidorio wrote:
CCing list.
Em 2015-05-05 10:45, Adria
On 05/04/2015 11:11 PM, sanjeetkamble wrote:
Hello,
Please explain in details im not able to understand.
You are going to have to be more specific.
Do you want to know why setting max_connections=1 will not work?
Do you want to know about connection pooling?
Or do you want to know how t
Can someone point me to a survey on the t-search functionality? I’ve read the
documentation but it doesn’t give much of a big picture view. I’d also be
interested in seeing a current comparison of tsearch to other search
technologies like Solr, if anyone knows of such a thing.
Thanks!
b
--
Hello,
Please explain in details im not able to understand.
--
View this message in context:
http://postgresql.nabble.com/Setting-up-a-database-for-1-concurrent-users-tp1848801p5848004.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general
It's possible you have wal_keep_segments set too low. What happens is that
the master will keep the wals ( in your case 20) after processing them,
before sending them off to the great black hole in the network (deleting)
and making them unavailable to the standby. Try increasing
wal_keep_segments =
On 05/05/2015 07:05 AM, Edson F. Lidorio wrote:
CCing list.
Em 2015-05-05 10:45, Adrian Klaver escreveu:
On 05/03/2015 05:57 PM, Edson F. Lidorio wrote:
Hello, I'm having trouble on Standby after the implementation of the
restore_command. I performed all the settings and it worked normally
a
On 05/03/2015 05:57 PM, Edson F. Lidorio wrote:
Hello,
I'm having trouble on Standby after the implementation of the
restore_command.
I performed all the settings and it worked normally and after restart
the slave server, started to generate errors in the log of the slave:
So is that implying
So we can consider this matter closed ? CallableStatements are necessary
because postgres has to use select to call a function.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 18:06, Nanker Phelge wrote:
> The database function does not use out parameters or
On Mon, 4 May 2015 23:05:11 -0700
Guyren Howe wrote:
> And what is going on at pgfoundry?
>
I don't follow them personally, but I saw this recent thread, which does not
bode well :
http://www.postgresql.org/message-id/20150409153813.ga7...@gmail.com
--
31 matches
Mail list logo
