maybe a routine question here ... i hope i can understand the
answer.
[EMAIL PROTECTED] ~]$ pg_ctl --version
pg_ctl (PostgreSQL) 8.0.0beta3
[EMAIL PROTECTED] ~]$
i have a problem matching a utf8 string with a field in a database
encoded in utf8.
i read the documentation, checked the followi
problem is that my string -- which is in utf-8 -- because
all input is converted first in php with
$str_out = mb_convert_encoding($str_in, "UTF-8");
and the query, which
is like
"select wordid from korean_english where word='utf8string'";
and it is returning wordids for words which are no
2006-04-01 (토), 21:19 -0500, Robert Treat 쓰시길:
> On Friday 31 March 2006 18:51, chris smith wrote:
> > On 4/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > I'm hoping someone can tell me how to go about this, or if a solution is
> > > even possible with my current set up.
2006-04-01 (토), 19:26 -0700, Brendan Duddridge 쓰시길:
> Excellent. I've just downloaded citext and I'll try it out. Are there
> any problems with it?
> It seems like this should just be added as a default data type to
> PostgreSQL.
>
> Thanks,
>
> ___
2006-04-01 (토), 21:15 -0500, Robert Treat 쓰시길:
> On Saturday 01 April 2006 17:26, Brendan Duddridge wrote:
> > We used to use FrontBase for our databases, but we have since
> > switched to PostgreSQL for
> > performance reasons. However, FrontBase did have very nice collation
> > support.
> >
> > T
n1' not found
'.
How can I repair this?
Postgres 7.1.2
RH 6.2
respectfully,
Joseph
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
How can I tell Windows to close an ODBC connection?
It seems like the 'idle' connections live forever and i have to manually
kill the sessions.
I am using NT/Foxpro with ODBC 6.5 for client and Linux with PostgreSQL 7.02
for server.
Joseph
Help me for "DBI->connect failed: Sorry, too
many clients already."my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-typ
my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-type: text/html\n\n";print
<<"TAG"; The count is
$count. TAGexit
0;#
! And am
looking forward to the 7.x series :-)
Joseph Showalter
If I set MAX_CONNECTIONS over 32 on 7.1beta3-2 the postmaster refuses to
start?
Joseph
Never mind this one, I guess you MUST also set the buffer value up if you
want to increase the connections setting. Seems like it did not used to be
that way.
I turned on logging and was able to see the problem.
- Original Message -
From: "Joseph" <[EMAIL PROTECTED]&g
Try pgsendmail.
ftp://ftp.trurl.anything3d.com/pub/Linux/our/pgsendmail-1.1.tar.gz
or
http://ftp.trurl.anything3d.com/Linux/our/pgsendmail-1.1.tar.gz
Joseph Showalter
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Tulio Oliveira
>
I would like to log cisco pix entries and then use that to report on
intrusion activities and monitor traffic patterns.
respectfully,
Joseph
-Original Message-
From: Ben [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 11:22 AM
To: Joseph
Cc: [EMAIL PROTECTED]
Subject: Re
Thanks for the great anwsers.
I recieved good answers.
I had not even started thinking about the normalization part of it yet.
I am not sure I understand the implications of the piping it to the insert
routine.
That sure would sound like a simple effective method.
respectfully,
Joseph
?
respectfully,
Joseph
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
help.
I am a newbie with Unix or Linux but am very at home in the win32 world.
Joseph
> Log in as "postgres" (empty password) and create some users.
Do I need to do this at the bash prompt somehow? I don't know how.
Or do I log into my nt workstation and change users with the user manager?
I guess I am confused how postgress works with users.
Joseph
---
AL 1: SetPgUserName: no entry in host passwd file
>
> The admin.pdf doesn't seem to give much help.
>
> I am a newbie with Unix or Linux but am very at home in the win32 world.
>
> Joseph
>Log in as "postgres" (empty password) and create some users.
Joseph
I get the following error running postgress 6.5.3 on win32.
What might I be doing wrong?
It runs and works but it says the following many times.
Error semaphore semaphore not equal 0
Joseph
How do you solve this error message?
Connection to database 'template1' failed.
Sorry, too many clients already
Joseph
Are the 7.0 RPMs out yet for Redhat 6.2?
I am using the 7.0RC5.
Just wondered.
Joseph
On Wed, Mar 11, 2015 at 9:55 AM, Andrew Sullivan
wrote:
> On Wed, Mar 11, 2015 at 09:40:09AM -0400, Joseph Kregloh wrote:
> > Have you looked into Barman? http://www.pgbarman.org/ It does what you
> > want. You can take a full daily backup and it keeps track of the WAL
> file
backup of one day.
Thanks,
-Joseph Kregloh
On Wed, Mar 11, 2015 at 9:26 AM, Stéphane Schildknecht <
stephane.schildkne...@postgres.fr> wrote:
> Hello,
>
> On 11/03/2015 11:54, Robert Inder wrote:
> > We are developing a new software system which is now used by a number
>
the query,
everything else I can hardcode into the search filter.
Would an ldapurl be better here? But again how will I pass the uid to the
ldapurl?
Thanks,
-Joseph Kregloh
On Wed, Apr 22, 2015 at 5:30 PM, John R Pierce wrote:
> On 4/22/2015 11:37 AM, Joseph Kregloh wrote:
>
>> I have successfully setup LDAP and setup simple authentication using
>> simple bind. This was my test case. Now I need to move to the next lever
>> which would be se
You will want to setup your replication user to connect to PostgreSQL
directly. Going through pgBouncer is asking for trouble.
-Joseph Kregloh
with
it enabled and disabled.
I've included a copy of one of the tests done.
Thanks,
-Joseph Kregloh
On Thu, Jul 2, 2015 at 9:35 AM, Vick Khera wrote:
>
> On Wed, Jul 1, 2015 at 5:07 PM, Joseph Kregloh
> wrote:
>
>> We recently built a new server for our Production database. The machine
>> is top of the line with 128GB of RAM, dual E5-2650. We also included NVME
>
On Thu, Jul 2, 2015 at 11:50 AM, Vick Khera wrote:
>
> On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh
> wrote:
>
>> With my dataset I have been able to take advantage of the L2ARC.
>> Currently using about 80GB on ARC and 260GB on L2ARC. With the ARC
>> currentl
ed to start replicating to the other slave the moment I trigger it's
promotion?
Thanks,
-Joseph Kregloh
>
>
Jails work, but in this case it would be more trouble. If you had it in a
jail already then that would be different story.
> c) Somehow modify the ports options so each versions binary is installed
> separately. I have no idea how to do it, maybe need to ask this on the
> FreeBSD mailing list.
>
This I explained above.
-Joseph Kregloh
and set
recovery_target_timeline to latest
5. Start slave B, then start slave A now master.
So far everything seems to work.
-Joseph Kregloh
On Tue, Jul 21, 2015 at 2:37 PM, William Dunn wrote:
> As I am aware, you would have two options depending on your configuration:
>
>1. C
built the same and not every PostgreSQL server is used the same, to tune
according to the machine and the usage of the server.
Thanks,
-Joseph Kregloh
On Tue, Aug 18, 2015 at 5:52 AM, Sachin Srivastava
wrote:
> Hi,
>
> If my system RAM is 50 GB then how can I tune my database server withou
On Thu, Aug 20, 2015 at 9:50 AM, Laurent Laborde
wrote:
> Friendly greetings !
>
> I'm wondering if anyone tried the following hot backup process, and if it
> works :
> pg_start_backup()
> zfs snapshop
> pg_stop_backup()
>
> copy the snapshot to the backup server.
>
That is how I currently handl
than a
> factor of 5 (from memory) in terms of throughput.
>
> Considering the time to move heads between tracks and rotational latency
> (caused by not reading sequential blocks on the same track). There are
> other complications, which I have glossed over!
>
>
It can go even
to continue using the start_backup , rsync and
> stop_backup. ;(
>
>
You can always move the folder out of there. Depending on the version of
PostgreSQL different steps need to be take. If I remember correctly for
version 9.3 you can move the symlink to point to the new directory. Pre 9.3
you need to move the symlink and the pointer inside the pg tables.
-Joseph Kregloh
> Thanks!
>
stalled on the machine? How did you set up PG? (PG
> defaults are historically horrible for higher-RAM machines)
>
>
In my testing with pgbench I actually saw a decrease in performance with a
ZIL enabled. I ended up just keeping the L2ARC and dropping the. ZIL will
not provide you wit
On Thu, Oct 1, 2015 at 5:51 PM, Jim Nasby wrote:
> On 10/1/15 8:50 AM, Joseph Kregloh wrote:
>
>> In my testing with pgbench I actually saw a decrease in performance with
>> a ZIL enabled. I ended up just keeping the L2ARC and dropping the. ZIL
>> will not provide you w
ain in sync when one is restarted I would need
to modify my script to return an error or false to PostgreSQL, this way it
will hold the WAL files until both Slaves are online. Correct?
Thanks,
-Joseph
On Tue, May 31, 2016 at 4:12 PM, Alvaro Herrera
wrote:
> Joseph Kregloh wrote:
> > It is my understanding that if PostgeSQL has log shipping enabled, if for
> > whatever reason it cannot ship the file the master server will hold it.
> But
> > for how long?
>
>
oating the question
anyways in hope of suggestions.
-Joseph
On Mon, Aug 1, 2016 at 5:21 PM, Jeff Janes wrote:
> On Mon, Aug 1, 2016 at 1:32 PM, John McKown
> wrote:
> > On Mon, Aug 1, 2016 at 2:49 PM, Jeff Janes wrote:
> >>
> >> On Mon, Aug 1, 2016 at 11:40 AM, Joseph Kregloh <
> jkreg...@sproutloud.com>
> >
I'm trying to get a new build of 9.6.1 working on a machine
running Debian stable (jessie) and I'm seeing some odd
behavior where things work correctly if I run psql when
logged in as postgres, but if I run it as user 'doom' (my
usual login), I don't seem to have any select privileges.
Even this fa
I'm trying to get a new build of 9.6.1 working on Debian
stable and I'm seeing some odd behavior where things work
correctly if I run psql when logged in as user 'postgres',
but if I'm logged-in as user 'doom' (my usual login), I don't
seem to have any select privileges. Even this fails
silently:
he same way as login 'doom' or login
'postgres':
/usr/local/pgsql/bin/psql --dbname=doom --username=doom
On Sat, Dec 3, 2016 at 7:10 AM, Adrian Klaver wrote:
> On 11/30/2016 08:48 PM, Joseph Brenner wrote:
>>
>> I'm trying to get a new build of 9.6.1 wo
-D /usr/local/pgsql/data >
/var/lib/postgresql-9.6.1/logfile 2>&1 &
On Sat, Dec 3, 2016 at 7:23 AM, rob stone wrote:
>
> On Wed, 2016-11-30 at 20:48 -0800, Joseph Brenner wrote:
>> I'm trying to get a new build of 9.6.1 working on a machine
>> running Debi
> Any unusual errors in the logs? Or maybe a "\o /somefile" in your
~doom/.psqlrc?
No, nothing much in the logs after "autovacuum launcher started", and
I don't have a .psqlrc file.
On Sat, Dec 3, 2016 at 6:56 AM, Julien Rouhaud
wrote:
> On Wed, Nov 30, 2016 at 0
Yes, and sorry about the re-post. I thought my original message was
hung-up in moderation, so I was doing an unsub/resub fandango to get
email addresses to match.
On Sat, Dec 3, 2016 at 12:13 PM, Adrian Klaver
wrote:
> On 12/03/2016 12:08 PM, Joseph Brenner wrote:
>>
>> I'm
ling is that can't be the
problem, but I'll probably look into some more (Tom Lane seems to feel
there might be an issue there).
On Sat, Dec 3, 2016 at 4:46 PM, Adrian Klaver wrote:
> On 12/03/2016 02:55 PM, Joseph Brenner wrote:
>>
>> The version in the Debian stable
d libpq?
ldd /usr/lib/postgresql/9.4/bin/psql | egrep libpq
libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x7fe9db2ea000)
ldd /usr/lib/postgresql/9.6/bin/psql | egrep libpq
libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x7fa7337ec000)
On Sat, Dec 3, 2016 at 4:51
;
yo
doom=# \! ls -lad p*
drwxr-xr-x 1 doom doom 12 Nov 16 12:29 perl5
On Sat, Dec 3, 2016 at 7:48 PM, David G. Johnston
wrote:
> On Saturday, December 3, 2016, Joseph Brenner wrote:
>>
>>
>> doom=# select 'hello' as world;
>> doom=#
>>
>> Noth
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5434"?
On Sat, Dec 3, 2016 at 9:11 PM, Adrian Klaver wrote:
> On 12/03/2016 07:38 PM, Joseph Brenner wrote:
>>
>> Our story thus far: I've now got three different pg in
4# (change requires restart)
/etc/postgresql/9.4/main/postgresql.conf
port = 5432# (change requires restart)
On Sun, Dec 4, 2016 at 7:06 AM, Adrian Klaver wrote:
> On 12/03/2016 09:38 PM, Joseph Brenner wrote:
>>>
>>> So is the 9.4 instance the pr
16:17:04 PST [18517-3] doom@doom LOG: statement: set
client_encoding to 'unicode'
Because I also had this line:
\encoding unicode
On Sun, Dec 4, 2016 at 9:51 AM, Tom Lane wrote:
> Joseph Brenner writes:
>>> So what happens when you specify the port in your psql conn
> So what does:
>
> env | grep PAGER
>
> show?
Nothing. I have no PAGER settting (I don't normally use one).
On Mon, Dec 5, 2016 at 5:33 PM, Adrian Klaver wrote:
> On 12/05/2016 05:13 PM, Joseph Brenner wrote:
>
>
>> I just went around temporarily undoing th
Wait, that's not quite right. The user 'postgres' has no PAGER envar,
but user 'doom' has an empty value:
PAGER=
On Mon, Dec 5, 2016 at 8:50 PM, Joseph Brenner wrote:
>> So what does:
>>
>> env | grep PAGER
>>
>> show?
>
>
And I guess I did that intentionally, my .bashrc has
# I use emacs shells, I got a "pager" already:
export PAGER=''
On Mon, Dec 5, 2016 at 8:52 PM, Joseph Brenner wrote:
> Wait, that's not quite right. The user 'postgres' has no PAGER envar,
> but
#x27;postgres' always worked.
On Mon, Dec 5, 2016 at 9:03 PM, David G. Johnston
wrote:
> On Mon, Dec 5, 2016 at 9:53 PM, Joseph Brenner wrote:
>>
>> And I guess I did that intentionally, my .bashrc has
>>
>> # I use emacs shells, I got a "pager"
tion, so I
didn't worry about it.
So yeah, some better messaging when PAGER is mangled wouldn't hurt, if
that's possible. Falling back to "pager off" would make sense to me.
On Mon, Dec 5, 2016 at 9:28 PM, Joseph Brenner wrote:
> Well yeah, trying to run a PAGER
;
sh: 1: nadatech: not found
So the empty PAGER value case is the only one that doesn't seem
covered already. (I'm talented about finding these things...)
On Tue, Dec 6, 2016 at 9:51 AM, Tom Lane wrote:
> Joseph Brenner writes:
>> Looking back on the order of events, I th
Well, my take would be that if you've taken the trouble to set an
empty string as the PAGER that means something, and it probably means
you don't want any pager to be used.
But then, I would say that.
On Tue, Dec 6, 2016 at 12:13 PM, Tom Lane wrote:
> Joseph Brenner writes:
>
But on the other hand, if you've got a blank PAGER envar and a "\pset
pager something", the pset should win (just as it does now).
On Tue, Dec 6, 2016 at 1:53 PM, Joseph Brenner wrote:
> Well, my take would be that if you've taken the trouble to set an
> empty stri
Yes, I have a tendency to use emacs sub-shells (and occasionally M-x
sql-postgres)--
I thought I'd reproduced the behavior in an xterm, but I was just
trying again and I don't see it. It does seem that the dumbness of my
dumb terminal is a factor.
If I understand the way this works, it could be
You can leave authentication to something else. For example authenticate
the users by having them connect to pgBouncer first.
-Joseph
On Fri, Dec 16, 2016 at 11:17 AM, Andomar wrote:
> We run a master server and a hot standby server. Reporting users login to
> the standby server to ru
I set the ulimit for data to 4194304k:
core file size (blocks, -c) 0
data seg size (kbytes, -d) 4194304
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimite
If you don't mind the downtime it would be simpler to upgrade to 8.2 and
then worry about Slony. If you do mind you can use slony to do the
upgrade which needs much less downtime as you switch servers.
Geoffrey wrote:
We plan to upgrade from our current 7.4.17 Postgresql to 8.2.? in the
near
I am planning on segmenting one of my large tables into many child
tables using "CREATE TABLE ... INHERITS (parent)", but I want all the
triggers on my parent table to also fire on UPDATE/INSERT/DELETE on my
child table. As far as I can tell, there is no way to do this with the
CREATE TABLE co
I've had trouble with NFS files on nfs filesystems disappearing for a
second and reappearing. I had to add a retry loop with a delay in my
code that does file reading. I wouldn't try running a production level
postgres over nfs.
---(end of broadcast)--
I just moved one of my desktops and my laptop from Fedora 6 to Unbuntu
7.04 because Fedora lacked hardware support that Unbuntu and my Fedora
machines had all sorts of problems like sound dropping out and machines
locking up. (Also the Fedora installers are terrible).
My small gripes about Ub
My pg_shdepend table has a size of 16,384, but
pg_shdepend_depender_index has a size of 19,169,280 and
pg_shdepend_reference_index has a size of 49,152. When I try to reindex
the table I get:
ERROR: shared table "pg_shdepend" can only be reindexed in stand-alone mode
So is there any way I c
David Fetter wrote:
== PostgreSQL Weekly News - July 29 2007 ==
- Arrange to put TOAST tables belonging to temporary tables into
special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn
Does this apply to indexes on temp tables as well? Or is this not even
an issue with indexes
Most of the time I just hit 'Reply' and since this list
doesn't set the Reply-to: the replies go to the OP as well.
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
My pg_shdepend table has a size of 16,384, but
pg_shdepend_depender_index has a size of 19,169,280 and
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
Me too. I don't change my db schema that much, but I experience bloat
in the pg_tables that I don't expect. For instance pg_opclass needs a
VACUUM FULL/REINDEX once a week or I notice the indexes are larger than
the tabl
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
... and when I notice that the tuplesperpage for the indexes is low (or
that the indexes are bigger then the tables themselves) I know it is
time for a VACUUM FULL and REINDEX on that table.
If you are taking the latter as a blind m
Keep an eye on pg_stat_activity and pg_locks to see if any lock
contention is going on.
mr19 wrote:
I have a process that updates ~ 1500 rows in a table once a second. Every 5
minutes (almost exactly) the update takes ~ 15 seconds (normally < 1). I
have run htop/top on the machine during thi
How many rows are in this table?
Sanjay wrote:
Hi All,
Say I have a simple table WEBSITE(website_id int4 PRIMARY KEY, name
VARCHAR(30)). While I try this:
EXPLAIN ANALYZE SELECT * FROM WEBSITE WHERE website_id = 1
the output is:
David Fetter wrote:
Tom Lane committed:
>
- Restrict pg_relation_size to relation owner, pg_database_size to DB
owner, and pg_tablespace_size to superusers. Perhaps we could
weaken the first case to just require SELECT privilege, but that
doesn't work for the other cases, so use owner
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
Tom Lane committed:
- Restrict pg_relation_size to relation owner, pg_database_size to DB
owner, and pg_tablespace_size to superusers. Perhaps we could
weaken the first case to just require SELECT privilege, but that
doesn't w
On one of my servers postgres thinks that we're back on standard time
already:
[local]:db=# select current_timestamp;
now
---
2007-10-29 15:06:10.049795-05
(1 row)
Time: 0.807 ms
[local]:db=# select version();
Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
On one of my servers postgres thinks that we're back on standard time
already:
What's its TimeZone setting?
On the server that is working:
=> show TimeZone;
TimeZone
US/Eastern
(1 row)
On the one tha
On 11/1/10 11:54 PM, Stefan Schwarzer wrote:
>> SELECT * FROM
>>crosstab(
>>'SELECT name, year_start, value FROM foo ORDER BY 1',
>>'SELECT DISTINCT year_start FROM foo'
>>)
>> AS ct(name varchar, y_2010 float8, y_2011 float8);
> Hi Joe. Thanks a lot for the suggestions. Tried it o
> -Original Message-
> From: Susan Cassidy [mailto:scass...@stbernard.com]
> Sent: Monday, December 13, 2010 2:06 PM
> To: ray; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] Defining a Connection String in Windows XP
>
> >Ray,
> >
> >Thank you for responding. OK, that was my first
> On Saturday, February 05, 2011 9:30:13 am ray wrote:
> > I have built a few databases with MS Access and I would like to learn
> > how to use pgsql. I have found some examples but they have been too
> > complex to follow or to abstract with no specific details.
> >
> > I would like to find a s
Notepad++, how do you launch the code?
I really appreciate your efforts.
ray
_
From: urlu...@gmail.com [mailto:urlu...@gmail.com] On Behalf Of Matt
Sent: Saturday, February 05, 2011 10:19 PM
To: ray joseph
Subject: Re: [GENERAL] Looking for Suggestion on Learning
I too
I appreciate all the information
Thank you,
ray
-Original Message-
From: Dimitri Fontaine [mailto:dimi...@2ndquadrant.fr]
Sent: Sunday, March 06, 2011 3:19 PM
To: ray
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to Create Table from CSV
ray writes:
> I would like to crea
I have set up a pg database server for my organization on a cloud server
using PG 8.2;
I am trying to provide connections to the db for some members using MS
Access. I developed a small MS Access application using Windows ODBC - it
works fine from my house.
I have this line in pg_hba.conf:
Ho
PM
To: pgsql-general@postgresql.org
Cc: Joseph Doench
Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue?
On Thursday, March 17, 2011 2:29:00 pm Joseph Doench wrote:
> I have set up a pg database server for my organization on a cloud server
> using PG 8.2;
>
> I am tryin
PM
To: pgsql-general@postgresql.org
Cc: Joseph Doench
Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue?
On Thursday, March 17, 2011 2:50:18 pm Joseph Doench wrote:
> My home ISP, our cloud server, and the office ISP are all separate
> entities.
>
> I infer that the pro
David,
Thank your for the your thoughts. I have psql installed and I am currently
trying to use pgADMIN III. I have used it to make and drop Databases and
tables. I have not yet successfully built a table from SQL. I have taken
one of my Excel tables and used it to build a CREATE table script.
> From: Andy Colson [mailto:a...@squeakycode.net]
> Sent: Sunday, March 20, 2011 9:01 AM
>
> On 03/19/2011 11:40 PM, ray wrote:
> > I am looking for some help in database design. I would like to design
> > a database to help design alternative designs of a basic electronic
> > circuit design.
> From: Andy Colson [mailto:a...@squeakycode.net]
> Sent: Sunday, March 20, 2011 8:48 PM
> Subject: Re: [GENERAL] Database Design for Components and Interconnections
>
> >>
> >> You may, or may not, want a top level table:
> >>
> >> create table chips
> >> (
> >>chipid serial,
> >>descr te
I need to generate a very large crosstab. about 50 rows x 50 columns -- for
a request for a recurring report.
Example: Column Headings = Job_IDand Row Headings = Employee_ID and
Values in the table = Hours_worked
Got the idea?
I've looked at :
http://www.postgresonline.com/journal/archi
Why don't you try using Barman? It allows you to take snapshots and do
PITR. Not to mention you can use it as it's intended purpose as a backup
engine.
-Joseph
On Thu, Aug 14, 2014 at 1:53 PM, Bill Mitchell wrote:
> We are running our own Postgres server on AWS as well (sin
up.
I apologize if this question has already been asked. I did some searching
beforehand.
Thanks,
-Joseph Kregloh
On Fri, Aug 22, 2014 at 2:21 PM, Jerry Sievers
wrote:
> Joseph Kregloh writes:
>
> > Hi,
> >
> > Currently I am doing asynchronous replication from master to
> > slave. Now if I restart the slave it will fall out of sync with the
> > master. Is there a correc
l be set to 'on' and left that way.
>
>
Yep, I run version 9.3 on all the environments.
>
> Joseph Kregloh writes:
>
> > On Fri, Aug 22, 2014 at 2:21 PM, Jerry Sievers
> wrote:
> >
> > Joseph Kregloh writes:
> >
> > >
ing SSDs for the ZIL and L2ARC. This
would allow for a pretty nice boost in speed.
-Joseph
On Wed, Nov 26, 2014 at 9:50 AM, Andy Colson wrote:
> On 11/26/2014 4:16 AM, Maila Fatticcioni wrote:
>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 11/25/2014
I use Zabbix a lot. There is very nice template for Postgres
http://pg-monz.github.io/pg_monz/index-en.html
On Sun, Dec 14, 2014 at 12:13 PM, Tim Smith
wrote:
> Try http://brendangregg.com/
>
> Lots of great tidbits there from a guy who really knows his performance
> stuff (ex-Sun, now Netflix)
that the slave in question is not serving any connections.
>From what I remember emptying out the archive_command would pause log
shipping. Can the same be done by issuing a pg_stop_backup()?
Thanks,
-Joseph Kregloh
1 - 100 of 533 matches
Mail list logo
