or why they mattered, but each week I run pg_dumpall and
save the .sql file in a database_backup/ directory.
This does not answer your specific questions but does offer a strategy for
future operations.
HTH,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Thanks for confirming.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The syntax for inserting data into a table uses single quotes to identify
strings. When I have a string such as O'Brien do I double the single quotes
within the string (i.e., 'O''Brien') or is there another way to include such
strings?
Rich
--
Sent via pgsql-ge
sync and records only changes since
the last run. I use it to back up my server/workstation daily. I've restored
files accidently deleted with no problems using either cp or rsync.
That's my $0.25 worth (inflation, you know).
Regards,
Rich
--
Sent via pgsql-general mailing list (pg
file anywhere in the source or build trees so I've no idea from
where this unworkable version came.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
its should have been changed to
something else.
It certainly wasn't working before if it was like this, either.
Tom,
I've no idea how the file was changed, but something certainly happened to
it. Restoring pg_hba.conf from 2016-09-17 (when pg-9.5.1 was installed)
certainly fixed
On Fri, 10 Mar 2017, Rich Shepard wrote:
Actually, it has the modifications I've made over the years. That's why I
could not see what changed.
Well, postgres was running yesterday and allowed me to access my
bookkeeping software so obviously something did change without my manual
On Fri, 10 Mar 2017, Brian Dunavant wrote:
I believe the following test should answer your question.
Thank you, Brian. It does answer my question.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
new one is available. This is a new error for me.
In any case, you should be able to fix it by making a copy of your
pre-upgrade pg_hba.conf and shoving that back into the data directory
afterwards;
I'll restore a backup copy from last month.
Thanks,
Rich
--
Sent via pgsql-
NG is exactly
what I want to include in the command. Have I correctly interpreted what the
DO NOTHING option does when a row to be inserted already is present in the
table?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
5. Tried commenting out that line to match backup, but that also did not
allow postgres to start.
6. All files are owned by postgres.users.
Please teach me how to fix this.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, 25 Feb 2017, Rich Shepard wrote:
Just installed postgresql-9.6.2 on Slackware-14.2/x86_64 and initialized
the database. However, there's no /usr/lib/postgresql/ directory with its
subdirectories.
Duh! It's in /usr/lib64/postgresql.
Sigh,
Rich
--
Sent via pgsql-gener
nfiguration process or create a symlink .
Well, sure. As long as I provide grass with the proper path in the config
file it's happy.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Builds.org build script which I've
used for many years so I don't know where to start looking for the reason
there's no postgres lib/ directory.
Diagnostic help appreciated.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On Tue, 17 Jan 2017, Tom Lane wrote:
Use psql's \copy instead.
Thanks, Tom.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
user, can copy tables
directly to ~/?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
problem. It's now fixed.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
than that.
That fixed all but one error which I'll address.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nicipalities',
'Ports/Marine Services', 'Transportation')),
status varchar(20) NOT NULL
CONSTRAINT invalid_status
CHECK (status in ('Client', 'Proposal submitted', 'Prospect',
'Referral', 'Opportunity', 'No further contact')),
comment text
);
Also, you can't just write double commas to leave out a item in the
value list. You could write DEFAULT there, ie
I tried with ,, and ,'', and ,' '. Same error each time. Also, listing
each column name does not fix the problem.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ies VALUES (AG Spray Inc.,,PO Box 12129,Sa...
If you're not specifying the column names, then the VALUES list must
have the same number of values, in the same order as the columns
defined on the table.
As I wrote in the original message, I did this.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ng that is column 2. The error message does not print
the integer PK. If it matters, I have all 14 columns specified but not
explicitly named in the INSERT INTO command.
I've looked in the manual without learning how to INSERT data in a table
with a serial PK and need to learn how to
David,
I forgot about that. Thanks for pointing it out to me.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
m', 'gpm')),
Seems to me that if values are constrained by a list a NULL cannot be
entered by the user. Is this correct?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
Happy New Year,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
default value.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reading the 9.6 docs suggests an answer to my question, but does not
explicitly answer it, so I ask here.
If a column has a default value specified does this mean the column cannot
contain a NULL value? In other words, is DEFAULT NOT NULL
redundant?
TIA,
Rich
--
Sent via pgsql-general
On Thu, 29 Dec 2016, Guyren Howe wrote:
I would like to find a book or other resource about SQL server-side
programming (stored procedures etc) best practices in general and for
Postgres in particular.
Start here:
<http://www.postgresqltutorial.com/postgresql-stored-procedures/>
On Thu, 29 Dec 2016, Nicolas Paris wrote:
Hi I'd like to tell about Sql Power Architect
Nicholas,
SPA was going to be my next re-examination after dbeaver. Since the latter
easily accomplished what I needed I stopped there.
Thanks for the reminder,
Rich
--
Sent via pgsql-ge
I can test as I
develop.
Happy new year to you,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nd my wishes for a healthy, happy, and
prosperous 2017 to you and all who responded to my question,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ails.
HTH,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
en I get the large database application
up and running I'll post it on github and turn it loose into the F/OSS world
under the GPL.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, 27 Dec 2016, Adrian Klaver wrote:
As it happens there is a Python version of the a fore mentioned faker:
https://pypi.python.org/pypi/Faker/0.7.7
Adrian,
Impressive and complete. It will generate all the data I need.
Many thanks,
Rich
--
Sent via pgsql-general mailing list
On Tue, 27 Dec 2016, Adrian Klaver wrote:
As it happens there is a Python version of the a fore mentioned faker:
https://pypi.python.org/pypi/Faker/0.7.7
It was I use to generate fake/sample data.
Adrian,
Aha! That's a great start for me.
Many thanks,
Rich
--
Sent via pgsql-ge
neric
data of the appropriate types myself.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
streets, etc.
Steve,
Thanks very much for the URL. One application is small (7 tables), the
other is three times that size (23 tables). If I need to find public domain
data on the Web, I'll do that.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
ach work for you?
Greg,
I work in Python, not Ruby, so this might be too big of a hurdle.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ed on each table's schema?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mples in 5.3.1 have a "(" following the word CHECK as well...
Yes, I see now that I misplaced the opening parenthesis and missed the
second closing parenthesis at the end of the IN list.
I thought I had tested this syntax; obviously I did not.
Thanks,
Rich
--
Sent via pgsql-
'City',...
^
Having a default value or a named constraint makes no difference, and the
maximum size of the org_lvl column is that of the longest string so I am not
seeing the source of my error.
Where, other than Section 5.3.1 of the manual can I learn why
that what you wanted to put in Weather_Data is a two-column FK:
FOREIGN KEY (site_id, param) REFERENCES Weather_Params (site_id, param)
That would match Weather_Params' pkey, so it's enough to identify a
unique row of Weather_Params.
Thanks, Tom. Yes, I do want a 2-colum
traint matching given keys for referenced
table "weather_params".
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
beginning to suspect there is a problem with the binary that I downloaded from the postgres site. When I execute ldd -r /usr/postgres/9.6-pgdg/lib/libpqwalreceiver.so there are many symbols not found. I do not know what to make of it just yet. I did reinstall.Regards,Rich Rutkowskir
will return the correct value only in the usr login. The question then is if postgres is running as usr postgres how does it know the value of LD_LIBRARY_PATH. Isn't there another place where it must be set?Regards,Rich Rutkowskir...@salepointdata.com
Original Message
S
Hello List, I am setting up Postgres 9.6 for streaming replication. The OS is Solaris X86 I downloaded the postgres solaris binaries from the Postres site and installed on 2 instances of Solaris 10. I then used pg_dumpall to load the master server with data from our devel0pment server. That
cade of wxPython use with
Python2 and am just about ready to start creating the UI.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to make my CRM a stand-alone application.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rogramming, too), you'd be better off learning Python first and
looking beyond that only when you hit a dead end.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
between the database back
end and the user interface, and a widget set (PyQt5 is a good one) for the
UI.
If you want to develop a web-based application then replace the UI with
django.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
much more pleasant to work with.
They're not referenced frequently, only occasionally.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 8 Dec 2016, Adrian Klaver wrote:
http://initd.org/psycopg/docs/usage.html?highlight=binary#adapt-binary
Thanks again, Adrian.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
;ll read how to work with it.
Thanks very much for your insights,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
l see only the entire application.
Thanks for explaining,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have used '-- ' to enter comments about tables or columns and am curious
about the value of storing comments in tables using the COMMENT key word.
When is the latter more appropriate than the former?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On Tue, 6 Dec 2016, John R Pierce wrote:
indeed BYTEA is postgres's type for storing arbitrary binary objects that
are called BLOB in certain other databases.
John,
I thought so.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
same as a bytea (page 217 of the
9.6 PDF manual), and I cannot find BLOB as a postgres data type. Please
point me in the right direction to learn how to store PDFs as BLOBs.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Tue, 6 Dec 2016, Joshua D. Drake wrote:
Due to the widely variable size of a PDF document, I would say no. I would
store the metadata and file location.
Joshua,
I read your answer as "don't store them in the database, but store the
location in a column."
Thanks for co
tenance records, etc.
My thinking is to not store these documents in the database, but to store
them in subdirectories outside the database.
Your thoughts?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
in a stand-alone application
that can be packaged for easy installation and use by clients.
Thanks very much for your suggestions,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 5 Dec 2016, Johann Spies wrote:
Web2py is another (and maybe simpler) alternative to Django.
Johann,
Thank you. I'll look at it.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
of the
time. But, I'll look again at the Python3 version called Phoenix and Peewee
(a lighter ORM than SQLAlchemy).
Sorry if I went off into left field on this.
That's fine. All ideas are always welcome.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general
at my clients use. Long ago I looked at flask; that might be worth a
second look. I'm also seriously looking at peewee, which is an ORM simpler
than SQLAlchemy, and the Phoenix toolkit for the UI.
Thanks very much,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
this for mine). I would provide some guidance on installing necessary
software, but it's theirs to use as they choose.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
over the past few years looking for a simpler
solution and they just don't exist.
I'll learn django and take it step-by-step.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
.
My clients all run Windows about which I know nothing. Is there a GUI for
postgres that works on all platforms and suitable for someone like me?
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
efore being imported into Base?
All tips and gotcha's for a new user are certainly welcome.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you'll need customer, invoice, line-item tables at the minimum. But
since I use it only to generate service invoices and post them to accounts
payable I don't know the details of how it works. I do use postgres
(currently -9.6.1) and httpd with it.
HTH,
Rich
--
Sent via pgsql-gene
oe Celko's
books; they're very helpful.
Only you and your client know just what's needed. This approach will open
your client to data/information they need that is not provided by their
current software and will provide you the basis for designing the postgres
schemas.
Rich
--
Sent
:)
Adrian, et al.:
Did a pg_dumpall and stored it with my database-backups. Now that I know
where to find the bin/ directories pg_upgrade ran flawlessly. Quick and
easy.
Thanks all,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
only list them, but access them from the command line. This is what
I'm trying to understand.
Regardless, I'll stop the running postgres, run pg_upgrade, then start it
from the /9.6/data/ directory.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
On Tue, 15 Nov 2016, Rich Shepard wrote:
$ /usr/bin/pg_ctl --version
pg_ctl (PostgreSQL) 9.6.1
ls -al /usr/bin/pg_ctl
lrwxrwxrwx 1 root root 32 Nov 15 14:16 /usr/bin/pg_ctl ->
../lib/postgresql/9.6/bin/pg_ctl*
To increase my understanding I want to resolve an apparent discrepancy
r/bin/pg_ctl ->
../lib/postgresql/9.6/bin/pg_ctl*
Aha! That's where the bin/ directories are. There's a 9.3.4/ and 9.5/
subdirectory there, too.
Will do a pg_dumpall and then run pg_upgrade.
Thanks, both of you. I learned valuable lessons,
Rich
--
Sent via pgsql-general mailing l
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Rich is using Slackware and I am pretty sure it marches to a different
drummer.
Adrian,
And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL
is not part of the base distribution. But, SlackBuilds.org provides a build
script
ake life easier.
Currently, only 9.5.4 is running; 9.6.1 is installed and initiated but not
running. When I invoke 'psql -l' I see the clusters installed in 9.5.4.
Will use pg_dumpall and pg_restore ... tomorrow morning.
Thanks very much,
Rich
--
Sent via pgsql-general mailin
re no /bin directories associated with postgres.
So, I'll go the pg_dumpall route then.
Thanks very much,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
do I look for the two bindirs?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
expressing my
search terms.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, 29 Oct 2016, Tom Lane wrote:
What does U1 represent?
Unique constraint, perhaps? I'm just guessing.
Tom,
That's my guess, too. I've not seen it used before now and did not know if
it's a standard code for something or one specific to this agency.
Thanks,
using (but suspect Oracle). My
web search used in-effective terms so I could not find the answer there.
What does U1 represent?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 27 Oct 2016, John R Pierce wrote:
CREATE TABLE newtable AS SELECT ...
https://www.postgresql.org/docs/9.5/static/sql-createtableas.html
Thank you, John.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
7;Cr' or
param = 'Cu';
If you point me to the appropriate page in the 9.5.x manual I'll figure it
out.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, 30 Sep 2016, Tom Lane wrote:
Wrong permissions on /dev/shm, perhaps?
Tom,
Yes. I keep forgetting about this since I don't reboot this
server/workstation often.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
On Fri, 30 Sep 2016, Adrian Klaver wrote:
See here:
https://www.postgresql.org/message-id/24208.1473724630%40sss.pgh.pa.us
Ah, shoot! I completely forgot about this. Yes, I reset the perms on
/dev/shm and that fixed the problem.
My apologies to all,
Rich
--
Sent via pgsql-general
PostgreSQL.1804289383": Permission denied
Please advise me on how I proceed to clear this and restart the
application.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 12 Sep 2016, Tom Lane wrote:
Hmm, AFAIK that's what it should be out of the box. Certainly on my RHEL6
machine I see
Until I make the time to upgrade this host from Slackware-14.1 to -14.2
the kernel is 3.10.17-smp.
Rich
--
Sent via pgsql-general mailing list (pgsql-ge
sions
(755). Thanks to your response I remembered that chromium does not run until
I follow its advice to chmod 1777 /dev/shm. Sure enough, chromium would not
load.
So, I changed the perms on /dev/shm/ and now both postgres and chromium
work.
Very much appreciated,
Rich
--
Sent via pgsql-general ma
open shared memory segment
"/PostgreSQL.1804289383": Permission denied
Not before encountering this problem I've no idea where to look to see how
to fix it. Please advise.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Wed, 7 Sep 2016, Patrick B wrote:
2 - I've never done a Postgres upgrade before, can you give some guide
here? Is usually a easy thing? How long can it take? Is a downtime needed?
Patrick,
I suggest the place to start is 'man pg_upgrade.' It is helpful.
Rich
--
Sent vi
and I enter my username and password on the login
page. It works with auth method trust. I've no idea exactly how it connects
to the database. Since it ain't broke I won't futz with it and possibly
break it. I've other things with higher priorities.
Rich
--
Sent via pgsql-
t is not a mechanism for entering that information into
the database. So yes, you will need to use ALTER ROLE to create the
password inside Postgres.
OK. I'll try that for the learning experience.
So much to learn and so little time ...
Thanks,
Rich
--
Sent via pgsql-general mail
, given my single-user situation do you think that I should ALTER ROLE
to add my password? Adding it to ~/.pgpass did nothing positive when I
changed auth method to md5; my attempt to open a database failed because
that password was rejected. Strange ... to me.
Rich
--
Sent via pgsql-general ma
with the authorization method set to md5 was because
the password field was missing.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
system tables pg_user and pg_shadow:
https://www.postgresql.org/docs/9.5/static/catalogs.html
I see the pg_user in Section 49.79 but don't know how to correctly
configure it. It seems that pg_shadow is unnecessary since I don't need to
provide compatibility with versions < 8.1.
R
he URL you provided and add a password for
me, too.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
system tables pg_user and pg_shadow:
https://www.postgresql.org/docs/9.5/static/catalogs.html
Adrian,
I did not know this. Thanks for the information.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
fore set
a password specifically for postgresql. Since I'm the only user and the
trust authentification has worked for the same period, I'll leve it that
way.
Thanks for your help,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
start does not work[1] I
stopped the process then restarted it. I can now access my databases and the
financial software via the browser UI.
Now I can remove the 9.3.4 directory and be comfortable that the next
upgrade will be smooth.
Thanks very much for your patient help!
Much appreciated,
user postgres:
psql (9.5.4)
Type "help" for help.
postgres=#
So, it appears to be a password issue. Please advise me how to get the
running postmaster process to accept my accessing databases without a
password being required.
Thanks again,
Rich
--
Sent via pgsql-general mailing list
ADIR
--locale=en_US.UTF-8 -A md5 -W\""
exit 6
fi
Note the '-W' at the end. But, I ran initdb from the command line as user
postgres.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hepard | UTF8 | C | en_US.UTF-8 | rshepard=CT
I did not recognize this as the answer to Charles' question.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 720 matches
Mail list logo