Just wanted to follow up that re-installing Postgres worked (well almost—I did
have to reset the permissions and ownership on the key and pem file).
Thanks so much for all the help.
-Shawn
> On Feb 15, 2017, at 9:49 AM, Adrian Klaver wrote:
>
> On 02/15/2017 09:45 AM, Shawn Tho
Yes, definitely.
> On Feb 15, 2017, at 9:49 AM, Adrian Klaver wrote:
>
> On 02/15/2017 09:45 AM, Shawn Thomas wrote:
>> Which would you recommend? Leave the data directory in place and
>> re-install PG or copy it to somewhere else, delete it and then
>> re-instal
Yes, sadly it does explain things. Your insight has been super helpful though.
-Shawn
> On Feb 15, 2017, at 9:38 AM, Adrian Klaver wrote:
>
> On 02/15/2017 09:28 AM, Shawn Thomas wrote:
>> Well that would make more sense of things. I had removed and
>> re-installed
Which would you recommend? Leave the data directory in place and re-install PG
or copy it to somewhere else, delete it and then re-install PG?
-Shawn
> On Feb 15, 2017, at 9:36 AM, Magnus Hagander wrote:
>
> On Wed, Feb 15, 2017 at 6:28 PM, Shawn Thomas <mailto:thoma...@u.wa
get the database back in place.
-Shawn
> On Feb 15, 2017, at 9:01 AM, Adrian Klaver wrote:
>
> On 02/15/2017 08:35 AM, Shawn Thomas wrote:
>> Yes, that’s the correct sequence of scripts. And no there’s not anything
>> really helpful in the system logs.
>>
>>
directory into the newly installed one, will there
be an xlog issue?
-Shawn
> On Feb 15, 2017, at 9:09 AM, Magnus Hagander wrote:
>
> On Wed, Feb 15, 2017 at 6:03 PM, Shawn Thomas <mailto:thoma...@u.washington.edu>> wrote:
> /usr/lib/postgresql/9.4/bin/pg_ctl: No such file or di
, this Debian package removes pg_ctl from the bin directory and
instead attempts to wrap the pg_ctl functionality in a perl script so that the
PG process is integrated with systemd. I really wish they hadn’t, and it’s
part of the reason I’m where I’m at.
-Shawn
> On Feb 15, 2017, at 8:49
initial server and read the databases
back into it.
Any advice on how to best go about this? The official documentation seems a
bit thin:
https://www.postgresql.org/docs/9.4/static/backup-file.html
I’ve only worked with normal (pg_dump, pg_dumpall) backups in the past.
-Shawn
> On Feb
systemctl status postgresql@9.4-main.service -l
Error: could not exec start -D /var/lib/postgresql/9.4/main -l
/var/log/postgresql/postgresql-9.4-main.log -s -o -c
config_file="/etc/postgresql/9.4/main/postgresql.conf”
Thanks, though.
-Shawn
> On Feb 14, 2017, at 5:12 PM, Adrian Klave
-o -c
config_file="/etc/postgresql/9.4/main/postgresql.conf”
-Shawn
> On Feb 14, 2017, at 11:52 AM, Magnus Hagander wrote:
>
> On Tue, Feb 14, 2017 at 8:47 PM, Joshua D. Drake <mailto:j...@commandprompt.com>> wrote:
> On 02/14/2017 11:43 AM, Shawn Thomas wrote:
> pangaea:/v
)
Main PID: 28668 (code=exited, status=0/SUCCESS)
CGroup: /system.slice/postgresql.service
-Shawn
> On Feb 14, 2017, at 11:31 AM, Joshua D. Drake wrote:
>
> On 02/14/2017 11:17 AM, Shawn Thomas wrote:
>> I inadvertently deleted the ssl-cert-snakeoil.pem out from under a runni
nf" :
pangaea systemd[1]: postgresql@9.4-main.service: control process exited,
code=exited status=1
Any help/advice would be greatly appreciated.
-Shawn
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi everyone,
Apologies if this is answered elsewhere (quick search didn't find anything). I
have noticed that MSVC 2005 is supported for 32-bit Postgres server compilation
but not 64-bit. Are there known issues limiting this, or just nobody has
worked on it yet?
Thanks,
Shawn
--
Sen
have been installing this on both Windows 7 x86 and x64 systems, Home, Pro
and Ultimate. The Professional version is in a network setting connected to an
internal netork.
Shawn M Eckley
Software Engineer
Stonewedge Corporation
240 Andover st.
Wilmington, MA 01887
978-203-0642 Ext. 113
se
x, y, z, ..." at the beginning of the file and
of course schemas x, y, z, etc hadn't been created yet. So there's no
real cause for alarm after all.
On Fri, Apr 15, 2011 at 10:23 AM, Adrian Klaver wrote:
> On Friday, April 15, 2011 7:10:00 am Shawn Gennaria wrote:
>
&g
On Fri, Apr 15, 2011 at 9:32 AM, Adrian Klaver wrote:
> On Friday, April 15, 2011 5:25:51 am Shawn Gennaria wrote:
>> Hi all,
>>
>> I'm in the process of migrating our data from 8.4 to 9.0.3 on a
>> different server, both running Ubuntu. My initial attempt invo
Hi all,
I'm in the process of migrating our data from 8.4 to 9.0.3 on a
different server, both running Ubuntu. My initial attempt involved
running pg_dumpall (from the 9.0.3 version) on the entire 8.4 cluster,
putting all of the schemas, data and everything into one giant file.
Jumping ahead, I a
Rancho Santa Margarita, CA -- 1 May 2007 -- theKompany.com, producers
and distributors of high-quality open source and commercial Linux
software, are pleased to announce the release of DataArchitect 4.0.
DataArchitect is a powerful tool that provides ERD capability like
PowerDesigner as well as t
racle, i.e A Table
that has many of itself. Is there any equivalent in
PostgreSQL? Our data has lot's and lot's of trees.
Shawn
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
h
Mark,
ERwin is way to go...Mark Borins <[EMAIL PROTECTED]> wrote:
Postgres Newsgroup,
My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product called DBWrench which is p
"Mike Cox" <[EMAIL PROTECTED]> wrote in message
Well, yes. You have to be a member of the mailing list you want to
post to even if you are posting through usenet. Otherwise your post
will bounce to you *email* account. Half of those who respond even
when you are a member of the list, respond via
Shawn Harrison wrote [01/28/05 3:53 PM]:
I have a table like this:
create table objects (
id serial primary key,
name varchar not null,
parent integer references objects(id) default 1 not null,
urivarchar not null
) without oids;
The uri column is a denormalization
Shawn Harrison wrote [01/31/05 12:56 PM]:
Shawn Harrison wrote [01/28/05 3:53 PM]:
create or replace rule objects__update as on update to objects
do instead (
update objects_data set
name = new.name,
typename = new.typename,
parent = new.parent
PFC wrote [01/28/05 7:08 PM]:
First you should use a ltree type for the uri field :
Yes, it would be very good if I could use ltree rather than rolling my
own, but ltree doesn't meet my use requirements.
- you write it foo.bar instead of /foo/bar
That is the problem: The point is to make look
lution to my problem.
Best regards,
Andrey V. Semyonov
Take care,
Shawn Harrison
--
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comman
e, and play with permissions? (Yuck.) Do I need to bite the
bullet, go back to cascading triggers, and work out the data visibility
voodoo and the efficiency issue? Or is there a better way that I haven't
thought of?
Thanks,
Shawn Harrison
--
[EMAIL PROTECTED]
Frank D. Engel, Jr. wrote [01/27/05 9:19 AM]:
On Jan 26, 2005, at 6:57 PM, PFC wrote:
Isn't there some free open source algebraic computation toolkit with
equations and units somewhere ?
A very simple but effective system that I have used quite a lot for
"computation with units" is a Python modul
Craig Bryden wrote [01/07/05 3:46 AM]:
Hi
I have vast experience working with MS-SQL. Which books would be good
for me to use in order to teach myself PostgreSQL? I need to migrate a
MS-SQL Db to PostgreSQL. It contains tablers,views,stored procs, and
user defined functions.
With no other RDBMS
at the real solution is to make the foreign key locks shared so these
kinds of hacks arent necessary, unfortunately I have to make do with the present state
of things.
Thanks,
Shawn
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Monday, September 27, 2004 11:35 PM
T
Hi, I am trying to deal with a deadlock situation caused by foreign key references on
insert and I was wondering if anyone knows what order the foreign keys are locked (or
evaluated) in for a particular table? Deferring the locks is unfortunately not a good
option for me...
Thanks,
Shawn
Joe,
That's cool! Thanks for the tip. It looks like your "branch" is my
"ancestry". I'll look in contrib more often. I could use connectby() instead
of my homebrew plpgsql functions.
Shawn
- Original Message -
From: "Joe Conway" <[EMA
view articles_objects (
select documents_objects.*, title from documents_objects, articles
where documents_objects.id = articles.id;
FWIW,
Shawn Harrison
- Original Message -
From: "Alex Satrapa" <[EMAIL PROTECTED]>
To: "PostgreSQL General" <[EMAIL PROTECTED
y be fixed in a future release. My
question is, are there any definite plans in that direction at this point?
Take care,
Shawn Harrison
---(end of broadcast)---
TIP 8: explain analyze is your friend
Have you tried drop sequence?
On Sat, 31 Mar 2001, Jeff wrote:
> Hi,
>
> I've accidently deleted the file employees.key.seq, however there's still an
> entry in pg_class.
>
> It would not allow me to create employees.key.seq anymore because it thinks
> it already exists.
>
> How can I delete it
I was just wondering if using views offered any sort of a performance
increase when designing my database.
Shawn
colD
and then do the calculations within PHP?
Shawn
Putting the WHERE clause before the GROUP BY clause worked. I'm too
stupid or too tired to think clearly. :)
Thanks all
Shawn
On Tue, 14 Nov 2000, Michael Fork wrote:
> Try these queries...
>
> SELECT injdate, outcome, count(outcome) FROM safety GROUP BY
> injdate,outcome;
e
WHERE InjDate='2000-11'14';
Any tips or advice would be apreciated.
Shawn
rns a
random number.
Is this possible? Is there a better way to do this on the database
side. I could do it through code in the application, I'd just prefer not
to.
Shawn
I may be horriblly out of my element here but, I'm going to jump in anyway
:)
If you mount a floppy and copy a large file to it, you will get a prompt
back fairly quickly.
If you type: sync right after
The sync command writes everything to the floppy as expected.
Shawn
On Tue, 31 Oct
re-order
themselves?
Thanks in advance.
Shawn
---
Shawn T. Walker <---> [EMAIL PROTECTED]
ble
Do you spot anything else wrong? I tried to emacs pg_shadow, but that is
one ugly files that looks compiled. I did see that powner resides in there.
Shawn
42 matches
Mail list logo
